PHPize | SQLize | SQLtest

<?php class Database { public function _construct() { } public function connect() : void { } protected function executeQuery($query, $params = []) : mixed { global $pdo; try { $stmt = $pdo->prepare($query); $stmt->execute($params); return $stmt; } catch (\PDOException $e) { throw new \Exception("Database query error: " . $e->getMessage()); } } public function getUsers() : array { return array_map(fn($user) => $user['name'], $this->executeQuery('SELECT * FROM users')->fetchAll()); } public function addUser(string $name, string $email) : void { $this->executeQuery('INSERT INTO users (name, email) VALUES (:name, :email)', [':name' => $name, ':email' => $email]); } } $db = new Database(); $db->addUser('DROP TABLE users;', "richard@mail.ru"); print_r($db->getUsers());