SQLite Functions
PHP Manual

sqlite_column

SQLiteResult->column

SQLiteUnbuffered->column

(PHP 5, PECL sqlite >= 1.0.0)

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

Description

mixed sqlite_column ( resource $result , mixed $index_or_name [, bool $decode_binary= true ] )
SQLiteResult
mixed column ( mixed $index_or_name [, bool $decode_binary= true ] )
SQLiteUnbuffered
mixed 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 .

Parameters

result

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

index_or_name

The column index or name to fetch.

decode_binary

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.

Notes

Note: 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 Functions
PHP Manual