php How to get it pure array from Eloquent Laravel

Question

Here is my Query

$reminderData = Reminder::where('status', 1)->get()->toArray();

Here is my Result

[
{"id":1,"reminder_type":2,"reminder_name":"first","reminder_date":"2016-10-26"},
{"id":2,"reminder_type":2,"reminder_name":"second","reminder_date":"2016-10-26"},
{"id":3,"reminder_type":2,"reminder_name":"third","reminder_date":"2016-10-26"},
]

But i need like

[
["id":1,"reminder_type":2,"reminder_name":"first","reminder_date":"2016-10-26"],
["id":2,"reminder_type":2,"reminder_name":"second","reminder_date":"2016-10-26"],
["id":3,"reminder_type":2,"reminder_name":"third","reminder_date":"2016-10-26"],
]

How can i do this ?

You're showing JSON there, not an array. Where are you converting to JSON? And the desired output is not valid JSON. — jszobody
– jszobody, Commented Oct 26, 2016 at 13:11
No, it's not. Your "result" is a json string, that's not what Eloquent toArray() provides. — jszobody
– jszobody, Commented Oct 26, 2016 at 13:14
Do this: dd(Reminder::where('status', 1)->get()->toArray());. — jszobody
– jszobody, Commented Oct 26, 2016 at 13:15
You need to show more of your code. Somewhere you are outputting the array as JSON and you are confused. If you try that dd code I gave you, you'll see you absolutely have an array from Eloquent, not json. — jszobody
– jszobody, Commented Oct 26, 2016 at 13:16
Excellent. So: you see you have an array of arrays. Which is exactly what you wanted. Your code is fine, it's already giving you the structure you are asking for. — jszobody
– jszobody, Commented Oct 26, 2016 at 13:27

Alexey Mezenin · Accepted Answer · 2016-10-26 13:19:28Z

1

It actually returns array of arrays. You you'll use dd() on both levels, you'll see an array data type.

Also, you can get only columns you need with ->get(['id', 'reminder_type', 'reminder_date'])

edited Oct 26, 2016 at 13:19

answered Oct 26, 2016 at 13:06

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

8 Comments

SA__ Over a year ago

ah, i am getting this as my result now {"2":1,"1":2,"3":3}

Alexey Mezenin Over a year ago

@SA__, oh yeah, sorry. Fixed.

SA__ Over a year ago

Ohh.. that's ok .. Stilll i am getting like this

[{"id":1,"reminder_type":2,"reminder_date":"2016-10-26"},{"id":2,"reminder_type":1,"reminder_date":"2016-10-26"},{"id":3,"reminder_type":3,"reminder_date":"0000-00-00"}]

SA__ Over a year ago

ah, i tried in your way.. not sure, why it is not giving the expected behaviour. btw i am using laravel 5.1

Alexey Mezenin Over a year ago

@SA__ try to do dd($reminderData ) and you'll see an array data type. Then try to do dd($reminderData[0]) and it will show you a type of one row which will be also array.

|

RiggsFolly · Accepted Answer · 2016-10-26 13:31:06Z

0

$reminderData = Reminder::where('status', 1)->pluck('column_name1', 'column_name2')

In the laravel 5.0 and above version "pluck" method return data in the array format

edited Oct 26, 2016 at 13:31

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

answered Oct 26, 2016 at 13:29

Hitesh Sharma

951 silver badge7 bronze badges

Comments

Md Rashedul Hoque Bhuiyan · Accepted Answer · 2016-10-26 13:45:20Z

0

Try this one

\Illuminate\Support\Facades\DB::setFetchMode(PDO::FETCH_ASSOC);
$values=\Illuminate\Support\Facades\DB::select("select * from  your_table");
\Illuminate\Support\Facades\DB::setFetchMode(PDO::FETCH_CLASS);
var_dump($values);

answered Oct 26, 2016 at 13:45

Md Rashedul Hoque Bhuiyan

10.7k5 gold badges33 silver badges42 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:06:43Z

0

As wrote in comments:

it looks like dirty hack and it can cause unexpected behavior with more complicated data

You can return

 json_decode(Reminder::where('status', 1)->get(), true);

as already asked here

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Oct 26, 2016 at 13:22

GiuServ

1,2351 gold badge15 silver badges35 bronze badges

4 Comments

Alexey Mezenin Over a year ago

why on Earth you want to json_decode an Eloquent collection?

GiuServ Over a year ago

Never, but the question is to return an array of array, and it does.

Doaa Magdy Over a year ago

The default array structure returned by Laravel is similar to json formatted arrays, so in order to let PHP convert it to standard array, you must use json_decode method

Alexey Mezenin Over a year ago

@DoaaMagdy, it doesn't look like json at all. If you see {}, it doesn't mean it's json. It's completely different data type. The code above will give you an error.

Collectives™ on Stack Overflow

php How to get it pure array from Eloquent Laravel

4 Answers 4

8 Comments

Comments

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

8 Comments

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related