26 lines
1.3 KiB
PHP
26 lines
1.3 KiB
PHP
<table>
|
|
<tr>
|
|
<th style="text-align: center; border: 1px solid #000;">ID</th>
|
|
<th style="text-align: center; border: 1px solid #000;">Product</th>
|
|
<th style="text-align: center; border: 1px solid #000;">MRP</th>
|
|
<th style="text-align: center; border: 1px solid #000;">Discount</th>
|
|
<th style="text-align: center; border: 1px solid #000;">Price</th>
|
|
<th style="text-align: center; border: 1px solid #000;">Stock</th>
|
|
</tr>
|
|
<?php
|
|
// echo $_GET['category'];
|
|
$link = new mysqli(MYSQL_HOST,MYSQL_USER,MYSQL_PASS,MYSQL_DB);
|
|
$query="SELECT * FROM `".SHOP_ID."_product` WHERE `cat`='".$_GET["category"]."' ORDER BY `id` DESC";
|
|
$result= mysqli_query($link, $query);
|
|
while ($row= mysqli_fetch_assoc($result)) {
|
|
?>
|
|
<tr>
|
|
<td style="border: 1px solid #000;"><?php echo $row['id'] ?></td>
|
|
<td style="border: 1px solid #000;"><?php echo $row['name'] ?></td>
|
|
<td style="border: 1px solid #000;"><?php echo $row['mrp'] ?></td>
|
|
<td style="border: 1px solid #000; color: green;"><?php echo $row['mrp'] - $row['price']?></td>
|
|
<td style="border: 1px solid #000;"><?php echo $row['price'] ?></td>
|
|
<td style="border: 1px solid #000;"><?php echo $row['stock'] ?></td>
|
|
</tr>
|
|
<?php } ?>
|
|
</table>
|