---
# System prepended metadata

title: PHP_PDO_fetchAll的模式選擇
tags: [PHP, PDO]

---

# 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

----

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

![](https://i.imgur.com/dQKmNk2.png)


## PDO::FETCH_OBJ

### return stdClass

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

![](https://i.imgur.com/IHXWxZd.png)






## PDO::FETCH_ASSOC

### return field => value

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

![](https://i.imgur.com/0Qf1J3E.png)








## PDO::FETCH_NUM

### return numerical keys

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

![](https://i.imgur.com/kSirhwo.png)








## PDO::FETCH_BOTH

### return FETCH_兩種都有

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

![](https://i.imgur.com/aoZ0zgj.png)