Cannot use object of type stdClass as array laravel

Question

I know is simple but i don't know at this moment

In my controller i use

$result = DB::select("SELECT name FROM account_name WHERE name='".$name."'");

I can't get the data out from that array

dd($result) show me:

array:1 [
  0 => {#232
    +"name": "John"
  }
]

How to get that John out????

I have tried $result[0]["name"] but no success and give me that error

$result[0]->name

u_mulder
– u_mulder

2017-07-19 19:21:37 +00:00
Commented Jul 19, 2017 at 19:21 — u_mulder
– u_mulder, Commented Jul 19, 2017 at 19:21
simple and efficient :D thx

calin24
– calin24

2017-07-19 19:23:50 +00:00
Commented Jul 19, 2017 at 19:23 — calin24
– calin24, Commented Jul 19, 2017 at 19:23

tompec · Accepted Answer · 2017-07-19 19:25:33Z

2

$result = DB::table('account_name')->select('name')->where('name', $name)->first();

Then:

$result->name; // John

Or you can do:

$result = DB::table('account_name')->where('name', $name)->value('name');

Then:

$result; // John

edited Jul 19, 2017 at 19:25

answered Jul 19, 2017 at 19:18

tompec

1,2309 silver badges16 bronze badges

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

2 Comments

u_mulder Over a year ago

Aren't the results with get an array (or strictly said - collection)? Shouldn't you use first() instead?

calin24 Over a year ago

it is working ok :D thank you $result = DB::table('account_name')->where('name', $name)->value('name');

Nicolas · Accepted Answer · 2017-07-19 19:49:42Z

1

You can cast object to array like that (array) $object.
You can also check if it's an object : if(is_object($variable)) $variable = (array) $variable

answered Jul 19, 2017 at 19:49

Nicolas

8,7364 gold badges25 silver badges58 bronze badges

1 Comment

maximus1127 Over a year ago

plus points for type casting. i often find myself completely forgetting type casting even exists because php doesn't require it.

Collectives™ on Stack Overflow

Cannot use object of type stdClass as array laravel

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related