send-request.php

<?php
session_start();
include("config/db.php");

if(isset($_SESSION['name'], $_SESSION['ration'], $_POST['member'], $_POST['rice'])) {
    $name = mysqli_real_escape_string($conn, $_SESSION['name']);
    $ration = mysqli_real_escape_string($conn, $_SESSION['ration']);
    $member = mysqli_real_escape_string($conn, $_POST['member']);
    $rice = mysqli_real_escape_string($conn, $_POST['rice']);

    $sql = "INSERT INTO ration_requests (citizen_name, ration_card, member_name, rice_kg, status)
            VALUES ('$name', '$ration', '$member', '$rice', 'Pending')";

    if(mysqli_query($conn, $sql)) {
        $_SESSION['request_id'] = mysqli_insert_id($conn);
        header("Location: verify-otp.php");
        exit;
    }

    echo "Error: " . mysqli_error($conn);
    exit;
}

echo "Invalid Request";