<?php

session_start();
include("includes/config.php");

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

    $heading = $_POST['heading'];
    // $position = $_POST['position'];
    $description = $_POST['description'];

    $query = "INSERT INTO abouts(heading, description) VALUES ('$heading', '$description')";
    $query_run = mysqli_query($conn, $query);

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


// update 

if(isset($_POST['update_about'])){
    $id = $_POST['id'];
    $heading = $_POST['heading'];
 
    $description = $_POST['description'];

    // Update the testimonial information in the database without handling images
    $query = "UPDATE abouts SET heading='$heading', description='$description' WHERE id='$id'";

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

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


// delete

if(isset($_POST['delete_about'])){
    $id = $_POST['delete_id'];

    // Delete the testimonial from the database
    $query = "DELETE FROM abouts WHERE id = '$id'";
    $query_run = mysqli_query($conn, $query);

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