0, 'new' => 0]; $recentContacts = []; try { $projectsCount = (int)pdo()->query("SELECT COUNT(*) FROM projects")->fetchColumn(); } catch (Throwable $e) {} try { $skillsCount = (int)pdo()->query("SELECT COUNT(*) FROM skills")->fetchColumn(); } catch (Throwable $e) {} try { pdo()->exec(" CREATE TABLE IF NOT EXISTS contact_requests ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(80) NOT NULL, email VARCHAR(120) NOT NULL, message TEXT NOT NULL, status ENUM('new','read','archived') NOT NULL DEFAULT 'new', created_at DATETIME NOT NULL, ip VARCHAR(45) NULL, user_agent VARCHAR(255) NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci "); $contactCounts['total'] = (int)pdo()->query("SELECT COUNT(*) FROM contact_requests")->fetchColumn(); $contactCounts['new'] = (int)pdo()->query("SELECT COUNT(*) FROM contact_requests WHERE status='new'")->fetchColumn(); $recentContacts = pdo()->query("SELECT id, name, email, message, status, created_at FROM contact_requests ORDER BY created_at DESC, id DESC LIMIT 5")->fetchAll() ?: []; } catch (Throwable $e) {} $hasRefresh = false; $hasAccess = false; try { $row = pdo()->query("SELECT refresh_token, access_token, access_expires FROM spotify_tokens WHERE id=1")->fetch(); if ($row) { $hasRefresh = !empty($row['refresh_token']); $hasAccess = !empty($row['access_token']) && (int)($row['access_expires'] ?? 0) > (time() + 30); } } catch (Throwable $e) {} ?> Admin Dashboard

Dashboard

Home Logout

Projects

Add Manage

Tech Stack

Edit languages and frameworks for your homepage.

Add Adjust

Contacts

new

Inbox New

Spotify

Offline

Shows Now Playing or Last Played. Temporary token expires; refresh token is best.

Set Token

Inbox preview

Latest contact requests

View all