How to convert query to array in php
In PHP programming, querying the database is a very common operation, and the need to convert query results into an array is equally common. PHP has many built-in functions to facilitate querying and array conversion. This article will introduce you to several common methods to help you better handle queries and array conversion in PHP.
1. Use the mysqli_fetch_array function to convert the query results into an associative array
The mysqli_fetch_array function can convert the query results into an associative array, and at the same time, array elements can be accessed as numeric subscripts. The specific usage of this function is as follows:
$result = mysqli_query( $conn, $query ); while ( $row = mysqli_fetch_array( $result, MYSQLI_ASSOC ) ) { // 处理查询结果 }
Among them, $conn is the mysqli object connected to the database, and $query is the query statement. Using the mysqli_fetch_array function in a while loop can obtain one row of query results each time and convert it into an associative array, and access the array elements through $row['attribute name'].
2. Use the mysqli_fetch_all function to convert the query results into a two-dimensional array
The mysqli_fetch_all function can convert the query results into a two-dimensional array. This function saves all query results in an array at one time. The specific usage is as follows:
$result = mysqli_query( $conn, $query ); $all_rows = mysqli_fetch_all( $result, MYSQLI_ASSOC ); foreach ( $all_rows as $row ) { // 处理查询结果 }
Among them, $conn is the mysqli object connected to the database, and $query is the query statement. After using the mysqli_fetch_all function, the $all_rows variable becomes a two-dimensional array, and the array elements can be accessed through a double loop.
3. Use the PDO query method to convert the query results into an associative array
The PDO query method can also convert the query results into an associative array. The specific method is as follows:
$pdo = new PDO( $dsn, $user, $password ); $stmt = $pdo->query( $query ); $rows = $stmt->fetchAll( PDO::FETCH_ASSOC ); foreach ( $rows as $row ) { // 处理查询结果 }
Among them, $dsn is the DSN string used to connect to the database, $user and $password are the username and password used to connect to the database. In a PDO query, use the fetchAll method to convert the query results into an associative array, and then access the array elements through a foreach loop.
4. Use the array_column function to extract column information from a two-dimensional array
Sometimes, we need to quickly extract a certain column of information from a two-dimensional array, and we can use the array_column function. The specific usage of this function is as follows:
$rows = array( array( 'id' => 1, 'name' => '张三', 'age' => 20 ), array( 'id' => 2, 'name' => '李四', 'age' => 22 ), array( 'id' => 3, 'name' => '王五', 'age' => 26 ) ); $names = array_column( $rows, 'name' ); print_r( $names );
In this example, we have a two-dimensional array $rows, which contains the id, name and age information of each person. Through the array_column function, we extract a new array $names from $rows, which only contains the name information of each person.
The above are several commonly used query and array conversion methods. In actual programming, we can choose the method that suits us best according to our needs. I wish you all better results in PHP programming!
The above is the detailed content of How to convert query to array in php. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

The article discusses OWASP Top 10 vulnerabilities in PHP and mitigation strategies. Key issues include injection, broken authentication, and XSS, with recommended tools for monitoring and securing PHP applications.

PHP 8's JIT compilation enhances performance by compiling frequently executed code into machine code, benefiting applications with heavy computations and reducing execution times.

The article discusses symmetric and asymmetric encryption in PHP, comparing their suitability, performance, and security differences. Symmetric encryption is faster and suited for bulk data, while asymmetric is used for secure key exchange.

The article discusses securing PHP file uploads to prevent vulnerabilities like code injection. It focuses on file type validation, secure storage, and error handling to enhance application security.

The article discusses implementing robust authentication and authorization in PHP to prevent unauthorized access, detailing best practices and recommending security-enhancing tools.

The article discusses strategies to prevent CSRF attacks in PHP, including using CSRF tokens, Same-Site cookies, and proper session management.

Article discusses best practices for PHP input validation to enhance security, focusing on techniques like using built-in functions, whitelist approach, and server-side validation.

The article discusses strategies for implementing API rate limiting in PHP, including algorithms like Token Bucket and Leaky Bucket, and using libraries like symfony/rate-limiter. It also covers monitoring, dynamically adjusting rate limits, and hand
