exec($sql);
$ready = true;
}
function lead_count(): int
{
ensure_leads_table();
$stmt = db()->query('SELECT COUNT(*) AS total FROM leads');
return (int)($stmt->fetch()['total'] ?? 0);
}
function latest_leads(int $limit = 8): array
{
ensure_leads_table();
$stmt = db()->prepare('SELECT id, public_token, name, email, company, budget, message, status, email_sent, created_at FROM leads ORDER BY created_at DESC LIMIT :limit');
$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);
$stmt->execute();
return $stmt->fetchAll();
}
function fetch_lead_by_token(string $token): ?array
{
ensure_leads_table();
$stmt = db()->prepare('SELECT * FROM leads WHERE public_token = :token LIMIT 1');
$stmt->bindValue(':token', $token, PDO::PARAM_STR);
$stmt->execute();
$lead = $stmt->fetch();
return $lead ?: null;
}
function fetch_lead_by_id(int $id): ?array
{
ensure_leads_table();
$stmt = db()->prepare('SELECT * FROM leads WHERE id = :id LIMIT 1');
$stmt->bindValue(':id', $id, PDO::PARAM_INT);
$stmt->execute();
$lead = $stmt->fetch();
return $lead ?: null;
}
function page_head(string $title, string $description = ''): void
{
$projectDescription = $_SERVER['PROJECT_DESCRIPTION'] ?? getenv('PROJECT_DESCRIPTION') ?: '';
$projectImageUrl = $_SERVER['PROJECT_IMAGE_URL'] ?? getenv('PROJECT_IMAGE_URL') ?: '';
$metaDescription = $description !== '' ? $description : ($projectDescription !== '' ? $projectDescription : project_description());
?>
<?= e($title) ?>