json_encode error Object of class stdClass could not be converted to string

Question

I have a json_encode element and i have to implode it like that

<?php
$user = json_decode($var);
$fetch_array = implode(",", $user);
?>

with the debug print_f the array result like that

Array( [0] => stdClass Object ( [id] => 4 [name] => Elis ) 
       [1] => stdClass Object ( [id] => 5 [name] => Eilbert ))1

it result a error: Object of class stdClass could not be converted to string

My goal is use this json array with the statment SELECT IN on mysql,

SELECT * FROM table WHERE field IN $user

I tought that i have to implode it. if I delete the function implode it show me (array,array)

How can i do that?

Show please source json string and result you expect

Nicolai
– Nicolai

2013-10-01 14:00:20 +00:00
Commented Oct 1, 2013 at 14:00 — Nicolai
– Nicolai, Commented Oct 1, 2013 at 14:00

Rajesh · Accepted Answer · 2013-10-01 13:55:45Z

5

json_decode returns an object by default. In your case, you need an array. Add 2nd param as true as below:

json_decode($var, true);

answered Oct 1, 2013 at 13:55

Rajesh

3,7781 gold badge26 silver badges33 bronze badges

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

4 Comments

fabrizio Over a year ago

if i put the second parameter true it show me this error: Array to string conversion

Rajesh Over a year ago

Why do you have implode.? Its not needed. json_decode returns an array.

fabrizio Over a year ago

My goal is use this json array with the statment SELECT IN on mysql, I tought that i have to implode it. if I delete the function implode it show me (array,array)

Rajesh Over a year ago

sorry man. You need implode to convert array to comma delimited string. Then you can use inside mysql query.

Collectives™ on Stack Overflow

json_encode error Object of class stdClass could not be converted to string

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related