-
Notifications
You must be signed in to change notification settings - Fork 0
/
getpro.php
34 lines (30 loc) · 951 Bytes
/
getpro.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
<?php
include 'connection.php';
$sql="SELECT * FROM products ORDER BY pro_id ASC";
$result = mysqli_query($conn,$sql);
echo "<table>
<tr>
<th>Image</th>
<th>ID</th>
<th>Product Name</th>
<th>Category ID</th>
<th>Price</th>
<th>Size</th>
<th>Details</th>
<th>Function</th>
</tr>";
while($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td><img style='width: 100%' src='" . $row['pro_img'] . "'></img></td>";
echo "<td>" . $row['pro_id'] . "</td>";
echo "<td>" . $row['pro_name'] . "</td>";
echo "<td>" . $row['cat_id'] . "</td>";
echo "<td>" . $row['price'] . "</td>";
echo "<td>" . $row['size'] . "</td>";
echo "<td>" . $row['details'] . "</td>";
echo "<td> <form method='post' action=''><input type='hidden' name='p_id' value='". $row["pro_id"] ."' /> <button type='submit' name='deletepro'> Delete </button> </form></td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($conn);
?>