#I LOVE YOU EVERDAY#

<?php
// Start the session
session_start();

// Database connection parameters
$servername = "localhost";
$username = "will_generator";
$password = "Gtscq_!hQnBDRC_u";
$dbname = "will_generator";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$session_id = $_SESSION['session_id'];

// Check if the form is submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Retrieve form data
    $childs_names = isset($_POST['childs_name']) ? $_POST['childs_name'] : [];
    $childs_ages = isset($_POST['childs_age']) ? $_POST['childs_age'] : [];
    $dependants_names = isset($_POST['dependants_name']) ? $_POST['dependants_name'] : [];
    $guardians_names = isset($_POST['guardians_name']) ? $_POST['guardians_name'] : [];
    $guardians_addresses = isset($_POST['guardians_address']) ? $_POST['guardians_address'] : [];
    $property_name = isset($_POST['property_name']) ? $_POST['property_name'] : [];
    $executor_names = isset($_POST['executor_name']) ? $_POST['executor_name'] : [];

// Check if the session ID already exists in the database
    $check_sql = "SELECT * FROM will_info WHERE session_id = '$session_id'";
    $check_result = $conn->query($check_sql);

if ($check_result->num_rows > 0) {
        // Session ID exists, update the existing record
        $update_sql = "UPDATE will_info 
                       SET childs_name = '" . implode(",", $childs_names) . "',
                           childs_age = '" . implode(",", $childs_ages) . "',
                           dependants_name = '" . implode(",", $dependants_names) . "',
                           guardians_name = '" . implode(",", $guardians_names) . "',
                           guardians_address = '" . implode(",", $guardians_addresses) . "',
                           property_name = '" . implode(",", $property_name) . "',
                           executor_name = '" . implode(",", $executor_names) . "'
                       WHERE session_id = '$session_id'";

if ($conn->query($update_sql) === TRUE) {
            // Update successful
            // Redirect to the next page (willform3.php)
            header("Location: willform3.php");
            exit();
        } else {
            // Handle the error if the update fails
            echo "Error updating record: " . $conn->error;
        }
    } else {
        echo "Please start from step 1";
    }
}

// Close the database connection
$conn->close();
?>