Home Backend Development PHP Problem How to convert query to array in php

How to convert query to array in php

Apr 25, 2023 am 10:32 AM

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 ) ) {
    // 处理查询结果
}
Copy after login

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 ) {
    // 处理查询结果
}
Copy after login

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 ) {
    // 处理查询结果
}
Copy after login

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 );
Copy after login

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!

Statement of this Website
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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

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

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

OWASP Top 10 PHP: Describe and mitigate common vulnerabilities. OWASP Top 10 PHP: Describe and mitigate common vulnerabilities. Mar 26, 2025 pm 04:13 PM

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 JIT (Just-In-Time) Compilation: How it improves performance. PHP 8 JIT (Just-In-Time) Compilation: How it improves performance. Mar 25, 2025 am 10:37 AM

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

PHP Encryption: Symmetric vs. asymmetric encryption. PHP Encryption: Symmetric vs. asymmetric encryption. Mar 25, 2025 pm 03:12 PM

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.

PHP Secure File Uploads: Preventing file-related vulnerabilities. PHP Secure File Uploads: Preventing file-related vulnerabilities. Mar 26, 2025 pm 04:18 PM

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.

PHP Authentication & Authorization: Secure implementation. PHP Authentication & Authorization: Secure implementation. Mar 25, 2025 pm 03:06 PM

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

PHP CSRF Protection: How to prevent CSRF attacks. PHP CSRF Protection: How to prevent CSRF attacks. Mar 25, 2025 pm 03:05 PM

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

PHP Input Validation: Best practices. PHP Input Validation: Best practices. Mar 26, 2025 pm 04:17 PM

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.

PHP API Rate Limiting: Implementation strategies. PHP API Rate Limiting: Implementation strategies. Mar 26, 2025 pm 04:16 PM

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

See all articles