How to Retrieve Column Values into an Array in PHP?

Retrieving Column Values into an Array in PHP

MySQL provides a vast array of data manipulation functions, including the ability to retrieve data from specific columns. In PHP, there are several approaches to accomplish this task.

One method involves using the PHP Database Object (PDO) extension. PDO offers a flexible and object-oriented interface for interacting with relational databases. To retrieve column values using PDO, you can utilize the following steps:

1. Prepare an SQL statement:

   $stmt = $pdo->prepare("SELECT Column FROM foo");

   Copy after login

2. Execute the prepared statement:

   $stmt->execute();

   Copy after login

   Copy after login

3. Fetch all values from the result:

   $array = $stmt->fetchAll(PDO::FETCH_COLUMN);

   Copy after login

4. Print the array contents:

   print_r($array);

   Copy after login

   Copy after login

Another approach to retrieve column values is by employing the MySQL Improved (mysqli) extension. This extension provides a procedural interface for interacting with MySQL databases. To achieve this:

1. Prepare an SQL statement:

   $stmt = $mysqli->prepare("SELECT Column FROM foo");

   Copy after login

2. Execute the prepared statement:

   $stmt->execute();

   Copy after login

   Copy after login

3. Iterate over the result to collect column values:

   $array = [];
   foreach ($stmt->get_result() as $row)
   {
    $array[] = $row['column'];
   }

   Copy after login

4. Print the array contents:

   print_r($array);

   Copy after login

   Copy after login

By implementing either of these approaches, you can efficiently retrieve values from a specific column in a MySQL database and store them in an array for further processing.

The above is the detailed content of How to Retrieve Column Values into an Array in PHP?. For more information, please follow other related articles on the PHP Chinese website!