Gecko [ www.foryou-vip.com ]

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--
SQLite3::blobOpen stream test
--SKIPIF--
<?php require_once(__DIR__ . '/skipif.inc'); ?>
--FILE--
<?php

require_once(__DIR__ . '/new_db.inc');
require_once(__DIR__ . '/stream_test.inc');
define('TIMENOW', time());

echo "Creating Table\n";
var_dump($db->exec('CREATE TABLE test (id STRING, data BLOB)'));

echo "PREPARING insert\n";
$insert_stmt = $db->prepare("INSERT INTO test (id, data) VALUES (?, ?)");

echo "BINDING Parameter\n";
var_dump($insert_stmt->bindValue(1, 'a', SQLITE3_TEXT));
var_dump($insert_stmt->bindValue(2, 'TEST TEST', SQLITE3_BLOB));
$insert_stmt->execute();
echo "Closing statement\n";
var_dump($insert_stmt->close());
$stream = $db->openBlob('test', 'data', 1);
var_dump($stream);
echo "Stream Contents\n";
var_dump(stream_get_contents($stream));
echo "Writing to read-only stream\n";
var_dump(fwrite($stream, 'ABCD'));
echo "Closing Stream\n";
var_dump(fclose($stream));
echo "Opening stream in write mode\n";
$stream = $db->openBlob('test', 'data', 1, 'main', SQLITE3_OPEN_READWRITE);
var_dump($stream);
echo "Writing to blob\n";
var_dump(fwrite($stream, 'ABCD'));
echo "Stream Contents\n";
fseek($stream, 0);
var_dump(stream_get_contents($stream));
echo "Expanding blob size\n";
var_dump(fwrite($stream, 'ABCD ABCD ABCD'));
echo "Closing Stream\n";
var_dump(fclose($stream));
echo "Closing database\n";
var_dump($db->close());
echo "Done\n";
?>
--EXPECTF--
Creating Table
bool(true)
PREPARING insert
BINDING Parameter
bool(true)
bool(true)
Closing statement
bool(true)
resource(%d) of type (stream)
Stream Contents
string(9) "TEST TEST"
Writing to read-only stream

Warning: fwrite(): Can't write to blob stream: is open as read only in %s on line %d
bool(false)
Closing Stream
bool(true)
Opening stream in write mode
resource(%d) of type (stream)
Writing to blob
int(4)
Stream Contents
string(9) "ABCD TEST"
Expanding blob size

Warning: fwrite(): It is not possible to increase the size of a BLOB in %s on line %d
bool(false)
Closing Stream
bool(true)
Closing database
bool(true)
Done