How to Retrieve All Values from a Database Column Using PHP?

How to Retrieve All Values from a Database Column Using PHP

Retrieving all values from a specific column in a MySQL database can be a common task when working with data. This article provides a comprehensive solution for accomplishing this task using PHP.

Obtaining Values Using PDO or MySQLi

There are two popular PHP extensions for interacting with MySQL databases: PDO (PHP Data Objects) and MySQLi. Both offer different approaches to retrieving data from columns.

Method 1: Using PDO

The PDO extension allows for parameterized queries, which improve security against SQL injection. To retrieve all values from a column named "Column" in a table named "foo," you can execute this code snippet:

<code class="php">$stmt = $pdo->prepare("SELECT Column FROM foo");
$stmt->execute();
$array = $stmt->fetchAll(PDO::FETCH_COLUMN);
print_r($array);</code>

Method 2: Using MySQLi

MySQLi offers an alternative method for interacting with MySQL databases. Here's how you can retrieve column values using MySQLi:

<code class="php">$stmt = $mysqli->prepare("SELECT Column FROM foo");
$stmt->execute();
$array = [];
foreach ($stmt->get_result() as $row) {
    $array[] = $row['column'];
}
print_r($array);</code>

Output

Both methods will print the array of values from the specified column:

Array
(
    [0] => 7960
    [1] => 7972
    [2] => 8028
    [3] => 8082
    [4] => 8233
)

The above is the detailed content of How to Retrieve All Values from a Database Column Using PHP?. For more information, please follow other related articles on the PHP Chinese website!