json data into php variables

Question

I have to parse this json data using PHP and store the values into PHP variables.

{  
"sender": "[email protected]",  
"receiver": "[email protected]",  
"msg_id": "[email protected]",   
"subject": "Group Discussion",   
"references": ["[email protected]","[email protected]","[email protected]"]
}

I am using this PHP code, its not working; pls check it.

For the fields 'sender', 'receiver', 'msg_id'and 'subject, I am using PHP variables '$msg_id', '$sender', '$receiver' and '$subject'.
I am trying to store the data of 'references' in the array 'ref_id'.

Also, the file 'dataset_f.json' has content in the following way:

{ "sender":"[email protected]","receiver":"[email protected]","msg_id":"[email protected]","subject": "Project Discussion","references":["[email protected]","[email protected]","[email protected]"]}

{ "sender":"[email protected]","receiver":"[email protected]","msg_id":"[email protected]","subject": "Project Discussion","references":["[email protected]","[email protected]","[email protected]"]}

Thats why the php code is reading the file line by line

<?php
$h1 = fopen("dataset_f.json", "r");
while(!feof($h1)){
$line = fgets($h1);
$test_case = json_decode($line);

$ref_id = array();
$msg_id = $test_case->{'msg_id'};
$sender = $test_case->{'sender'};
$receiver = $test_case->{'receiver'};
$subject = $test_case->{'subject'};
foreach($test_case as $val)
 {
    foreach($val -> references as $refer)
    {
        array_push($ref_id, $refer->ref);
    }
 }

// printing the values
$arrlen=count($ref_id);
 for($x=0;$x<$arrlen;$x++)
 { echo $ref_id[$x]." "; }
echo $msg_id." ".$sender." ".$receiver." ".$subject." <br> ";

}
?>

{[ is not valid JSON (unless it's part of a string). You can't have an array for a key. — Paul
– Paul, Commented May 12, 2014 at 4:44
You should be reading the entire file at once, not line by line. No single line in your input is a valid JSON. — UltraInstinct
– UltraInstinct, Commented May 12, 2014 at 4:45
@Thrustmaster That is true, but the entire thing isn't valid either. There are multiple problems here. — Paul
– Paul, Commented May 12, 2014 at 4:46

user3587554 · Accepted Answer · 2014-05-12 05:36:59Z

8

Store the whole file as a string, decode it and store the values in you variables. Show the json your using. your using the -> incorrect, thats for objects not arrays, json_decode() returns an associative array if the next param is true. ref_id will hold a string thats comma separated.

dataset_f.json

{
    "sender":"[email protected]",
    "receiver":"[email protected]",
    "msg_id":"[email protected]",
    "subject":"Group Discussion",
    "references":["[email protected]","[email protected]","[email protected]"]
}

php code

$json = file_get_contents("dataset_f.json");

$data = json_decode($json, true);

// here depends on the json

$ref_id = ( ( is_array( $data["references"] ) ? implode(", ", $data["references"]) : $data["references"] ) ); // array to string
$msg_id = $data["msg_id"];
$sender = $data["sender"];
$receiver = $data["receiver"];
$subject = $data["subject"];

edited May 12, 2014 at 5:36

answered May 12, 2014 at 5:14

user3587554

3531 silver badge7 bronze badges

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

4 Comments

user3587554 Over a year ago

your welcome, if you need to create the json I can help with that too.

Akash Goyal Over a year ago

With your useful answer, I can do it now. And now I dont have enough reputation to VOTE UP your answer. But when I will have sufficient repu.. I will do it for sure. Thanks a lot @user3587554

Paul Over a year ago

@AkashGoyal You may not be able to vote up his answer, but if it has solved your problem, you can accept it by clicking on the checkmark under the voting arrows. That marks it as a solution and awards bot you and user3587554 with rep.

Akash Goyal Over a year ago

Oh ThankYou, I was not knowing about this feature

Collectives™ on Stack Overflow

json data into php variables

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