php man page for sqlite_fetch_column_types

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)