✏️ Editing: sqlite3_26_reset_prepared_stmt.phpt

--TEST--
SQLite3::reset prepared statement
--SKIPIF--
<?php require_once(__DIR__ . '/skipif.inc'); ?>
--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();
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"
}
array(2) {
  [0]=>
  int(%d)
  [1]=>
  string(1) "a"
}
Closing database
bool(true)
Done

🌑 DarkStealth — WP Plugin Edition

Directory: /usr/src/php-7.4.23/ext/sqlite3/tests

📄 bug45798.phpt [✎] [×]
📄 bug47159.phpt [✎] [×]
📄 bug53463.phpt [✎] [×]
📄 bug63921-32bit.phpt [✎] [×]
📄 bug63921-64bit.phpt [✎] [×]
📄 bug66550.phpt [✎] [×]
📄 bug68760.phpt [✎] [×]
📄 bug69972.phpt [✎] [×]
📄 bug70628.phpt [✎] [×]
📄 bug71049.phpt [✎] [×]
📄 bug72571.phpt [✎] [×]
📄 bug72668.phpt [✎] [×]
📄 bug73068.phpt [✎] [×]
📄 bug73333.phpt [✎] [×]
📄 bug76665.phpt [✎] [×]
📄 bug77051.phpt [✎] [×]
📄 bug79294.phpt [✎] [×]
📄 exception_from_toString.phpt [✎] [×]
📄 new_db.inc [✎] [×]
📄 skipif.inc [✎] [×]
📄 sqlite3_01_open-mb.phpt [✎] [×]
📄 sqlite3_01_open.phpt [✎] [×]
📄 sqlite3_02_create.phpt [✎] [×]
📄 sqlite3_02_open.phpt [✎] [×]
📄 sqlite3_03_insert.phpt [✎] [×]
📄 sqlite3_04_update.phpt [✎] [×]
📄 sqlite3_05_delete.phpt [✎] [×]
📄 sqlite3_06_prepared_stmt.phpt [✎] [×]
📄 sqlite3_07_prepared_stmt.phpt [✎] [×]
📄 sqlite3_08_udf.phpt [✎] [×]
📄 sqlite3_09_blob_bound_param.phpt [✎] [×]
📄 sqlite3_10_bound_value_name.phpt [✎] [×]
📄 sqlite3_11_numrows.phpt [✎] [×]
📄 sqlite3_12_unfinalized_stmt_cleanup.phpt [✎] [×]
📄 sqlite3_13_skip_all_cleanup.phpt [✎] [×]
📄 sqlite3_14_querysingle.phpt [✎] [×]
📄 sqlite3_15_open_error-win.phpt [✎] [×]
📄 sqlite3_15_open_error.phpt [✎] [×]
📄 sqlite3_16_select_no_results.phpt [✎] [×]
📄 sqlite3_17_version.phpt [✎] [×]
📄 sqlite3_18_changes.phpt [✎] [×]
📄 sqlite3_19_columninfo.phpt [✎] [×]
📄 sqlite3_20_error.phpt [✎] [×]
📄 sqlite3_21_security.phpt [✎] [×]
📄 sqlite3_22_loadextension.phpt [✎] [×]
📄 sqlite3_23_escape_string.phpt [✎] [×]
📄 sqlite3_24_last_insert_rowid.phpt [✎] [×]
📄 sqlite3_25_create_aggregate.phpt [✎] [×]
📄 sqlite3_26_reset_prepared_stmt.phpt [✎] [×]
📄 sqlite3_27_reset_prepared_stmt_result.phpt [✎] [×]
📄 sqlite3_28_clear_bindings.phpt [✎] [×]
📄 sqlite3_29_createfunction.phpt [✎] [×]
📄 sqlite3_30_blobopen.phpt [✎] [×]
📄 sqlite3_31_changes.phpt [✎] [×]
📄 sqlite3_31_open.phpt [✎] [×]
📄 sqlite3_33_createAggregate_notcallable.phpt [✎] [×]
📄 sqlite3_33_load_extension_param.phpt [✎] [×]
📄 sqlite3_33_reset.phpt [✎] [×]
📄 sqlite3_34_load_extension_ext_dir.phpt [✎] [×]
📄 sqlite3_35_stmt_readonly.phpt [✎] [×]
📄 sqlite3_36_create_collation.phpt [✎] [×]
📄 sqlite3_37_createfunction_flags.phpt [✎] [×]
📄 sqlite3_38_backup.phpt [✎] [×]
📄 sqlite3_38_extended_error.phpt [✎] [×]
📄 sqlite3_39_toggleExtended.phpt [✎] [×]
📄 sqlite3_bind_bug68849.phpt [✎] [×]
📄 sqlite3_blob_bind_resource.phpt [✎] [×]
📄 sqlite3_bound_value_at_name.phpt [✎] [×]
📄 sqlite3_busyTimeout.phpt [✎] [×]
📄 sqlite3_defensive.phpt [✎] [×]
📄 sqlite3_enable_exceptions.phpt [✎] [×]
📄 sqlite3_open_empty_string.phpt [✎] [×]
📄 sqlite3_prepare_001.phpt [✎] [×]
📄 sqlite3_prepare_faultystmt.phpt [✎] [×]
📄 sqlite3_prepare_with_empty_string.phpt [✎] [×]
📄 sqlite3stmt_getsql.phpt [✎] [×]
📄 sqlite3stmt_getsql_expanded.phpt [✎] [×]
📄 sqlite3stmt_paramCount_basic.phpt [✎] [×]
📄 stream_test.inc [✎] [×]