sqlite_column

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

Fetches 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.

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.

Returns:

Returns the column value.

Notes:

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