Please wait while we load your page...


Latest Version [8.00202205221] Last Updated [May-22-2022]


PHP Manual [sqlite_column]

Protect Your Website Today

PHP Manual || SQLite Functions

(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


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 ] ) : mixed

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

PHP Manual || SQLite Functions