Return to sqlite_exec_basic.phpt CVS log

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

Annotation of embedaddon/php/ext/sqlite/tests/sqlite_exec_basic.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: Test sqlite_exec() function : basic functionality 
                      3: --SKIPIF--
                      4: <?php if (!extension_loaded("sqlite")) print "skip sqlite extension not loaded"; ?>
                      5: --FILE--
                      6: <?php
                      7: /* Prototype  : boolean sqlite_exec(string query, resource db[, string &error_message])
                      8:  * Description: Executes a result-less query against a given database 
                      9:  * Source code: ext/sqlite/sqlite.c
                     10:  * Alias to functions: 
                     11:  */
                     12: 
                     13: echo "*** Testing sqlite_exec() : basic functionality ***\n";
                     14: 
                     15: // set up variables
                     16: $query = 'CREATE TABLE foobar (id INTEGER PRIMARY KEY, name CHAR(255));';
                     17: $error_message = null;
                     18: 
                     19: // procedural
                     20: $db = sqlite_open(':memory:');
                     21: var_dump( sqlite_exec($db, $query) );
                     22: sqlite_close($db);
                     23: 
                     24: // oo-style
                     25: $db = new SQLiteDatabase(':memory:');
                     26: var_dump( $db->queryExec($query, $error_message) );
                     27: 
                     28: ?>
                     29: ===DONE===
                     30: --EXPECTF--
                     31: *** Testing sqlite_exec() : basic functionality ***
                     32: bool(true)
                     33: bool(true)
                     34: ===DONE===