<?php
require_once __DIR__ . '/config/db.php';


// 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();
?>
