/
vshmidt
/
php
Обзор
Документация
Войти
/
vshmidt
/
php
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
ext/sqlite3/tests/sqlite3_28_clear_bindings.phpt
65 строк
1 KB
Max Semenik
Migrate skip checks to --EXTENSIONS--, p4
08 апр 2021, 11:36
08 апр 2021, 11:36
7f2f0c0
Код
Авторство
О чём код?
--TEST-- SQLite3_stmt::clear prepared statement results --EXTENSIONS-- sqlite3 --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 "SELECTING results\n"; $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC"); $foo = 'c'; echo "BINDING Parameter\n"; var_dump($stmt->bindParam(1, $foo, SQLITE3_TEXT)); $foo = 'a'; $results = $stmt->execute(); while ($result = $results->fetchArray(SQLITE3_NUM)) { var_dump($result); } $stmt->reset(); $stmt->clear(); var_dump($stmt->bindValue(1, 'b', SQLITE3_TEXT)); $results = $stmt->execute(); while ($result = $results->fetchArray(SQLITE3_NUM)) { var_dump($result); } $results->finalize(); echo "Closing database\n"; var_dump($db->close()); echo "Done\n"; ?> --EXPECTF-- Creating Table bool(true) INSERT into table bool(true) bool(true) SELECTING results BINDING Parameter bool(true) array(2) { [0]=> int(%d) [1]=> string(1) "a" } bool(true) array(2) { [0]=> int(%d) [1]=> string(1) "b" } Closing database bool(true) Done