fetch value from an array

Question

I need to fetch value from an array .I need to fetch the value name,value,user_id from an given array

$inner_content='[{"name":"radio","value":"1","id":"1","user_id":"[email protected]","web":"571710720","type":"poll_info","pg":"question_response"},{"name":"fav-color[]","value":"blue"}]'


$id='5';  //value given for expample.
$inner="select * from user_response where POLL_ID=$id";
$inner1=mysql_query($inner);
while($ifet=mysql_fetch_assoc($inner1))
{
  $inner_content = $ifet['CONTENT_VALUES'];
  $data1 = json_decode($inner_content);
  $test1[]=array('name'=>$data1->name); 
}

the decoded json string turned into object has another dimension inside, its multi leveled, its supposed to be $data1[0]->name and so on — Kevin
– Kevin, Commented Feb 12, 2016 at 6:16

Barmar · Accepted Answer · 2016-02-12 06:20:41Z

3

In JSON, square brackets denote an array, and curly braces denote an object. As you can see if you look carefully at $inner_content, it's an array containing a bunch of objects, so you need to index it.

$test1[] = array('name' => $data1[0]->name);

This just gets the name from the first object in the array. If you want to get all the names, you could use a foreach loop on $data1 (but only the first one has all the properties that you say you want).

answered Feb 12, 2016 at 6:20

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

10 Comments

Barmar Over a year ago

That's not very meaningful. What is it doing instead? Are you getting any errors or warnings (make sure you have error_reporting(E_ALL) enabled)?

user3386779 Over a year ago

It return the word 'Array'

Barmar Over a year ago

@Sougata Presumably the JSON in his actual database isn't like the variable he posted in the question.

user3386779 Over a year ago

object(stdClass)#2 (7) { ["name"]=> string(5) "multi" ["value"]=> string(8) "option 4" ["id"]=> string(1) "4" ["user_id"]=> string(15) "[email protected]" ["web"]=> string(9) "571710720" ["type"]=> string(9) "poll_info" ["pagename"]=> string(17) "question_response" }

Barmar Over a year ago

If that's what var_dump says, then there's no way that $data1[0]->name could return the word Array. It should return multi.

|

Collectives™ on Stack Overflow

fetch value from an array

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related