/
vshmidt
/
php
Обзор
Документация
Войти
/
vshmidt
/
php
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
ext/sqlite3/tests/sqlite3_35_stmt_readonly.phpt
55 строк
1 KB
Max Semenik
Migrate skip checks to --EXTENSIONS--, p4
08 апр 2021, 11:36
08 апр 2021, 11:36
7f2f0c0
Код
Авторство
О чём код?
--TEST-- SQLite3_stmt::readOnly check --EXTENSIONS-- sqlite3 --SKIPIF-- <?php $version = SQLite3::version(); if ($version['versionNumber'] < 3007004) { die("skip"); } ?> --FILE-- <?php require_once(__DIR__ . '/new_db.inc'); define('TIMENOW', time()); echo "Creating Table\n"; var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); echo "INSERT into table\n"; var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'a')")); var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")); echo "Checking select statement\n"; $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC"); var_dump($stmt->readOnly()); echo "Checking update statement\n"; $stmt = $db->prepare("UPDATE test SET id = 'c' WHERE id = ?"); var_dump($stmt->readOnly()); echo "Checking delete statement\n"; $stmt = $db->prepare("DELETE FROM test"); var_dump($stmt->readOnly()); echo "Closing database\n"; var_dump($db->close()); echo "Done\n"; ?> --EXPECT-- Creating Table bool(true) INSERT into table bool(true) bool(true) Checking select statement bool(true) Checking update statement bool(false) Checking delete statement bool(false) Closing database bool(true) Done