1. <?php
2. include("includes/db.php");
3. $query=mysqli_query($con,"select * from purchased");
4. $rowcount=mysqli_num_rows($query);
5.  
6. ?>
7.  
8. <table border="1" align="center">
9. <tr>
10.  
11. <td>Id</td>
12. <td>Lot #</td>
13. <td>Purchase Date</td>
14. <td>Operator</td>
15. <td>Item Name</td>
16. <td>Quantity</td>
17. <td>Discount</td>
18. <td>Rate</td>
19. <td>Amount</td>
20. </tr>
21. <?php
22.  
23. for($i=1;$i<=$rowcount;$i++)
24. {
25.  
26.         $row=mysqli_fetch_array($query);
27.  
28. ?>
29. <tr>
30. <td><?php echo $row["id"] ?> </td>
31. <td><?php echo $row["lot"] ?> </td>
32. <td><?php echo $row["pdate"] ?></td>
33. <td><?php echo $row["operator"] ?></td>
34. <td><?php echo $row["item_name"] ?></td>
35. <td><?php echo $row["quantity"] ?></td>
36. <td><?php echo $row["discount"] ?></td>
37. <td><?php echo $row["rate"] ?></td>
38. <td><?php echo $row["amount"] ?></td>
39. <td><img src="image/<?php echo $row["file"] ?>" height="150px" width="150px"></td>
40. </tr>
41. <?php
42. }
43. ?>
44.  
45. </table>