23 lines
472 B
PHP
23 lines
472 B
PHP
<?php
|
|
require_once 'db/config.php';
|
|
|
|
try {
|
|
$db = db();
|
|
$tables = ['customers', 'products', 'shipments', 'lifecycle'];
|
|
$counts = [];
|
|
|
|
foreach ($tables as $table) {
|
|
$stmt = $db->query("SELECT COUNT(*) FROM `$table`");
|
|
$counts[$table] = $stmt->fetchColumn();
|
|
}
|
|
|
|
foreach ($counts as $table => $count) {
|
|
echo ucfirst($table) . ": $count rows
|
|
";
|
|
}
|
|
|
|
} catch (PDOException $e) {
|
|
echo "Error: " . $e->getMessage() . "
|
|
";
|
|
}
|
|
?>
|