
<?php
        
        // my code (jayrajsinh)


        if($_SERVER['REQUEST_METHOD'] == 'POST'){
          
          include '../dbconn.php';
          $pca = $_POST['Category'];
          $ptype = $_POST['ptype'];
          $pname = $_POST['pname'];
          $pdes = $_POST['pdes'];

          $sql = "INSERT INTO `projects` (`Project Category`,`Project Type`, `Project Name`, `Project Descriptions`) VALUES ('$pca', '$ptype', '$pname', '$pdes')";

          $result = mysqli_query($conn,$sql);

          if($result){

            $get_pro_id_sql = "SELECT * FROM `projects` WHERE `Project Name` LIKE '$pname'";
            $get_pro_id_conn = mysqli_query($conn,$get_pro_id_sql);
            $get_pro_id_assoc = mysqli_fetch_assoc($get_pro_id_conn);

            // echo $get_pro_id_assoc['pro_id'];

            $pro_id = $get_pro_id_assoc['pro_id'];

                if(isset($_FILES['img_1'])){
                    

                    $file_name = $_FILES['img_1']['name'];
                    $file_size = $_FILES['img_1']['size'];
                    $file_tmp_name = $_FILES['img_1']['tmp_name'];
                    $file_name = $_FILES['img_1']['name'];
                    $file_type = $_FILES['img_1']['type'];

                    $new_img_1_name = "pro_pic_1_$pro_id.jpg";

                    $change_path_sql = "UPDATE `projects` SET `img_1` = 'pro_pic_1_$pro_id.jpg' WHERE `projects`.`pro_id` = '$pro_id'";
            
                    // move_uploaded_file($file_tmp_name,"../subpages/project_photos/". $new_img_1_name);

                    // mysqli_query($conn,$change_path_sql)


                    if(move_uploaded_file($file_tmp_name,"../../subpages/project_photos/". $new_img_1_name)  &&  mysqli_query($conn,$change_path_sql) ){


                      list($width,$height) = getimagesize("../../subpages/project_photos/". $new_img_1_name);

                      $nwidth = 500;
                      $nheight = 500;
                      
                      $nrwimage = imagecreatetruecolor($nwidth,$nheight);
                      $source = imagecreatefromjpeg("../../subpages/project_photos/". $new_img_1_name);
                      imagecopyresized($nrwimage,$source,0,0,0,0,$nwidth,$nheight,$width,$height);
                      imagejpeg($nrwimage,'../../subpages/project_photos/'. $new_img_1_name);

                      $img_1_upload = true;

      
                  }

                  

                }
                


                if(isset($_FILES['img_2'])){
                    
                

                  $file_name = $_FILES['img_2']['name'];
                  $file_size = $_FILES['img_2']['size'];
                  $file_tmp_name = $_FILES['img_2']['tmp_name'];
                  $file_name = $_FILES['img_2']['name'];
                  $file_type = $_FILES['img_2']['type'];

                  $new_img_2_name = "pro_pic_2_$pro_id.jpg";

                  $change_path_sql = "UPDATE `projects` SET `img_2` = 'pro_pic_2_$pro_id.jpg' WHERE `projects`.`pro_id` = '$pro_id'";
          
                  // move_uploaded_file($file_tmp_name,"../subpages/project_photos/". $new_img_2_name);

                  // mysqli_query($conn,$change_path_sql)


                  if(move_uploaded_file($file_tmp_name,"../../subpages/project_photos/". $new_img_2_name)  &&  mysqli_query($conn,$change_path_sql) ){

                    $img_2_upload = true;
                    

                  }


              }
             
             
                if(isset($_FILES['img_3'])){
                  
                    

                  $file_name = $_FILES['img_3']['name'];
                  $file_size = $_FILES['img_3']['size'];
                  $file_tmp_name = $_FILES['img_3']['tmp_name'];
                  $file_name = $_FILES['img_3']['name'];
                  $file_type = $_FILES['img_3']['type'];

                  $new_img_3_name = "pro_pic_3_$pro_id.jpg";

                  $change_path_sql = "UPDATE `projects` SET `img_3` = 'pro_pic_3_$pro_id.jpg' WHERE `projects`.`pro_id` = '$pro_id'";
          
                  // move_uploaded_file($file_tmp_name,"../subpages/project_photos/". $new_img_3_name);

                  // mysqli_query($conn,$change_path_sql)


                  if(move_uploaded_file($file_tmp_name,"../../subpages/project_photos/". $new_img_3_name)  &&  mysqli_query($conn,$change_path_sql) ){

                    $img_3_upload = true;
                    
                    

                  }


              
                }
             
             
                if(isset($_FILES['img_4'])){
                    

                  $file_name = $_FILES['img_4']['name'];
                  $file_size = $_FILES['img_4']['size'];
                  $file_tmp_name = $_FILES['img_4']['tmp_name'];
                  $file_name = $_FILES['img_4']['name'];
                  $file_type = $_FILES['img_4']['type'];

                  $new_img_4_name = "pro_pic_4_$pro_id.jpg";

                  $change_path_sql = "UPDATE `projects` SET `img_4` = 'pro_pic_4_$pro_id.jpg' WHERE `projects`.`pro_id` = '$pro_id'";
          
                  // move_uploaded_file($file_tmp_name,"../subpages/project_photos/". $new_img_4_name);

                  // mysqli_query($conn,$change_path_sql)


                  if(move_uploaded_file($file_tmp_name,"../../subpages/project_photos/". $new_img_4_name)  &&  mysqli_query($conn,$change_path_sql) ){

                    $img_4_upload = true;                      
                
                  }


                }
             
             
                if(isset($_FILES['img_5'])){
                  
                    

                  $file_name = $_FILES['img_5']['name'];
                  $file_size = $_FILES['img_5']['size'];
                  $file_tmp_name = $_FILES['img_5']['tmp_name'];
                  $file_name = $_FILES['img_5']['name'];
                  $file_type = $_FILES['img_5']['type'];

                  $new_img_5_name = "pro_pic_5_$pro_id.jpg";

                  $change_path_sql = "UPDATE `projects` SET `img_5` = 'pro_pic_5_$pro_id.jpg' WHERE `projects`.`pro_id` = '$pro_id'";
          
                  // move_uploaded_file($file_tmp_name,"../subpages/project_photos/". $new_img_5_name);

                  // mysqli_query($conn,$change_path_sql)


                  if(move_uploaded_file($file_tmp_name,"../../subpages/project_photos/". $new_img_5_name)  &&  mysqli_query($conn,$change_path_sql) ){

                    $img_5_upload = true;
                    
                    
                      
                
                  }


                
                }

                header('Location: ../index.php');
                exit;

          }
 
        }





        else{
          echo 'hear';
        }



        
        ?>




















