How to convert data values ​​in database into array using PHP

In PHP development, we often need to obtain data from the database and convert it into an array for further processing and analysis. This article will introduce how to use PHP to convert data values ​​​​in the database into an array.

First, we need to connect to the database and get data from the database. Suppose we are using a MySQL database and we want to get all users' information from a table called "user". We can use the following code:

<?php // 连接到 MySQL 数据库
$conn = mysqli_connect("localhost", "username", "password", "database_name");

// 从 user 表中获取所有用户的信息
$result = mysqli_query($conn, "SELECT * FROM user");

// 关闭数据库连接
mysqli_close($conn);
?>

In the above code, we first use the mysqli_connect() function to connect to the MySQL database. We need to pass in 4 parameters: host name, user name, password and database name. Then, we use the mysqli_query() function to execute a query command to retrieve all user information from the "user" table. Finally, we close the connection using the mysqli_close() function.

Next, we need to convert the query results into an array. We can use the mysqli_fetch_array() function in PHP to accomplish this task. This function will return a row of data and store it in an array. It will also automatically point the pointer to the next row of data. Here is our new code:

<?php // 连接到 MySQL 数据库
$conn = mysqli_connect("localhost", "username", "password", "database_name");

// 从 user 表中获取所有用户的信息
$result = mysqli_query($conn, "SELECT * FROM user");

// 将查询结果转化为数组
$user_array = array();
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    $user_array[] = $row;
}

// 打印数组
print_r($user_array);

// 关闭数据库连接
mysqli_close($conn);
?>

In the above code, we first define an empty array $user_array. We then use a while loop to iterate through the query results and use mysqli_fetch_array() to convert each row of data into an array and store it in $user_array. Finally, we use the print_r() function to output the contents of the array.

In the above example, we used the MYSQLI_ASSOC parameter to specify that the mysqli_fetch_array() function returns an associative array, which means that the field name of each result is the key name in the array.

To summarize, we can use the mysqli_fetch_array() function in PHP to convert the data in the database into arrays, so that we can easily process and analyze them.

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