Example of phpsqlite_query function
- /**
- * Simple example of sqlite_query function
- * By bbs.it-home.org
- */
- $ Sqldb = sqlite_open ("mydatabase. db ");
- $ Results = sqlite_query ($ sqldb, "SELECT * FROM employee ");
- While (list ($ empid, $ name) = sqlite_fetch_array ($ results )){
- Echo "Name: $ name (Employee ID: $ empid)
";
- }
- Sqlite_close ($ sqldb );
- ?>
Example 2: Use the sqlite Query () function
$ Db = sqlite_open (": memory :");
- If (! $ Db) die ("cocould not create the temporary database ");
$ Query = "create table cities (name VARCHAR (255), state VARCHAR (2 ))";
- Sqlite_query ($ db, $ query );
- $ Cities [] = array ('name' => 'Chicago ', 'state' => 'Il ');
- Foreach ($ cities as $ city ){
- $ Query = "insert into cities VALUES (". "'{$ city ['name']}', '{$ city ['state']}')";
- If (! Sqlite_query ($ db, $ query )){
- Trigger_error ("cocould not insert city". "'{$ city ['name']}, {$ city ['state']}");
- }
- }
- Sqlite_close ($ db );
- ?>
Example 3: sqlite_query query test
/**
- * Sqlite_query query test cases
- * By bbs.it-home.org
- */
- $ Dbconn = sqlite_open ('phpdb ');
If ($ dbconn ){
- Script!
- Sqlite_query ($ dbconn, "insert into animal VALUES ('A', 14 )");
- Sqlite_query ($ dbconn, "insert into animal VALUES ('B', 16 )");
- Sqlite_query ($ dbconn, "insert into animal VALUES ('C', 13 )");
- Var_dump (sqlite_array_query ($ dbconn, "SELECT * FROM animal", SQLITE_ASSOC ));
- } Else {
- Print "Connection to database failed! \ N ";
- }
- ?>
|