<?php



// your code ( tejas sir)







    // error_reporting(0);
    // $database_name;
    // $project_title;
    // $fileName;
    // if($_SERVER['REQUEST_METHOD'] == 'POST'){
    //      if(!empty($_POST['Category'])){
    //          $database_name = $_POST['Category'];
    //      }
    //      $project_title = $_POST['pname'];
         
    //      $fileName = array_filter($_FILES['image']['name']);
    //  }

    //  $servername = 'localhost';
    //  $username = 'root';
    //  $password = '';
    //  $dbname = $database_name;
    
    //  //create connection
    //  $conn = new mysqli($servername,$username,$password,$dbname);
 
    //  //check Connection
 
    //   if($conn->connect_error){
    //       die("connection failed :".$conn->connect_error);
    //   }
    //   else{
    //       $create_table = 'create table ' .$project_title .'(file_name varchar(50))';
    //       if($conn->query($create_table)){
    //           printf("table is created");
    //      }
    //   }

    // if(!empty($fileName)){
    //     foreach($fileName as $key=>$val){
    //         $fileName = basename($_FILES['image']['name'][$key]);
    //         $file_tmp_name = $_FILES['image']['tmp_name'][$key];
    //         $conn->query("INSERT INTO ".$project_title."(file_name) VALUES ('$fileName')");
    //         $img_name = $project_title.'_'.$fileName;
    //         // $temp_name = $_FILES['img_1']['tmp_name'];
    //         // echo $fileName;
    //         // echo '\n';
    //         // echo $img_name;
    //         // echo $file_tmp_name;


    //           if(move_uploaded_file($file_tmp_name, '../../subpages/project_photos/' . $img_name )){
    //             echo 'complete';


    //             list($width,$height) = getimagesize("../../subpages/project_photos/". $img_name );

    //                           $nwidth = 500;
    //                           $nheight = 500;
                              
    //                           $nrwimage = imagecreatetruecolor($nwidth,$nheight);
    //                           $source = imagecreatefromjpeg("../../subpages/project_photos/". $img_name);
    //                           imagecopyresized($nrwimage,$source,0,0,0,0,$nwidth,$nheight,$width,$height);
    //                           imagejpeg($nrwimage,'../../subpages/project_photos/'. $img_name);



    //           }else{
    //           echo 'hear';
    //         //   echo "Error during file upload: " . $_FILES["image"]["error"];
    //         }

            



    //     }
    // }

    
?>