[TOC]
## 執行SQL返回第一行 **pdo_fetch**
## 執行SQL返回全部記錄 **pdo_fetchall**
~~~
pdo_fetchall(string $sql, [array $params], [string $keyfield]);
~~~
**參數**
| | |
| -- | -- |
|$sql |string |需要執行的SQL語句|
|$params |array |參數列表|
|$keyfield |string |將該字段的值作為結果索引|
**返回值**
> 執行SQL返回全部記錄, 如果參數列表錯誤，返回 false。如果可選參數 $keyfield 不為空，則將該字段的值作為結果數組索引。
**示例**
~~~
$sql = 'SELECT * FROM ' . tablename('account') . ' WHERE `acid` > :acid';
$params = array(':acid' => '400');
$accounts = pdo_fetchall($sql, $params);
print_r($accounts);
Array
(
[0] => Array
(
[acid] => 434
[uniacid] => 288
[hash] => M3BaP3WR
[type] => 1
[isconnect] => 0
)
[1] => Array
(
[acid] => 433
[uniacid] => 288
[hash] => I01dujgC
[type] => 1
[isconnect] => 0
)
[2] => Array
(
[acid] => 440
[uniacid] => 444
[hash] => E33pwA88
[type] => 1
[isconnect] => 1
)
)
~~~
