File manager

File manager - Edit - /home/custbahd/irungikitchen.com/admin/table/edit.php

Back
<?php // including the database connection file include_once("config.php"); if(isset($_POST['update'])) { $id = mysqli_real_escape_string($mysqli, $_POST['id']); $name = mysqli_real_escape_string($mysqli, $_POST['name']); $cat = mysqli_real_escape_string($mysqli, $_POST['cat']); $type = mysqli_real_escape_string($mysqli, $_POST['type']); $gender = mysqli_real_escape_string($mysqli, $_POST['gender']); $size = mysqli_real_escape_string($mysqli, $_POST['size']); $package = mysqli_real_escape_string($mysqli, $_POST['package']); $price = mysqli_real_escape_string($mysqli, $_POST['price']); $image = mysqli_real_escape_string($mysqli, $_POST['image']); // checking empty fields if(empty($name) \|\| empty($cat)\|\| empty($type) \|\| empty($gender) \|\| empty($package) \|\| empty($price)) { if(empty($name)) { echo "<font color='red'>Name field is empty.</font><br/>"; } if(empty($cat)) { echo "<font color='red'>Category field is empty.</font><br/>"; } if(empty($type)) { echo "<font color='red'>Type field is empty.</font><br/>"; } if(empty($gender)) { echo "<font color='red'>Gender field is empty.</font><br/>"; } if(empty($package)) { echo "<font color='red'>Package field is empty.</font><br/>"; } if(empty($price)) { echo "<font color='red'>Price field is empty.</font><br/>"; } } else { //updating the table $result = mysqli_query($mysqli, "UPDATE shop SET name='$name',cat='$cat',type='$type',gender='$gender',size='$size',package='$package',price='$price',image='$image' WHERE id=$id"); //redirectig to the display pcode. In our case, it is index.php header("Location: index.php"); } } ?> <?php //getting id from url $id = $_GET['id']; //selecting data associated with this particular id $result = mysqli_query($mysqli, "SELECT * FROM shop WHERE id=$id"); while($res = mysqli_fetch_array($result)) { $name = $res['name']; $cat = $res['cat']; $type = $res['type']; $gender = $res['gender']; $size = $res['size']; $package = $res['package']; $price = $res['price']; $image = $res['image']; } ?> <html> <head> <title>Edit Products</title> </head> <body> <a href="index.php">Home</a> <br/><br/> <form name="form1" method="post" action="edit.php"> <table border="0"> <tr> <td>Name</td> <td><input type="text" name="name" value="<?php echo $name;?>"></td> </tr> <tr> <td>Category</td> <td> <select name="cat" id="Category"> <option value="<?php echo $cat;?>" readonly> <?php if ($cat=="") { echo "Undefined Category"; } elseif ($cat==1) { echo "Clothings"; } elseif ($cat==2) { echo "Health Care"; } elseif ($cat==3) { echo "Bathing & Toiletries"; } elseif ($cat==4) { echo "Changing"; } elseif ($cat==5) { echo "Feeding"; } elseif ($cat==6) { echo "Nursery & Beddings"; } elseif ($cat==7) { echo "Mom Necessities"; } elseif ($cat==8) { echo "Gear & Accessories"; } ?> </option> <option value="1">Clothings</option> <option value="2">Health Care</option> <option value="3">Bathing & Toiletries</option> <option value="4">Changing</option> <option value="5">Feeding</option> <option value="6">Nursery & Beddings</option> <option value="7">Mom Necessities</option> <option value="8">Gear & Accessories</option> </td> </tr> <tr> <td>Type</td> <td> <select name="type" id="type"> <option value="<?php echo $type;?>" readonly> <?php if ($type=="") { echo "Undefined Gender"; } elseif ($type==1) { echo "Kids"; } elseif ($type==2) { echo "Adults"; } ?> </option> <option value="1">Kids</option> <option value="2">Adults</option> </td> </tr> <tr> <td>Gender</td> <td> <?php if ($gender=="") { echo "<input type='radio' name='gender' value='1'> Male"; echo "<input type='radio' name='gender' value='2'> Female"; } elseif ($gender==1) { echo "<input type='radio' name='gender' value='1' checked='checked'> Male"; echo "<input type='radio' name='gender' value='2'> Female"; } elseif ($gender==2) { echo "<input type='radio' name='gender' value='1'> Male";echo "<input type='radio' name='gender' value='2' checked='checked'> Female"; }?> </td> </tr> <tr> <td>Size</td> <td> <?php if ($size=="") { echo "<input type='radio' name='size' value='1'> Small"; echo "<input type='radio' name='size' value='2'> Medium"; echo "<input type='radio' name='size' value='3'> Large"; echo "<input type='radio' name='size' value='4'> XL"; echo "<input type='radio' name='size' value='5'> XXL"; } elseif ($size==1) { echo "<input type='radio' name='size' value='1' checked='checked'> Small"; echo "<input type='radio' name='size' value='2'> Medium"; echo "<input type='radio' name='size' value='3'> Large"; echo "<input type='radio' name='size' value='4'> XL"; echo "<input type='radio' name='size' value='5'> XXL"; } elseif ($size==2) { echo "<input type='radio' name='size' value='1'> Small"; echo "<input type='radio' name='size' value='2' checked='checked'> Medium"; echo "<input type='radio' name='size' value='3'> Large"; echo "<input type='radio' name='size' value='4'> XL"; echo "<input type='radio' name='size' value='5'> XXL"; } elseif ($size==3) { echo "<input type='radio' name='size' value='1'> Small"; echo "<input type='radio' name='size' value='2'> Medium"; echo "<input type='radio' name='size' value='3' checked='checked'> Large"; echo "<input type='radio' name='size' value='4'> XL"; echo "<input type='radio' name='size' value='5'> XXL"; } elseif ($size==4) { echo "<input type='radio' name='size' value='1'> Small"; echo "<input type='radio' name='size' value='2'> Medium"; echo "<input type='radio' name='size' value='3'> Large"; echo "<input type='radio' name='size' value='4' checked='checked'> XL"; echo "<input type='radio' name='size' value='5'> XXL"; } elseif ($size==5) { echo "<input type='radio' name='size' value='1'> Small"; echo "<input type='radio' name='size' value='2'> Medium"; echo "<input type='radio' name='size' value='3'> Large"; echo "<input type='radio' name='size' value='4'> XL"; echo "<input type='radio' name='size' value='5' checked='checked'> XXL"; } ?> </td> </tr> <tr> <td>Package</td> <td> <select name="package" id="package"> <option value="<?php echo $package;?>" readonly> <?php if ($package=="") { echo "Undefined Package"; } elseif ($package==1) { echo "Single"; } elseif ($package==2) { echo "Double"; } elseif ($package==3) { echo "3 Items"; } elseif ($package==4) { echo "4 Items"; } elseif ($package==5) { echo "5 Items"; } ?> </option> <option value="1">Single</option> <option value="2">Double</option> <option value="3">3 Items</option> <option value="4">4 Items</option> <option value="5">5 Items</option> </td> </tr> <tr> <td>Price</td> <td><input type="text" name="price" value="<?php echo $price;?>"></td> </tr> <tr> <td>Image</td> <td><?php echo "<a href=\"image-edit.php?id=$id\"><img src='images/$image' width='100px' height='100px'></a>";?> </td> <td><input type="hidden" name="image" value="<?php echo $image;?>"></td> </tr> <tr> <td><input type="hidden" name="id" value=<?php echo $_GET['id'];?>></td> <td><input type="submit" name="update" value="Update"></td> </tr> </table> </form> </body> </html>

| ver. 1.4 | Github | . | PHP 8.1.33 | Generation time: 2.2 | proxy | phpinfo | Settings