<?php



include("inc/config.php");

if(isset($_POST['add_project'])){
    $project_name = $_POST['project_name'];
    // $project_cost = $_POST['project_cost'];
    $project_start = $_POST['project_start'];

  
   

    // Sanitize input data (for example, you can use mysqli_real_escape_string)
    $project_name = mysqli_real_escape_string($conn, $project_name);
    // $project_cost = mysqli_real_escape_string($conn, $project_cost);
    $project_start = mysqli_real_escape_string($conn, $project_start);

   
   

  

    // Construct the SQL query with sanitized input data

    $query = "INSERT INTO `projects` (`project_name` , `project_start`) VALUES ('$project_name', '$project_start')";

   
    $query_run = mysqli_query($conn, $query);

    if($query_run){
     
        $_SESSION['status'] = "Data Uploaded Successfully";
        header('Location: view-project.php');
        exit;
    } else {
        $_SESSION['status'] = "Data Not Uploaded Successfully";
        header('Location: project.php');
        exit;
    }
}


if (isset($_POST['update_project'])) {
    $id = $_POST['id'];
    $project_name = $_POST['project_name'];
    // $project_cost = $_POST['project_cost'];
    $project_status = $_POST['project_status'];

    $project_start = $_POST['project_start'];
    $project_end = $_POST['project_end'];





    // Update the project information in the database
    $query = "UPDATE projects 
              SET project_name='$project_name',
                project_status='$project_status',
                project_start='$project_start',
                project_end='$project_end'

              WHERE id='$id'";

    $query_run = mysqli_query($conn, $query);

    if ($query_run) {
        $_SESSION['status'] = "Project Updated Successfully";
        header('Location: view-project.php');
    } else {
        $_SESSION['status'] = "Project Not Updated Successfully";
        header('Location: view-project.php');
    }
}



// if (isset($_POST['complete_project'])) {
//     $project_id = $_POST['project_id'];

 
//     $query = "UPDATE projects SET project_status = 'Complete' WHERE id = '$project_id'";
//     $query_run = mysqli_query($conn, $query);

//     if ($query_run) {
      
//         header("Location: view-project.php?status=success");
//         exit();
//     } else {
       
//         header("Location: view-project.php?status=error");
//         exit();
//     }
// } else {
//     header("Location: view-project.php");
//     exit();
// }




// delete

if (isset($_POST['delete_project'])) {

    $id = $_POST['delete_id'];
    
    $query = "DELETE FROM `projects` WHERE id = '$id'";
    $query_run = mysqli_query($conn, $query);

    if ($query_run) {
        $_SESSION['status'] = "Deleted Successfully";
        header('Location: view-project.php');
    } else {
        $_SESSION['status'] = "Not Deleted Successfully";
        header('Location: view-project.php');
    }
}

?>