问从数据库中收集所有信息

EN

$id = ''; 
if( isset( $_GET['id'])) {
    $id = $_GET['id']; 
}       
$sql = "SELECT * FROM products WHERE category = 'Accessories'";
$result = mysqli_query($con, $sql);
$resultCheck = mysqli_num_rows($result);

if ($result->num_rows > 0) {

    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo $item_number = $row["item_number"];
        $price = $row["price"];
        $desc = $row["description"];
        $category = $row["category"];
    }
}

<table width="100%" border="2" cellspacing="0" cellpadding="15">
    <tr>
        <td width="19%" valign="top"><img src="pictures/inventory/<?php echo $pid; ?>.jpg" width="142" height="188" alt="<?php echo $item_number; ?>" /><br />
            <a href="pictures/inventory/<?php echo $pid; ?>.pngjpg">View Full Size Image</a>
        </td>
        <td width="81%" valign="top">
            <h3 class="Item"><?php echo $item_number; ?></h3>
            <p>
                <?php echo "$".$price; ?>
                <br />
                <br />
                <?php echo $desc; ?>
                <br />
            </p>
            <form  id="form1" name="form1" method="post" action="cart.php">
                <input type="hidden" name="pid" id="pid" value="<?php echo $pid; ?>" />
                <input class="button" type="submit" name="button" id="button" value="Add to Shopping Cart" />
            </form>
        </td>
    </tr>
</table>