1#@!#!123s

https 1#@!#!123s
: / home2 / affluencebiotech / www / absolutoffice.com / user /
Filename : shipping_info.php
back
<?php
session_start();
include 'db.php'; // Include the database connection file

// Check if the user is logged in
if (!isset($_SESSION['user_id'])) {
    echo "<script>
            alert('Please login first');
            document.location.href = 'login.php';
          </script>";
    exit();
}

// Check if the form is submitted
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // Retrieve form data
    $user_id = $_SESSION['user_id']; // Get the user ID from session
    $shipping_address = mysqli_real_escape_string($conn, $_POST['shipping_address']);
    $shipping_port = mysqli_real_escape_string($conn, $_POST['shipping_port']);
    $shipping_contact = mysqli_real_escape_string($conn, $_POST['shipping_contact']);
    $shipping_phone = mysqli_real_escape_string($conn, $_POST['shipping_phone']);
    $shipping_email = mysqli_real_escape_string($conn, $_POST['shipping_email']);

    // Prepare the SQL query to insert data into the shipping_info table
    $sql = "INSERT INTO shipping_info (user_id, shipping_address, shipping_port, shipping_contact, shipping_phone, shipping_email)
            VALUES ('$user_id', '$shipping_address', '$shipping_port', '$shipping_contact', '$shipping_phone', '$shipping_email')";

    // Execute the query and check if the insertion was successful
    if (mysqli_query($conn, $sql)) {
        // If successful, redirect to the next page or show a success message
        echo "<script>
                // Ensure the tab switch after redirect
                window.location.href = '../client-account.php#attach-documents';
              </script>";
    } else {
        echo "Error: " . $sql . "<br>" . mysqli_error($conn); // Display error if insertion fails
    }
}
?>