# PHP_PDO_fetchAll的模式選擇
----
###### tags: `PHP` `PDO`

## 重要
[PDO Fetch Modes](https://phpdelusions.net/pdo/fetch_modes)

如何FETCH Array
[How to use PDO to fetch results array in PHP?
](https://stackoverflow.com/questions/10911757/how-to-use-pdo-to-fetch-results-array-in-php)

---

在第一個網址中最常使用就是經典模式

## Classic Modes 經典模式
- Classic Modes
- PDO::FETCH_BOTH
- PDO::FETCH_NUM
- PDO::FETCH_ASSOC
- PDO::FETCH_OBJ

----

因連線資源一次只能使用一個


## PDO::FETCH_OBJ

### return stdClass

$list = $stmt->fetchAll(PDO::FETCH_OBJ);


## PDO::FETCH_ASSOC

### return field => value

$list = $stmt->fetchAll(PDO::FETCH_ASSOC);


## PDO::FETCH_NUM

### return numerical keys

$list = $stmt->fetchAll(PDO::PDO::FETCH_NUM);


## PDO::FETCH_BOTH

### return FETCH_兩種都有

$list = $stmt->fetchAll(PDO::PDO::FETCH_BOTH);