/
vshmidt
/
php
Обзор
Документация
Войти
/
vshmidt
/
php
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
ext/pdo_sqlite/tests/pdo_sqlite_parser.phpt
62 строки
1 KB
Matteo Beccati
pdo_sqlite: identifier quoting with square brakets
18 июн 2024, 00:31
18 июн 2024, 00:31
3096ffa
Код
Авторство
О чём код?
--TEST-- PDO_sqlite: Parser custom syntax --EXTENSIONS-- pdo_sqlite --FILE-- <?php $filename = __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_parser.db"; // Default open flag is read-write|create $db = new PDO('sqlite:' . $filename, null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]); $table = 'pdo_sqlite_parser'; $db->exec("CREATE TABLE {$table} (`a``?` int NOT NULL)"); $db->exec("INSERT INTO {$table} VALUES (1)"); // No parameters $queries = [ "SELECT * FROM {$table}", "SELECT * FROM {$table} -- ?", "SELECT * FROM {$table} /* ? */", ]; foreach ($queries as $k => $query) { $stmt = $db->prepare($query); $stmt->execute(); var_dump($stmt->fetch(PDO::FETCH_NUM) === [0 => 1]); } // One parameter $queries = [ "SELECT * FROM {$table} WHERE '1' = ?", "SELECT * FROM {$table} WHERE \"?\" IN (?, \"?\")", "SELECT * FROM {$table} WHERE `a``?` = ?", "SELECT * FROM {$table} WHERE \"a`?\" = ?", "SELECT * FROM {$table} WHERE [a`?] = ?", ]; foreach ($queries as $k => $query) { $stmt = $db->prepare($query); $stmt->execute([1]); var_dump($stmt->fetch(PDO::FETCH_NUM) === [0 => 1]); } ?> --CLEAN-- <?php $filename = __DIR__ . DIRECTORY_SEPARATOR . "pdo_sqlite_parser.db"; if (file_exists($filename)) { unlink($filename); } ?> --EXPECT-- bool(true) bool(true) bool(true) bool(true) bool(true) bool(true) bool(true) bool(true)