 <?php
session_start();
 include 'connect.php';

if (isset($_GET['del_id'])) {
    $id=$_GET['del_id'];
    $projectName=$_GET['del_name'];
    // echo $projectName;
    // exit();
    $sql3 = "DELETE FROM `project_details` WHERE id='$id'";
    // echo $sql3;
    // exit();
    $sqlprojectlist = "DELETE FROM `project_list` WHERE project_name='$projectName'";
    $runprojectlist =$run3=mysqli_query($conn,$sqlprojectlist);
    // echo $sqlprojectlist;
    // exit();
    $run3=mysqli_query($conn,$sql3);
    if($run3==true && $run3==true){
         $_SESSION['success'] = " Project Deleted Succesfully";
       header ("Location: all_projects.php");
    }
    else{
        echo "error";
    }
}


if (isset($_GET['deletePicId'])) {

    $id=$_GET['deletePicId'];
    $key = $_GET['key'];
    $sql="SELECT * FROM `project_details` WHERE id='$id'";
    $run=mysqli_query($conn,$sql);
    $alldata =  mysqli_fetch_assoc($run);
    // print_r($alldata);
    // exit();
   echo $images = $alldata['img'];
    $imgArray = explode( ",",$images);

       unset($imgArray[$key]);
        echo $newImage = implode(",",$imgArray);
        $query = "UPDATE   project_details SET `img`='$newImage' where id ='$id'";
        $exec = mysqli_query($conn,$query);
        // print_r($query);
        // exit();
        if($exec){
        $_SESSION['success'] = " Image Deleted Succesfully";
        
       } else{
        $_SESSION['error'] = " some error occured , try again";
       }
       header('location:editprojects.php?id='.$id);
    }

    
?>