File manager - Edit - /home/custbahd/irungikitchen.com/admin/table/index.php
Back
<?php //including the database connection file include_once("config.php"); //fetching data in descending order (lastest entry first) //$result = mysql_query("SELECT * FROM users ORDER BY id DESC"); // mysql_query is deprecated $result = mysqli_query($mysqli, "SELECT * FROM shop ORDER BY id ASC"); // using mysqli_query instead ?> <html> <head> <title>Kerris | Admin ©</title> <style type="text/css"> td { width: 1%; text-align: center; } </style> </head> <body> <a href="add.php">Add Product</a><br/><br/> <table width='100%' border=0> <tr bgcolor='#CCCCCC'> <td>ID</td> <td>Title</td> <td>Category</td> <td>Type</td> <td>Gender</td> <td>Size</td> <td>Package</td> <td>Price</td> <td>Image</td> <td>Update</td> </tr> <?php //while($res = mysql_fetch_array($result)) { // mysql_fetch_array is deprecated, we need to use mysqli_fetch_array while($res = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>".$res['id']."</td>"; echo "<td>".$res['name']."</td>"; echo "<td>"; if ($res['cat']==1) { echo 'Clothings'; } elseif ($res['cat']==2) { echo 'Health Care'; } elseif ($res['cat']==3) { echo 'Bathing & Toiletries'; } elseif ($res['cat']==4) { echo 'Changing'; } elseif ($res['cat']==5) { echo 'Feeding'; } elseif ($res['cat']==6) { echo 'Nursery & Beddings'; } elseif ($res['cat']==7) { echo 'Mom Necessities'; } elseif ($res['cat']==8) { echo 'Gear & Accessories'; } echo "</td>"; echo "<td>"; if ($res['type']==1) { echo "Kids"; } elseif ($res['type']==2) { echo 'Adults'; } echo "</td>"; echo "<td>"; if ($res['gender']==1) { echo "Male"; } elseif ($res['gender']==2) { echo 'Female'; } echo "</td>"; echo "<td>"; if ($res['size']==1) { echo "Small"; } elseif ($res['size']==2) { echo 'Medium'; } elseif ($res['size']==3) { echo 'Large'; } elseif ($res['size']==4) { echo 'XL'; } elseif ($res['size']==5) { echo 'XXL'; } echo "</td>"; echo "<td>"; if ($res['package']==1) { echo "Single"; } elseif ($res['package']==2) { echo 'Double'; } elseif ($res['package']==3) { echo '3 Items'; } elseif ($res['package']==4) { echo '4 Items'; } elseif ($res['package']==5) { echo '5 Items'; } echo "</td>"; echo "<td>".number_format($res['price'])."</td>"; echo "<td><a href=\"image-edit.php?id=$res[id]\"><img src='images/".$res['image']."' width='100%'></a></td>"; echo "<td><a href=\"edit.php?id=$res[id]\">Edit</a> | <a href=\"delete.php?id=$res[id]\" onClick=\"return confirm('Are you sure you want to delete?')\">Delete</a></td>"; echo "</tr>"; } ?> </table> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 2.2 |
proxy
|
phpinfo
|
Settings