search
HomePHP FrameworkLaravelHow to convert result set to array in Laravel

When you need to use a database query in a Laravel application, Laravel's query builder provides many methods to obtain and process the returned result set. Use these methods to convert the result set into an array or collection for easier processing. This article will explain how to use the Laravel query builder to convert a result set into an array.

1. Convert the result set to an array

Laravel's query builder provides the toArray() method to convert the result set into an array. The toArray() method will return an array consisting of the attributes of each query result row, where each row is an associative array, the key is the attribute name, and the value is the attribute value corresponding to the row.

For example, the following code will query all records in the users table and convert the result set into an array:

$users = DB::table('users')->get()->toArray();

In this example, first call the get() method to get all user records, On this basis, call the toArray() method to convert the result set into an array, and assign the result to the $users variable.

You can use the print_r() or var_dump() function to view the results, as shown below:

print_r($users);

Output results:

Array
(
    [0] => Array
        (
            [id] => 1
            [name] => John
            [email] => john@example.com
        )

    [1] => Array
        (
            [id] => 2
            [name] => Jane
            [email] => jane@example.com
        )

)

2. Convert the result set to a pure Array

Sometimes, we need to convert the result set into a simple associative array instead of a subarray for each row. We can easily achieve this by calling the pluck() and toArray() methods.

For example, the following code will query all records in the users table and convert the name column in the result set into a pure array:

$names = DB::table('users')->pluck('name')->toArray();

In this example, the pluck() method is first called Get all name attribute values, call the toArray() method to convert the result set into an array, and assign the result to the $names variable.

You can use the print_r() or var_dump() function to view the results, as shown below:

print_r($names);

Output results:

Array
(
    [0] => John
    [1] => Jane
)

3. Convert the set to an array

In addition to converting result sets to arrays, Laravel also provides methods for converting collections to arrays. A collection is an object that represents a collection of multiple objects and provides advanced operations on the collection.

Use the collect() method to convert the result set into a collection, and then use the toArray() method to convert the collection into an array. For example, the following code will query all records in the users table and convert the result set into a collection and array:

$users_collection = collect(DB::table('users')->get());
$users_array = $users_collection->toArray();

In this example, first call the get() method to get all user records, and use collect( ) method converts the result set into a collection. Then call the toArray() method to convert the collection to an array and assign the result to the $users_array variable.

You can use the print_r() or var_dump() function to view the results, as shown below:

print_r($users_array);

Output results:

Array
(
    [0] => Array
        (
            [id] => 1
            [name] => John
            [email] => john@example.com
        )

    [1] => Array
        (
            [id] => 2
            [name] => Jane
            [email] => jane@example.com
        )

)

Summary:

Laravel The query builder provides many methods to convert the result set into an array or collection for easier processing. This article demonstrates how to use the Laravel query builder to convert a result set to an array or a pure array, as well as a method to convert a collection to an array. These methods will be very useful when doing Laravel development.

The above is the detailed content of How to convert result set to array in Laravel. 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
The Illusion of Inclusion: Addressing Isolation and Loneliness in Remote WorkThe Illusion of Inclusion: Addressing Isolation and Loneliness in Remote WorkApr 25, 2025 am 12:28 AM

Tocombatisolationandlonelinessinremotework,companiesshouldimplementregular,meaningfulinteractions,provideequalgrowthopportunities,andusetechnologyeffectively.1)Fostergenuineconnectionsthroughvirtualcoffeebreaksandpersonalsharing.2)Ensureremoteworkers

Laravel for Full-Stack Development: A Comprehensive GuideLaravel for Full-Stack Development: A Comprehensive GuideApr 25, 2025 am 12:27 AM

Laravelispopularforfull-stackdevelopmentbecauseitoffersaseamlessblendofbackendpowerandfrontendflexibility.1)Itsbackendcapabilities,likeEloquentORM,simplifydatabaseinteractions.2)TheBladetemplatingengineallowsforclean,dynamicHTMLtemplates.3)LaravelMix

Video Conferencing Showdown: Choosing the Right Platform for Remote MeetingsVideo Conferencing Showdown: Choosing the Right Platform for Remote MeetingsApr 25, 2025 am 12:26 AM

Key factors in choosing a video conferencing platform include user interface, security, and functionality. 1) The user interface should be intuitive, such as Zoom. 2) Security needs to be paid attention to, and Microsoft Teams provides end-to-end encryption. 3) Functions need to match requirements, GoogleMeet is suitable for short meetings, and CiscoWebex provides advanced collaboration tools.

What database versions are compatible with the latest Laravel?What database versions are compatible with the latest Laravel?Apr 25, 2025 am 12:25 AM

The latest version of Laravel10 is compatible with MySQL 5.7 and above, PostgreSQL 9.6 and above, SQLite 3.8.8 and above, SQLServer 2017 and above. These versions are chosen because they support Laravel's ORM features, such as the JSON data type of MySQL5.7, which improves query and storage efficiency.

The Benefits of Using Laravel as a Full-Stack FrameworkThe Benefits of Using Laravel as a Full-Stack FrameworkApr 25, 2025 am 12:24 AM

Laravelisanexcellentchoiceforfull-stackdevelopmentduetoitsrobustfeaturesandeaseofuse.1)ItsimplifiescomplextaskswithitsmodernPHPsyntaxandtoolslikeBladeforfront-endandEloquentORMforback-end.2)Laravel'secosystem,includingLaravelMixandArtisan,enhancespro

What is the latest version of Laravel?What is the latest version of Laravel?Apr 24, 2025 pm 05:17 PM

Laravel10,releasedonFebruary7,2023,isthelatestversion.Itfeatures:1)Improvederrorhandlingwithanewreportmethodintheexceptionhandler,2)EnhancedsupportforPHP8.1featureslikeenums,and3)AnewLaravel\Promptspackageforinteractivecommand-lineprompts.

How does the newest Laravel version simplify development?How does the newest Laravel version simplify development?Apr 24, 2025 pm 05:01 PM

ThelatestLaravelversionenhancesdevelopmentwith:1)Simplifiedroutingusingimplicitmodelbinding,2)EnhancedEloquentcapabilitieswithnewquerymethods,and3)ImprovedsupportformodernPHPfeatureslikenamedarguments,makingcodingmoreefficientandenjoyable.

Where can I find the release notes for the latest Laravel version?Where can I find the release notes for the latest Laravel version?Apr 24, 2025 pm 04:53 PM

You can find the release notes for the latest Laravel version at laravel.com/docs. 1) Release Notes provide detailed information on new features, bug fixes and improvements. 2) They contain examples and explanations to help understand the application of new features. 3) Pay attention to the potential complexity and backward compatibility issues of new features. 4) Regular review of release notes can keep it updated and inspire innovation.

See all articles

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

SecLists

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

Atom editor mac version download

Atom editor mac version download

The most popular open source editor