<?php

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

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

    $share_name = $_POST['share_name'];
    $price = $_POST['price'];
    // $description = $_POST['description'];

    $query = "INSERT INTO  top_plus(share_name, price) VALUES ('$share_name', '$price')";
    $query_run = mysqli_query($conn, $query);

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


// update 

if(isset($_POST['update_top'])){
    $id = $_POST['id'];
    $share_name = $_POST['share_name'];
    $price = $_POST['price'];

    // Update the testimonial information in the database without handling images
    $query = "UPDATE top_plus SET share_name='$share_name', price='$price' WHERE id='$id'";

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

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


// delete

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

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

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