Domainit, verkkotunnukset & sähköposti

<?php declare(strict_types=1); $config = parse_ini_file('config.ini'); $db = new PDO($config['dsn']); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); function sanitize(string $input): string { return htmlspecialchars( trim($input), ENT_QUOTES, 'UTF-8' ); } function fetchUsers(PDO $db): array { $sql = 'SELECT id, name, email, status, created_at FROM users WHERE deleted_at IS NULL ORDER BY created_at DESC'; return $db->query($sql) ->fetchAll(PDO::FETCH_ASSOC); } $users = fetchUsers($db); $active = array_filter($users, fn($u) => $u['status'] === 'active' ); $grouped = []; foreach ($active as $user) { $month = date('Y-m', strtotime($user['created_at']) ); $grouped[$month][] = $user; } foreach ($active as $user) { $name = sanitize($user['name']); $email = filter_var( $user['email'], FILTER_VALIDATE_EMAIL ); if (!$email) continue; $token = bin2hex(random_bytes(16)); $hash = password_hash( $token, PASSWORD_ARGON2ID ); $stmt = $db->prepare( 'UPDATE users SET token = ? WHERE id = ?' ); $stmt->execute([$hash, $user['id']]); $headers = implode("\r\n", [ 'From: noreply@example.com', 'Content-Type: text/html', 'X-Mailer: PHP/' . phpversion(), ]); mail($email, 'Welcome', "<h1>Hi {$name}</h1>", $headers ); } $stats = [ 'total' => count($users), 'active' => count($active), 'months' => count($grouped), 'memory' => memory_get_peak_usage(), 'time' => microtime(true), ]; header('Content-Type: application/json'); header('Cache-Control: no-store'); echo json_encode($stats, JSON_PRETTY_PRINT );