sqlite_factory(3) [php man page]

SQLITE_FACTORY(3)														 SQLITE_FACTORY(3)

sqlite_factory - Opens an SQLite database and returns an SQLiteDatabase object

SYNOPSIS

       SQLiteDatabase sqlite_factory (string  $filename, [int  $mode = 0666], [string  &$error_message])

DESCRIPTION

       sqlite_factory(3)  behaves  similarly  to sqlite_open(3) in that it opens an SQLite database or attempts to create it if it does not exist.
       However, a SQLiteDatabase object is returned rather than a resource. Please see the sqlite_open(3) reference page  for  further	usage  and
       caveats.

PARAMETERS

	      o $filename
		- The filename of the SQLite database.

	      o $mode
		-  The	mode  of the file. Intended to be used to open the database in read-only mode. Presently, this parameter is ignored by the
		sqlite library. The default value for mode is the octal value 0666 and this is the recommended value.

	      o $error_message
		- Passed by reference and is set to hold a descriptive error message explaining why the database could not be opened if there  was
		an error.

RETURN VALUES

	Returns an SQLiteDatabase object on success, NULL on error.

EXAMPLES

       Example #1

	      sqlite_factory(3) example

	      <?php
	      $dbhandle = sqlite_factory('sqlitedb');
	      $dbhandle->query('SELECT user_id, username FROM users');

	      /* functionally equivalent to: */

	      $dbhandle = new SQLiteDatabase('sqlitedb');
	      $dbhandle->query('SELECT user_id, username FROM users');

	      ?>

SEE ALSO

       sqlite_open(3), sqlite_popen(3).

PHP Documentation Group 													 SQLITE_FACTORY(3)

SQLITE_EXEC(3)															    SQLITE_EXEC(3)

sqlite_exec - Executes a result-less query against a given database

SYNOPSIS

       bool sqlite_exec (resource  $dbhandle, string  $query, [string  &$error_msg])

DESCRIPTION

       bool sqlite_exec (string  $query, resource  $dbhandle)

       Object oriented style (method): bool SQLiteDatabase::queryExec (string  $query, [string	&$error_msg])

	Executes an SQL statement given by the $query against a given database handle (specified by the $dbhandle parameter).

       Warning

	       SQLite will execute multiple queries separated by semicolons, so you can use it to execute a batch of SQL that you have loaded from
	      a file or have embedded in a script.

PARAMETERS

	      o $dbhandle
		- The SQLite Database resource; returned from sqlite_open(3) when used procedurally. This parameter is not required when using the
		object-oriented method.

	      o $query
		- The query to be executed.  Data inside the query should be properly escaped.

	      o $error_msg
		- The specified variable will be filled if an error occurs. This is specially important because SQL syntax errors can't be fetched
		using the sqlite_last_error(3) function.

       Note

	      Two alternative syntaxes are supported for compatibility with other database extensions (such as MySQL). The preferred form  is  the
	      first, where the $dbhandle parameter is the first parameter to the function.

RETURN VALUES

	This  function	will  return  a  boolean  result; TRUE for success or FALSE for failure. If you need to run a query that returns rows, see
       sqlite_query(3).

       The column names returned by SQLITE_ASSOC and SQLITE_BOTH will be case-folded according to the value of the sqlite.assoc_case configuration
       option.

CHANGELOG

       +--------+---------------------------------+
       |Version |				  |
       |	|				  |
       |	|	    Description 	  |
       |	|				  |
       +--------+---------------------------------+
       | 5.1.0	|				  |
       |	|				  |
       |	|  Added the $error_msg parameter |
       |	|				  |
       +--------+---------------------------------+
EXAMPLES

       Example #1

	      Procedural example

	      <?php
	      $dbhandle = sqlite_open('mysqlitedb');
	      $query = sqlite_exec($dbhandle, "UPDATE users SET email='jDoe@example.com' WHERE username='jDoe'", $error);
	      if (!$query) {
		  exit("Error in query: '$error'");
	      } else {
		  echo 'Number of rows modified: ', sqlite_changes($dbhandle);
	      }
	      ?>

       Example #2

	      Object-oriented example

	      <?php
	      $dbhandle = new SQLiteDatabase('mysqlitedb');
	      $query = $dbhandle->queryExec("UPDATE users SET email='jDoe@example.com' WHERE username='jDoe'", $error);
	      if (!$query) {
		  exit("Error in query: '$error'");
	      } else {
		  echo 'Number of rows modified: ', $dbhandle->changes();
	      }
	      ?>

SEE ALSO

       sqlite_query(3), sqlite_unbuffered_query(3), sqlite_array_query(3).

PHP Documentation Group 													    SQLITE_EXEC(3)