Gecko [ www.foryou-vip.com ]

Linux vps-61133.fhnet.fr 4.9.0-19-amd64 #1 SMP Debian 4.9.320-2 (2022-06-30) x86_64
Apache/2.4.25 (Debian)
Server IP : 93.113.207.21 & Your IP : 216.73.216.112
Domains : Cant Read [ /etc/named.conf ]
User : www-data

Name	Size	Permission	Date
bug45798.phpt	678 B	-rw-rw-r--	2022-10-31 11:36
bug47159.phpt	324 B	-rw-rw-r--	2022-10-31 11:36
bug53463.phpt	667 B	-rw-rw-r--	2022-10-31 11:36
bug63921-32bit.phpt	817 B	-rw-rw-r--	2022-10-31 11:36
bug63921-64bit.phpt	810 B	-rw-rw-r--	2022-10-31 11:36
bug66550.phpt	591 B	-rw-rw-r--	2022-10-31 11:36
bug68760.phpt	828 B	-rw-rw-r--	2022-10-31 11:36
bug69972.phpt	715 B	-rw-rw-r--	2022-10-31 11:36
bug70628.phpt	1.06 KB	-rw-rw-r--	2022-10-31 11:36
bug71049.phpt	505 B	-rw-rw-r--	2022-10-31 11:36
bug72571.phpt	363 B	-rw-rw-r--	2022-10-31 11:36
bug72668.phpt	894 B	-rw-rw-r--	2022-10-31 11:36
bug73068.phpt	792 B	-rw-rw-r--	2022-10-31 11:36
bug73333.phpt	602 B	-rw-rw-r--	2022-10-31 11:36
bug76665.phpt	491 B	-rw-rw-r--	2022-10-31 11:36
bug77051.phpt	1.45 KB	-rw-rw-r--	2022-10-31 11:36
bug79294.phpt	772 B	-rw-rw-r--	2022-10-31 11:36
exception_from_toString.phpt	791 B	-rw-rw-r--	2022-10-31 11:36
new_db.inc	42 B	-rw-rw-r--	2022-10-31 11:36
skipif.inc	92 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_01_open-mb.phpt	398 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_01_open.phpt	262 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_02_create.phpt	697 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_02_open.phpt	369 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_03_insert.phpt	962 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_04_update.phpt	1.36 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_05_delete.phpt	1.3 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_06_prepared_stmt.phpt	1.06 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_07_prepared_stmt.phpt	1.04 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_08_udf.phpt	1.13 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_09_blob_bound_param.phpt	1.31 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_10_bound_value_name.phpt	1.16 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_11_numrows.phpt	1.05 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_12_unfinalized_stmt_cleanup.phpt	1.13 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_13_skip_all_cleanup.phpt	864 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_14_querysingle.phpt	831 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_15_open_error-win.phpt	848 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_15_open_error.phpt	637 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_16_select_no_results.phpt	628 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_17_version.phpt	228 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_18_changes.phpt	809 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_19_columninfo.phpt	1.06 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_20_error.phpt	678 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_21_security.phpt	900 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_22_loadextension.phpt	645 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_23_escape_string.phpt	1001 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_24_last_insert_rowid.phpt	730 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_25_create_aggregate.phpt	1.29 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_26_reset_prepared_stmt.phpt	1.2 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_27_reset_prepared_stmt_result.phpt	1.21 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_28_clear_bindings.phpt	1.32 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_29_createfunction.phpt	617 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_30_blobopen.phpt	1.98 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_31_changes.phpt	309 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_31_open.phpt	418 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_33_createAggregate_notcallable.phpt	903 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_33_load_extension_param.phpt	546 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_33_reset.phpt	634 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_34_load_extension_ext_dir.phpt	508 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_35_stmt_readonly.phpt	1.2 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_36_create_collation.phpt	845 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_37_createfunction_flags.phpt	777 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_38_backup.phpt	1.24 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_38_extended_error.phpt	1.07 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_39_toggleExtended.phpt	1.42 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_bind_bug68849.phpt	1.29 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_blob_bind_resource.phpt	910 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_bound_value_at_name.phpt	1.05 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3_busyTimeout.phpt	435 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_defensive.phpt	960 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_enable_exceptions.phpt	865 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_open_empty_string.phpt	273 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_prepare_001.phpt	281 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_prepare_faultystmt.phpt	540 B	-rw-rw-r--	2022-10-31 11:36
sqlite3_prepare_with_empty_string.phpt	304 B	-rw-rw-r--	2022-10-31 11:36
sqlite3stmt_getsql.phpt	829 B	-rw-rw-r--	2022-10-31 11:36
sqlite3stmt_getsql_expanded.phpt	1.22 KB	-rw-rw-r--	2022-10-31 11:36
sqlite3stmt_paramCount_basic.phpt	1.29 KB	-rw-rw-r--	2022-10-31 11:36
stream_test.inc	814 B	-rw-rw-r--	2022-10-31 11:36

Rename

--TEST--
Bug #70628 (Clearing bindings on an SQLite3 statement doesn't work)
--SKIPIF--
<?php
if (!extension_loaded('sqlite3')) die('skip'); ?>
--FILE--
<?php
$db = new SQLite3(':memory:');

$db->exec("CREATE TABLE Dogs (Id INTEGER PRIMARY KEY, Breed TEXT, Name TEXT, Age INTEGER)");

$sth = $db->prepare("INSERT INTO Dogs (Breed, Name, Age)  VALUES (:breed,:name,:age)");

$sth->bindValue(':breed', 'canis', SQLITE3_TEXT);
$sth->bindValue(':name', 'jack', SQLITE3_TEXT);
$sth->bindValue(':age', 7, SQLITE3_INTEGER);
$sth->execute();

$sth->clear();
$sth->reset();

$sth->bindValue(':breed', 'russel', SQLITE3_TEXT);
$sth->bindValue(':age', 3, SQLITE3_INTEGER);
$sth->execute();

$res = $db->query('SELECT * FROM Dogs');
while (($row = $res->fetchArray(SQLITE3_ASSOC))) {
    var_dump($row);
}
$res->finalize();

$sth->close();
$db->close();
?>
--EXPECT--
array(4) {
  ["Id"]=>
  int(1)
  ["Breed"]=>
  string(5) "canis"
  ["Name"]=>
  string(4) "jack"
  ["Age"]=>
  int(7)
}
array(4) {
  ["Id"]=>
  int(2)
  ["Breed"]=>
  string(6) "russel"
  ["Name"]=>
  NULL
  ["Age"]=>
  int(3)
}