<?php

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

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

    $fb_link = $_POST['fb_link'];
    $twitter_link = $_POST['twitter_link'];
    $linkedin_link = $_POST['linkedin_link'];
    $description = $_POST['description'];

    $query = "INSERT INTO fcontent(fb_link, twitter_link, linkedin_link, description) VALUES ('$fb_link', '$twitter_link', '$linkedin_link', '$description')";
    $query_run = mysqli_query($conn, $query);

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


// update 

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

    // Update the testimonial information in the database without handling images
    $query = "UPDATE fcontent SET  fb_link='$fb_link', twitter_link='$twitter_link', linkedin_link='$linkedin_link', description='$description' WHERE id='$id'";

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

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


// delete

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

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

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