<?php
$host = 'localhost';
$db = 'zemaraim_interior';
$user = 'zemaraim';
$password = '8wwxk]-X3Kx]CJ]5';

$conn = new mysqli($host, $user, $password, $db);

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

// Check orders table structure
$result = $conn->query("DESCRIBE orders");
echo "<h2>Orders Table Structure:</h2>";
echo "<pre>";
while ($row = $result->fetch_assoc()) {
    echo $row['Field'] . " - " . $row['Type'] . " - " . $row['Null'] . " - " . $row['Key'] . "\n";
}
echo "</pre>";

// Count columns
$columns = $result->num_rows;
echo "<p>Total columns: " . $columns . "</p>";

$conn->close();
?>
