<?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_service  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['img'];



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

						                                             $fmgg = $fe_img;



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



                                                   

                                                    $newThumb = $_FILES['do_photo']['name'];

                                                    $thumbPath = "../service/" . $newThumb;

                                                    move_uploaded_file($_FILES['do_photo']['tmp_name'], $thumbPath);

                                                   	

                                                    $fmgg = $newThumb;



                                                     unlink("../service/" . $fe_img);

                                                  }



 $SQL = "UPDATE tbl_service  set name='$name',img='$fmgg',category_id='$cat' where id='$bid'

";

    

    

          if ($con->query($SQL) === TRUE) {

       

        

      echo "<script>;

        alert('Data Edit Succesfully');

                window.location.href='../service_list.php';

                </script>";



   }

   else

   {

      echo "<script>;

        alert('Your was not Edit Succesfully');

                window.location.href='../service_list.php';

                </script>";

   }

  





?>