sqlite_fetch_column_types(3) [php man page]

SQLITE_FETCH_COLUMN_TYPES(3)											      SQLITE_FETCH_COLUMN_TYPES(3)

sqlite_fetch_column_types - Return an array of column types from a particular table

SYNOPSIS

       array sqlite_fetch_column_types (string	$table_name, resource  $dbhandle, [int	$result_type = SQLITE_ASSOC])

DESCRIPTION

       Object oriented style (method): array SQLiteDatabase::fetchColumnTypes (string  $table_name, [int  $result_type = SQLITE_ASSOC])

       sqlite_fetch_column_types(3) returns an array of column data types from the specified $table_name table.

PARAMETERS

	      o $table_name
		- The table name to query.

	      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 $result_type
		- The optional $result_type parameter accepts a constant and determines how the returned array will be indexed. Using SQLITE_ASSOC
		will  return  only associative indices (named fields) while SQLITE_NUM will return only numerical indices (ordinal field numbers).
		SQLITE_ASSOC is the default for this function.

RETURN VALUES

	Returns an array of column data types; FALSE on error.

       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 $result_type |
       |	|		     |
       +--------+--------------------+
EXAMPLES

       Example #1

	      Procedural example

	      <?php
	      $db = sqlite_open('mysqlitedb');
	      sqlite_query($db, 'CREATE TABLE foo (bar varchar(10), arf text)');
	      $cols = sqlite_fetch_column_types('foo', $db, SQLITE_ASSOC);

	      foreach ($cols as $column => $type) {
		  echo "Column: $column  Type: $type
";
	      }
	      ?>

       Example #2

	      Object-oriented example

	      <?php
	      $db = new SQLiteDatabase('mysqlitedb');
	      $db->query('CREATE TABLE foo (bar varchar(10), arf text)');
	      $cols = $db->fetchColumnTypes('foo', SQLITE_ASSOC);

	      foreach ($cols as $column => $type) {
		  echo "Column: $column  Type: $type
";
	      }
	      ?>

	      The above example will output:

	      Column: bar  Type: VARCHAR
	      Column: arf  Type: TEXT

PHP Documentation Group 											      SQLITE_FETCH_COLUMN_TYPES(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)