Return to sqlite3_09_blob_bound_param.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / sqlite3 / tests

Annotation of embedaddon/php/ext/sqlite3/tests/sqlite3_09_blob_bound_param.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: SQLite3::prepare Bound Variable Blob test
                      3: --SKIPIF--
                      4: <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?>
                      5: --FILE--
                      6: <?php
                      7: 
                      8: require_once(dirname(__FILE__) . '/new_db.inc');
                      9: require_once(dirname(__FILE__) . '/stream_test.inc');
                     10: define('TIMENOW', time());
                     11: 
                     12: echo "Creating Table\n";
                     13: var_dump($db->exec('CREATE TABLE test (id STRING, data BLOB)'));
                     14: 
                     15: echo "PREPARING insert\n";
                     16: $insert_stmt = $db->prepare("INSERT INTO test (id, data) VALUES (?, ?)");
                     17: 
                     18: echo "Opening blob stream\n";
                     19: $foo = fopen('sqliteBlobTest://fooo', 'r');
                     20: var_dump($foo);
                     21: 
                     22: echo "BINDING Parameter\n";
                     23: var_dump($insert_stmt->bindValue(1, 'a', SQLITE3_TEXT));
                     24: var_dump($insert_stmt->bindParam(2, $foo, SQLITE3_BLOB));
                     25: $insert_stmt->execute();
                     26: echo "Closing statement\n";
                     27: var_dump($insert_stmt->close());
                     28: 
                     29: echo "SELECTING results\n";
                     30: $results = $db->query("SELECT id, quote(data) AS data FROM test ORDER BY id ASC");
                     31: while ($result = $results->fetchArray(SQLITE3_NUM))
                     32: {
                     33:        var_dump($result);
                     34: }
                     35: $results->finalize();
                     36: 
                     37: echo "Closing database\n";
                     38: var_dump($db->close());
                     39: echo "Done\n";
                     40: ?>
                     41: --EXPECTF--
                     42: Creating Table
                     43: bool(true)
                     44: PREPARING insert
                     45: Opening blob stream
                     46: resource(%d) of type (stream)
                     47: BINDING Parameter
                     48: bool(true)
                     49: bool(true)
                     50: Closing statement
                     51: bool(true)
                     52: SELECTING results
                     53: array(2) {
                     54:   [0]=>
                     55:   string(1) "a"
                     56:   [1]=>
                     57:   string(23) "X'61626364656667006869'"
                     58: }
                     59: Closing database
                     60: bool(true)
                     61: Done