Home  >  Article  >  Backend Development  >  How to convert mysql data into an array in php

How to convert mysql data into an array in php

王林
王林Original
2023-05-07 19:28:36515browse

PHP is a popular server-side programming language, while MySQL is an open source relational database management system. Use the combination of PHP and MySQL to quickly create dynamic websites and web applications. In PHP, turning MySQL data into an array is a very common operation. This article will introduce how to use PHP to convert MySQL data into an array.

Generally speaking, we use PHP to connect to MySQL and query data, and then store the query results 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:

First, we connect to the MySQL database and use the mysqli_connect() function to establish the connection. 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.

Next, we execute the SQL query and store the 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. Therefore, we need to use the mysqli_num_rows() function before the while loop to check whether the number of result rows is greater than 0.

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

To summarize, converting MySQL data into a PHP array is an important operation in PHP programming, involving steps such as connecting to the database, executing queries, and traversing results. Mastering these basic skills allows us to better develop 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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn