<?php
session_start();
include("inc/config.php"); // Include your database connection file

if (isset($_POST['update_status'])) {
    $news_id = $_POST['news_id'];

    // Fetch the current status
    $query = "SELECT status FROM news WHERE id='$news_id'";
    $result = mysqli_query($conn, $query);
    $row = mysqli_fetch_assoc($result);
    $current_status = $row['status'];

    // Toggle the status
    $new_status = ($current_status == 'Pending') ? 'Approved' : 'Pending';

    // Update the status in the database
    $update_query = "UPDATE news SET status='$new_status' WHERE id='$news_id'";
    if (mysqli_query($conn, $update_query)) {
        $_SESSION['status'] = "Status Updated Successfully";
    } else {
        $_SESSION['status'] = "Error Updating Status: " . mysqli_error($conn);
    }

    header("Location: view-news.php"); // Redirect back to the news page
    exit();
}
?>