<?php
include("includes/config.php");

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

    $vlink = $_POST['vlink'];
//  print_r ($vlink);
//  die();

    $query = "INSERT INTO vtestimonials (vlink) VALUES ('$vlink')";
    $query_run = mysqli_query($conn, $query);


    if($query_run){
        $_SESSION['status'] = " Uploaded Successfully";
                 echo "<script>window.location.href='view-vtestimonial.php';</script>";

        // header('Location: view-vtestimonial.php');
        exit;
    } else {
        $_SESSION['status'] = "Data Not Uploaded Successfully";
         echo "<script>window.location.href='vtestimonial.php';</script>";
        // header('Location: vtestimonial.php');
        exit;
    }
}



// update 

if(isset($_POST['update_vtestimonial'])){
    $id = $_POST['id'];
    $vlink = $_POST['vlink'];

    $query = "UPDATE vtestimonials SET vlink='$vlink' WHERE id ='$id' ";

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

    if($query_run){
       
        $_SESSION['status'] = "Updated Successfully";
                         echo "<script>window.location.href='view-vtestimonial.php';</script>";

        // header('Location: view-vtestimonial.php');
    } else {
        $_SESSION['status'] = " Not Updated ";
                         echo "<script>window.location.href='view-vtestimonial.php';</script>";

        // header('Location: view-vtestimonial.php');
    }
}



// delete
if(isset($_POST['delete_vtestimonial'])){
    $id = $_POST['delete_id'];

    $query = "DELETE FROM vtestimonials WHERE id = '$id'";
    $query_run = mysqli_query($conn, $query);

    if($query_run){
        $_SESSION['status'] = "Deleted Successfully";
                         echo "<script>window.location.href='view-vtestimonial.php';</script>";

        // header('Location: view-vtestimonial.php');
    } else {
        $_SESSION['status'] = "Not Deleted Successfully";
                         echo "<script>window.location.href='view-vtestimonial.php';</script>";

        // header('Location: view-vtestimonial.php');
    }
}