1#@!#!123s

https 1#@!#!123s
: / home2 / affluencebiotech / public_html / absolutoffice.com / ABS / user /
Filename : company_info.php
back
<?php
session_start();
include 'db.php';

// 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']; // The user ID stored in the session
    $company_name = mysqli_real_escape_string($conn, $_POST['company_name']);
    $company_nif = mysqli_real_escape_string($conn, $_POST['company_nif']);
    $company_address = mysqli_real_escape_string($conn, $_POST['company_address']);
    $company_country = mysqli_real_escape_string($conn, $_POST['company_country']);

    // Prepare SQL query to insert data into the database
    $sql = "INSERT INTO company_info (user_id, company_name, company_nif, company_address, company_country) 
            VALUES ('$user_id', '$company_name', '$company_nif', '$company_address', '$company_country')";

    // Execute the query and check if it was successful
    if (mysqli_query($conn, $sql)) {
        // Redirect the user after successful form submission
        echo "<script>
                alert('Company info saved successfully');
                document.location.href = '../client-account.php'; // Redirect to next page
              </script>";
    } else {
        echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    }
}
?>