How to Pass multidimensional array to API using laravel

Question

I am fetching data from two tables using join, however, I want my result to return a multi-dimensional array , i.e.

FRUITS

Apple
Mango
Orange

Animal

Dog
Cat
Cow

Country

Germany
UK
USA

So, that is what I want it to return, see my code below

 Route::get('all-category', function(){

$category = DB::table('directory_companies')
             ->join('categories','directory_companies.categories_id', '=', 'categories.id')
            ->select('categories.name', 'directory_companies.*') 
             ->get();
return response()->json($category);

How do I return it to display like the list above in multidimensional array, I am using Laravel to build the API

You should use the laravel relationship it will be a lot easier laravel.com/docs/8.x/eloquent-relationships#querying-relations — ml59
– ml59, Commented Dec 14, 2020 at 14:23

BABAK ASHRAFI · Accepted Answer · 2020-12-14 15:22:52Z

1

You can use eloquent resource for displaying any structure you want for api.

Create resource and Reourse Collection

php artisan make:resource directory_companies
php artisan make:resource directory_companies_collection --collection

$category = DB::table('directory_companies')
             ->join('categories','directory_companies.categories_id', '=', 'categories.id')
            ->select('categories.name', 'directory_companies.*') 
             ->get();

return response()
    ->json(new directory_companies_collection(new directory_companies($category)));

And in your directory_companies resource:

public function toArray($request)
    {
        return [
            // Any structure of data you want to present
        ];
    }

answered Dec 14, 2020 at 15:22

BABAK ASHRAFI

4,3114 gold badges26 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Pass multidimensional array to API using laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related