How to convert mysql data into an array in php

PHP is usually used to connect to the MySQL database and perform data queries, and then store the results of the query in an array. The following is the relevant code:

//连接MySQL数据库

$host = "localhost";

$username = "root";

$password = "password";

$database = "mydatabase";

$conn = mysqli_connect($host, $username, $password, $database);

if(!$conn){

die("Connection failed: " . mysqli_connect_error());

}

//查询数据

$sql = "SELECT * FROM mytable";

$result = mysqli_query($conn, $sql);

//将查询结果存储在数组中

$data = array();

if(mysqli_num_rows($result) > 0){

while($row = mysqli_fetch_assoc($result)){

$data[] = $row;

}

}

mysqli_close($conn);

print_r($data);

Next, we explain this code one by one:

We first use the mysqli_connect() function to establish a connection and connect to the MySQL database. The mysqli_connect function needs to pass in four parameters, which are the host name of the MySQL server, user name, password and the database to be used.

Then, we run the SQL query statement and store the returned results in the $result variable. The mysqli_query() function receives two parameters. The first parameter is the connection object ($conn), and the second parameter is the SQL statement to be executed ($sql).

Then, we store the query results in the array $data. In the while loop, we use the mysqli_fetch_assoc() function to return the single row of data as an associative array and add it to the $data array. Finally, we display the array through the print_r() function.

It should be noted that if the query result is empty, the mysqli_fetch_assoc() function will return false, causing the while loop to exit. So, before the while loop, we need to use the mysqli_num_rows() function to verify whether any result row is greater than 0.

After converting MySQL data into a PHP array, we can easily traverse and operate on it. In addition, we can also perform operations such as searching, filtering, and sorting arrays to meet the needs of web applications.

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