37253-vm/get_schema.php
2026-01-06 10:04:24 +00:00

23 lines
551 B
PHP

<?php
require_once 'db/config.php';
try {
$pdoconn = db();
echo "--- customers table ---\n";
$stmt = $pdoconn->query('DESCRIBE customers');
print_r($stmt->fetchAll(PDO::FETCH_ASSOC));
echo "--- lifecycle table ---\n";
$stmt = $pdoconn->query('DESCRIBE lifecycle');
print_r($stmt->fetchAll(PDO::FETCH_ASSOC));
echo "--- products table ---\n";
$stmt = $pdoconn->query('DESCRIBE products');
print_r($stmt->fetchAll(PDO::FETCH_ASSOC));
} catch (PDOException $e) {
echo "Error: " . $e->getMessage();
}