How to Fetch a Single Column from a MySQL Table into a Single-Dimensional Array using PDO?

Retrieving a Single Column from a Table into a Single-Dimensional Array

When working with PDO and MySQL, extracting data from tables can be straightforward for single results and inserting new data. However, retrieving multiple results into a single-dimensional array may pose a challenge. This article explores how to achieve this specific operation using PDO's fetch methods.

You have a table named "ingredients" with a column called "ingredient_name". Your goal is to fetch all the ingredient names into a single array. Using the fetchAll() method would result in a multidimensional array, which is not the desired outcome. Instead, you require a method to obtain only the values from the specified column in a linear fashion.

To achieve this, PDO provides a specialized fetch method called FETCH_COLUMN. This method extracts the values from a specific column and returns them in a single-dimensional array. The following PHP code demonstrates this approach:

<?php
$sql = "SELECT `ingredient_name` FROM `ingredients`";
$ingredients = $pdo->query($sql)->fetchAll(PDO::FETCH_COLUMN);

In the above code, the query is executed using the query() method and the FETCH_COLUMN fetch mode is specified when calling fetchAll(). This fetches the "ingredient_name" column values into the $ingredients array, resulting in a single-dimensional array containing the ingredient names.

By utilizing PDO's FETCH_COLUMN fetch mode, you can easily retrieve a single column's values into a one-dimensional array, making it convenient for further processing and manipulation of the data.

The above is the detailed content of How to Fetch a Single Column from a MySQL Table into a Single-Dimensional Array using PDO?. For more information, please follow other related articles on the PHP Chinese website!