0,
'projects' => 0,
'gallery' => 0,
'testimonials' => 0,
'team' => 0,
'messages_unread' => 0,
'messages_total' => 0,
'pdf_uploads' => 0
];
$recent_messages = [];
try {
$counts['services'] = $pdo->query("SELECT COUNT(*) FROM services")->fetchColumn();
$counts['projects'] = $pdo->query("SELECT COUNT(*) FROM projects")->fetchColumn();
$counts['gallery'] = $pdo->query("SELECT COUNT(*) FROM gallery")->fetchColumn();
$counts['testimonials'] = $pdo->query("SELECT COUNT(*) FROM testimonials")->fetchColumn();
$counts['team'] = $pdo->query("SELECT COUNT(*) FROM team_members")->fetchColumn();
$counts['messages_unread'] = $pdo->query("SELECT COUNT(*) FROM contact_messages WHERE is_read = 0")->fetchColumn();
$counts['messages_total'] = $pdo->query("SELECT COUNT(*) FROM contact_messages")->fetchColumn();
$counts['pdf_uploads'] = $pdo->query("SELECT COUNT(*) FROM pdf_uploads")->fetchColumn();
// Fetch 5 most recent customer inquiries
$msg_stmt = $pdo->query("SELECT * FROM contact_messages ORDER BY id DESC LIMIT 5");
$recent_messages = $msg_stmt->fetchAll();
} catch (PDOException $e) {
// Setup fallback variables for developer local previews
$counts = [
'services' => 11,
'projects' => 2,
'gallery' => 4,
'testimonials' => 3,
'team' => 3,
'messages_unread' => 1,
'messages_total' => 1,
'pdf_uploads' => 0
];
$recent_messages = [
[
'id' => 1,
'name' => 'Dilan Perera',
'email' => 'dilan@zenith.com',
'phone' => '0717771871',
'subject' => 'Corporate Headquarter Concept Proposal',
'message' => 'We are interested in mapping design options for our upcoming 10-story eco office complex in Colombo.',
'is_read' => 0,
'created_at' => date('Y-m-d H:i:s')
]
];
}
require_once __DIR__ . '/header.php';
require_once __DIR__ . '/navbar.php';
?>
Warning: Database connections are currently offline. Displaying simulated administrative figures. Please start MySQL.
Recent Messages
| From |
Subject |
Received |
Status |
Action |
|
|
40 ? '...' : '' ?> |
|
Read
Unread
|
|
| No inbox messages available. |