0,
'agents' => 0,
'owners' => 0,
'clients' => 0,
'transactions' => 0
];
try {
$counts['properties'] = $pdo->query('SELECT count(*) FROM properties')->fetchColumn();
$counts['agents'] = $pdo->query('SELECT count(*) FROM agent')->fetchColumn();
$counts['owners'] = $pdo->query('SELECT count(*) FROM owner')->fetchColumn();
$counts['clients'] = $pdo->query('SELECT count(*) FROM clients')->fetchColumn();
$counts['transactions'] = $pdo->query('SELECT count(*) FROM transactions')->fetchColumn();
} catch (PDOException $e) {
// If the tables don't exist yet, we can just show 0.
// On a real site, you would log this error.
}
?>
Admin Dashboard
Welcome to the Real Estate Management System. Here you can manage properties, clients, and transactions.