1#@!#!123s

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

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

$user_id = $_SESSION['user_id'];

// SQL query to fetch data from all four tables
$query = "
    SELECT 
        ci.company_name, ci.company_nif, ci.company_address, ci.company_country,
        rp.responsible_name, rp.responsible_position, rp.responsible_phone, rp.responsible_email,
        si.shipping_address, si.shipping_port, si.shipping_contact, si.shipping_phone, si.shipping_email,
        ad.document_path
    FROM company_info ci
    JOIN responsible_person rp ON ci.user_id = rp.user_id
    JOIN shipping_info si ON ci.user_id = si.user_id
    JOIN attach_documents ad ON ci.user_id = ad.user_id
    WHERE ci.user_id = '$user_id'";

// Execute the query
$result = mysqli_query($conn, $query);

// Check if data is available
if ($result && mysqli_num_rows($result) > 0) {
    $user_data = mysqli_fetch_assoc($result);
} else {
    $user_data = []; // Set an empty array if no data is found
    echo "<script>
            alert('No data found for this user.');
            document.location.href = 'my_account.php'; // Redirect to account page if no data is found
          </script>";
    exit();
}

// Display the result using echo statements
echo "<h2>Company Information</h2>";
echo "<p><strong>Company Name:</strong> " . htmlspecialchars($user_data['company_name']) . "</p>";
echo "<p><strong>Company NIF:</strong> " . htmlspecialchars($user_data['company_nif']) . "</p>";
echo "<p><strong>Company Address:</strong> " . htmlspecialchars($user_data['company_address']) . "</p>";
echo "<p><strong>Company Country:</strong> " . htmlspecialchars($user_data['company_country']) . "</p>";

echo "<h2>Responsible Person</h2>";
echo "<p><strong>Name:</strong> " . htmlspecialchars($user_data['responsible_name']) . "</p>";
echo "<p><strong>Position:</strong> " . htmlspecialchars($user_data['responsible_position']) . "</p>";
echo "<p><strong>Phone:</strong> " . htmlspecialchars($user_data['responsible_phone']) . "</p>";
echo "<p><strong>Email:</strong> " . htmlspecialchars($user_data['responsible_email']) . "</p>";

echo "<h2>Shipping Information</h2>";
echo "<p><strong>Shipping Address:</strong> " . htmlspecialchars($user_data['shipping_address']) . "</p>";
echo "<p><strong>Shipping Port:</strong> " . htmlspecialchars($user_data['shipping_port']) . "</p>";
echo "<p><strong>Shipping Contact:</strong> " . htmlspecialchars($user_data['shipping_contact']) . "</p>";
echo "<p><strong>Shipping Phone:</strong> " . htmlspecialchars($user_data['shipping_phone']) . "</p>";
echo "<p><strong>Shipping Email:</strong> " . htmlspecialchars($user_data['shipping_email']) . "</p>";

echo "<h2>Document Information</h2>";
echo "<p><strong>Document Path:</strong> " . htmlspecialchars($user_data['document_path']) . "</p>";

// Commented out or removed unnecessary data that you might not need for now
// Example:
// echo "<p><strong>Some Other Data:</strong> " . htmlspecialchars($user_data['other_column']) . "</p>";
include 'footer.php';
?>