<?php 

session_start();
include 'connect.php';

if (isset($_POST['submit'])) {
   $id =$_GET['id'];
       
   $projectname=$_POST['project_name'];
   $oldProjectname=$_POST['project_name_old'];
  $projectdes=mysqli_real_escape_string($conn,$_POST['project_description']);
  $projectlocation=mysqli_real_escape_string($conn,$_POST['project_location']);
  $projectspec=mysqli_real_escape_string($conn,$_POST['project_spec']);
  $projectame=mysqli_real_escape_string($conn,$_POST['project_amenities']);
  $projectspl=mysqli_real_escape_string($conn,$_POST['spl_info']);
 $uploads_dir = '../assets/images/project-img/';
$imageName = [];

$imgArray = [];
$fileNames ='';
   if($_FILES['images']['name'][0] !==''){
foreach($_FILES['images']['name'] as $key => $file){
    $tmp_name = $_FILES["images"]["tmp_name"][$key];
    $file = str_replace(' ','_',$file);
   move_uploaded_file($tmp_name, "$uploads_dir/$file");
    array_push($imageName,$file);

}
 }
    
         $imgquery = "SELECT * FROM `project_details` where id ='$id'";
        
            $alldata=mysqli_query($conn,$imgquery);
            $projectDetails =  mysqli_fetch_assoc($alldata);
             // print_r($projectDetails);
             // exit();
            
       
if($projectDetails['img']){
    $imgArray = explode(",",$projectDetails['img']);
//     print_r($imgArray);
// exit();
  }


$imageNameNew = array_merge($imgArray,$imageName);
// print_r($imageNameNew);
// exit();
        $fileNames = implode(",",$imageNameNew);
       

    $sql="UPDATE `project_details` SET `project_name`='$projectname',`project_des`='$projectdes',`project_location`='$projectlocation',`project_spe`='$projectspec',`project_ame`='$projectame',`special_info`='$projectspl',`img`='$fileNames' WHERE id= $id";
    
 // print_r($sql);
 //     exit();
    $run=mysqli_query($conn,$sql);


     $sqlforarea="UPDATE `project_list` SET `project_name`='$projectname' WHERE project_name= '$oldProjectname'";
     $runarea=mysqli_query($conn,$sqlforarea);
     // print_r($projectlist);
     // exit();
    if($runarea==true && $run==true){
        $_SESSION['success'] = "Project Update Succesfully";
        header("location:all_projects.php");
    }else{
      echo mysqli_error($conn);
    }

}

?>