<?php
        $link1 = 'buy.php';
        $link2 = 'login.php';
        $user = 'iamadmin';
        $pass = '11111';
        $host = 'localhost';
        $db = 'kouri_database';

        $conn = @mysqli_connect($host,$user,$pass) or die('Cannot connect');
        @mysqli_select_db($conn,$db) or die ('Cannot connect to DB');
        //$query = "SELECT * Item_ID FROM product WHERE Product_Type = 'mens'";
        $query = "SELECT * FROM product limit 1 ";


    if($result = mysqli_query($conn,$query))
        {

            while($row = mysqli_fetch_assoc($result))
            {
                  $ID= $row['Item_ID'];
                  $pName = $row['Item_Name'];
                  $pQTY= $row['Item_Qty'];
                  $pPrice= $row['Item_Price'];
                  $pColor= $row['Item_Color'];
                  $pSize= $row['Item_Size'];
                  $pDesc= $row['Item_Description'];
                  $image=$row['Images'];
                  $category = $row['Product_Type'];



                if($category == 'mens')
                {
                    echo '<table  align = "justify">';
                    echo '<tr>';
                    echo '<td bgcolor = "white">'.$pName.'</td>';
                    echo '<td>'."Product Details".'</td>';
                    echo '</tr>';
                    echo '<td> Item ID:'.$ID.'</td>';
                    echo '<tr>';
                    echo '<td>'.$pPrice.'</td>';
                    echo '<td> Quantity:'.$pQTY.'</td>';
                    echo '</tr>';

                    echo '<tr>';
                    //echo '<img src="data:image/jpeg;base64,'.$img_str.'" alt="Alt text" />';

                    echo '<tr>';
                    echo '<td>'."Review product".'</td>';
                    if($log == true)
                        echo "<td><a href = '".$link1."'>Buy Product</a></td>";
                    else
                        echo "<li><a href ='".$link2."'>LOGIN</a></li>";
                    echo '</tr>';

                    echo '</tr>';
                    echo '</table> <br>';
                }

            }
            mysqli_close($conn);
        }

   ?