class DB {
private static function connect() {
$pdo = new PDO(\'mysql:host=localhost;dbname=gapi;charset=utf8\', \'root\', \'\');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $pdo;
}
public static function query($query, $params = array()) {
$statement = self::connect()->prepare($query);
$statement->execute($params);
if (explode(\' \',$query)[0] == \'SELECT\') {
$data = $statement->fetchAll();
return $data;
}
}
}
query(\'INSERT INTO users VALUES (:id, :username, :password)\', array(\':id\'=>$id, \':username\'=>$username, \':password\'=>$password));
valami ilyesmit futtass le.