$date = new DateTime('now', new DateTimeZone('Europe/Moscow'));
echo $date->format('Y-m-d H:i:s');

spl_autoload_register(function ($class) {
    $baseDir = __DIR__ . '/src/';
    $classPath = str_replace('\\', '/', $class) . '.php';
    $file = $baseDir . $classPath;

    if (file_exists($file)) {
        require $file;
    }
});

$id = $_GET['id'];
$query = "SELECT * FROM users WHERE id = $id";

$id = $_GET['id'];
$stmt = $pdo->prepare("SELECT * FROM users WHERE id = :id");
$stmt->execute(['id' => $id]);
$user = $stmt->fetch();

logger($someObject);

logger()->info('User data', [$user->toArray()]);

tap($response, fn($res) => logger($res->toArray()));

// TODO: Проверить валидацию email после изменений
// TODO: Перевести этот блок на отдельный сервис

set_error_handler(function ($errno, $errstr, $errfile, $errline) {
    error_log("[PHP ERROR] $errstr in $errfile:$errline");
    return false;
});

set_exception_handler(function (Throwable $e) {
    error_log("[UNCAUGHT EXCEPTION] " . $e->getMessage() . ' in ' . $e->getFile() . ':' . $e->getLine());
});

function log_debug($msg) {
    file_put_contents(__DIR__.'/debug.log', date('[Y-m-d H:i:s] ') . $msg . PHP_EOL, FILE_APPEND);
}

log_debug("REQUEST: " . $_SERVER['REQUEST_METHOD'] . ' ' . $_SERVER['REQUEST_URI']);
log_debug("HEADERS: " . json_encode(getallheaders()));
log_debug("POST: " . json_encode($_POST));

DB::listen(function ($query) {
    $sql = $query->sql;
    foreach ($query->bindings as $binding) {
        $binding = is_numeric($binding) ? $binding : "'{$binding}'";
        $sql = preg_replace('/\?/', $binding, $sql, 1);
    }
    logger()->info("Executed query: {$sql}");
});

select * from users where email = 'john@example.com' and age > 18

   $stmt = $pdo->query("SELECT * FROM big_table");
   while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
       process($row); // Обрабатываем каждую строку на лету
   }
   

   function getRows($pdo) {
       $stmt = $pdo->query("SELECT * FROM big_table");
       while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
           yield $row;
       }
   }

   foreach (getRows($pdo) as $row) {
       process($row);
   }
   

   $limit = 1000;
   for ($offset = 0; ; $offset += $limit) {
       $rows = $pdo->query("SELECT * FROM big_table LIMIT $limit OFFSET $offset")->fetchAll();
       if (!$rows) break;
       foreach ($rows as $row) {
           process($row);
       }
   }