Please wait while we load your page...


PHP Manual :: sqlite_column

sqlite_close || sqlite_create_aggregate || SQLite Functions || PHP Manual

(PHP 5 < 5.4.0, PECL sqlite >= 1.0.0)

sqlite_column -- SQLiteResult::column -- SQLiteUnbuffered::columnFetches a column from the current row of a result set


mixed sqlite_column ( resource $result , mixed $index_or_name [, bool $decode_binary = true ] )
mixed SQLiteResult::column ( mixed $index_or_name [, bool $decode_binary = true ] )
mixed SQLiteUnbuffered::column ( mixed $index_or_name [, bool $decode_binary = true ] )

Fetches the value of a column named index_or_name (if it is a string), or of the ordinal column numbered index_or_name (if it is an integer) from the current row of the query result handle result.



The SQLite result resource. This parameter is not required when using the object-oriented method.


The column index or name to fetch.


When the decode_binary parameter is set to TRUE (the default), PHP will decode the binary encoding it applied to the data if it was encoded using the sqlite_escape_string(). You should normally leave this value at its default, unless you are interoperating with databases created by other sqlite capable applications.

Return Values

Returns the column value.



Use this function when you are iterating a large result set with many columns, or with columns that contain large amounts of data.

See Also

sqlite_close || sqlite_create_aggregate || SQLite Functions || PHP Manual
Live Chat Not Available