<?php
session_start();
include '../Includes/db.php';
 // include'../compression.php';

// $uid = $_SESSION["userId"];

 date_default_timezone_set('Asia/Kolkata');
 $cudate = date("Y-m-d") ;

extract($_POST);

 $bid  = $_GET['id'];

 $sql = "select * from tbl_details where id='$bid'";
$sql_res = mysqli_query($con, $sql) or die(mysqli_error($con));
$sql_row = mysqli_fetch_assoc($sql_res);
 $fe_img = $sql_row['img1'];
 $fe_img1 = $sql_row['img2'];

    $dr_photo =  $_FILES['do_photo']['name'];
                                                         $fmgg = $fe_img;

 if(strlen($_FILES['do_photo']['name']) != 0) {

                                                   
                                                    $newThumb = $_FILES['do_photo']['name'];
                                                    $thumbPath = "../details/" . $newThumb;
                                                    move_uploaded_file($_FILES['do_photo']['tmp_name'], $thumbPath);
                                                    
                                                    $fmgg = $newThumb;

                                                     unlink("../details/" . $fe_img);
                                                  }
                                                  
                                                   $dr_photo =  $_FILES['do_photo1']['name'];
                                                         $fmgg1 = $fe_img1;

 if(strlen($_FILES['do_photo1']['name']) != 0) {

                                                   
                                                    $newThumb = $_FILES['do_photo1']['name'];
                                                    $thumbPath = "../details/" . $newThumb;
                                                    move_uploaded_file($_FILES['do_photo1']['tmp_name'], $thumbPath);
                                                    
                                                    $fmgg1 = $newThumb;

                                                     unlink("../details/" . $fe_img1);
                                                  }


                                                     $desc1s = mysqli_real_escape_string($con, $desc1);
    $desc2s = mysqli_real_escape_string($con, $desc2);
    $desc3s = mysqli_real_escape_string($con, $desc3);
    $desc4s = mysqli_real_escape_string($con, $desc4);
                                                        
                                                   

 $SQL = "UPDATE tbl_details  set cat='$cat',name='$name',desc1='$desc1s',img1='$fmgg',desc2='$desc2s',desc3='$desc3s',img2='$fmgg1',desc4='$desc4s' where id='$bid'
";
    
    
          if ($con->query($SQL) === TRUE) {
       
        
      echo "<script>;
        alert('Data Edit Succesfully');
                window.location.href='../details_list.php';
                </script>";

   }
   else
   {
      echo "<script>;
        alert('Data not Edit Succesfully');
                window.location.href='../details_list.php';
                </script>";
   }
  


?>