File: sqlite_exec_basic.phpt

package info (click to toggle)
php5 5.3.3-7%2Bsqueeze17
  • links: PTS, VCS
  • area: main
  • in suites: squeeze
  • size: 122,824 kB
  • ctags: 55,742
  • sloc: ansic: 633,963; php: 19,620; sh: 11,344; xml: 5,816; cpp: 2,400; yacc: 1,745; exp: 1,514; makefile: 1,019; pascal: 623; awk: 537; sql: 22
file content (34 lines) | stat: -rw-r--r-- 892 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
--TEST--
Test sqlite_exec() function : basic functionality 
--SKIPIF--
<?php if (!extension_loaded("sqlite")) print "skip sqlite extension not loaded"; ?>
--FILE--
<?php
/* Prototype  : boolean sqlite_exec(string query, resource db[, string &error_message])
 * Description: Executes a result-less query against a given database 
 * Source code: ext/sqlite/sqlite.c
 * Alias to functions: 
 */

echo "*** Testing sqlite_exec() : basic functionality ***\n";

// set up variables
$query = 'CREATE TABLE foobar (id INTEGER PRIMARY KEY, name CHAR(255));';
$error_message = null;

// procedural
$db = sqlite_open(':memory:');
var_dump( sqlite_exec($db, $query) );
sqlite_close($db);

// oo-style
$db = new SQLiteDatabase(':memory:');
var_dump( $db->queryExec($query, $error_message) );

?>
===DONE===
--EXPECTF--
*** Testing sqlite_exec() : basic functionality ***
bool(true)
bool(true)
===DONE===