How to convert query results into an array in PHP

PHP is a very popular programming language that is widely used in the development of web applications. In web applications, it is often necessary to obtain data from a database and convert this data into a format suitable for web rendering. This article will focus on how to convert query results into an array in PHP.

In PHP, we can use some SQL query statements to operate the database, such as SELECT, UPDATE, DELETE, etc. The SELECT statement among these statements is used to retrieve data from the database. Execute SQL query statements in PHP by using the mysqli_query function or PDO::query method.

The data format returned by the query results is usually a two-dimensional array, and each record is an array item. There are many ways to convert query results into arrays in PHP, and we will introduce two of them below.

First method: use the mysqli_fetch_array function to convert the query results into an array

After using the mysqli_query function to execute the SELECT statement, we can use the mysqli_fetch_array function to obtain the query results and convert them into array. The mysqli_fetch_array function returns each row of query results and converts it into an array.

The following is a sample code that uses the mysqli_fetch_array function to convert the query results into an array:

$conn = mysqli_connect("localhost", "username", "password", "database");

$result = mysqli_query($conn, "SELECT * FROM users");

while ($row = mysqli_fetch_array($result)) {
    $users[] = $row;
}

In the above sample code, we first establish a database connection and then execute the SELECT statement. Using a while loop structure, obtain each row of records by calling the mysqli_fetch_array function and store it in an array named $users.

Second method: Use PDO::FETCH_ASSOC to convert the query results into an associative array

If you use PDO to operate the database, PDO::FETCH_ASSOC converts the query results into an associative array An effective way. In PDO, we can use the PDO::query method to execute a SELECT statement and convert the query results into an associative array.

The following is a sample code that uses PDO::FETCH_ASSOC to convert the query results into an array:

$pdo = new PDO('mysql:host=localhost;dbname=database', 'username', 'password');

$stmt = $pdo->query('SELECT * FROM users');

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

In the above sample code, we create a PDO object and use its query method to execute the SELECT statement . Next, we use the fetchAll function to convert the query results into an associative array.

Summary

There are many ways to convert query results into arrays in PHP. This article introduces two effective methods: using the mysqli_fetch_array function to convert the query results into an array and using PDO::FETCH_ASSOC to convert the query results into an associative array. No matter which method you use, you can store the query results in an array and use it to implement various operations. I hope readers can master these methods and use them flexibly in actual development.

The above is the detailed content of How to convert query results into an array in PHP. For more information, please follow other related articles on the PHP Chinese website!