query("SELECT COUNT(*) as total_publics FROM publics");
$total_publics = $stmt_publics->fetchColumn();
// Fetch total subscribers
$stmt_subscribers = $pdo->query("SELECT SUM(subscribers) as total_subscribers FROM publics");
$total_subscribers = $stmt_subscribers->fetchColumn();
} catch (PDOException $e) {
// For a real app, you'd want to log this error, not die.
die("Database error: " . $e->getMessage());
}
// Function to format large numbers
function format_number($num) {
if ($num >= 1000000) {
return round($num / 1000000, 1) . 'M';
} elseif ($num >= 1000) {
return round($num / 1000, 1) . 'K';
}
return $num;
}
?>