# sqlite_column

# SQLiteResult::column

# SQLiteUnbuffered::column

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

sqlite_column -- SQLiteResult::column -- SQLiteUnbuffered::column — Fetches 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`.

### 参数

`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`

  当 `decode_binary` 参数设置为 `TRUE`（默认值）时，PHP 会解码那些由 sqlite_escape_string() 编码后的二进制数据。通常应保留此值为其默认值，除非要与其他使用 SQLlite 的应用程序建立的数据交互。

### 返回值

Returns the column value.

### 注释

> Note:

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

### 参见

- sqlite_fetch_string() - 别名 sqlite_fetch_single