PHP App\Db::query Examples

Example #1

File: dbTests.php Project: KnyazkovAlexey/php2_homework_Knyazkov

<?php

require __DIR__ . '/../autoload.php';
$db = new \App\Db();
$good_res1 = $db->query('SELECT * FROM users WHERE id >= :id', '\\App\\Models\\User', [':id' => 1]);
$good_res2 = $db->query('SELECT * FROM users', '\\App\\Models\\User');
$bad_res = $db->execute('Happy New Year!');
assert($good_res1 && $good_res2 && !$bad_res);

Example #2

File: tests.php Project: eropkinvitaliy/PHP-2-profit

<?php

require __DIR__ . '/../autoload.php';
$test = new \App\Db();
$result1 = $test->execute('SELECT * FROM users');
$result2 = $test->execute('SELECT * FROM users WHERE id_user = :id', [':id' => 1]);
if ($result1) {
    echo 'Тест метода execute класса Dbase : SELECT * FROM users; - пройден успешно <br>';
} else {
    echo 'Тест метода execute класса Dbase : SELECT * FROM users; - не пройден <br>';
}
if ($result2) {
    echo 'Тест метода execute класса Dbase : SELECT * FROM users WHERE id_user = :id;
          с подстановкой параметров - пройден успешно <br>';
} else {
    echo 'Тест метода execute класса Dbase : SELECT * FROM users WHERE id_user = :id;
          с подстановкой параметров - не пройден <br>';
}
$result3 = $test->query('SELECT * FROM users WHERE id_user = :id', \App\Models\User::class, [':id' => 1]);
if ($result3) {
    echo 'Тест метода query класса Dbase : SELECT * FROM users WHERE id_user = :id;
          с подстановкой параметров - пройден успешно <br>';
} else {
    echo 'Тест метода query класса Dbase : SELECT * FROM users WHERE id_user = :id;
          с подстановкой параметров - не пройден <br>';
}