Parse JSON on PHP and extract the particular value(s)

Question

Objective: To parse following json string and get mentioned values separately, later those separated values are going to be inserted to mysql database.
I have checked my json string on JsonLint

user_name,
selected_date,
selected_project,

tasks , 4.1.task_name, 4.2 work_hours

{
"user_name": "USER",
"selected_date": "2015-06-08",
"selected_project": "Project1",
"tasks": [
    {
        "task_name": "task-1",
        "work_hours": [
            {
            "Monday": " 3"
            },
            {
            "Tuesday": " 0"
            },
            {
            "Wednesday": " 2.5"
            },
            {
            "Thursday": " 2"
            },
            {
            "Friday": " 0"
            },
            {
            "Saturday": " 0"
            },
            {
            "Sunday": " 0"
            }
        ]
    }
] 
}

PHP code is:

$str_json = file_get_contents('php://input'); //($_POST doesn't work here)
$response = json_decode($str_json, true); // decoding received JSON to array
$jsonIterator = new RecursiveIteratorIterator(
new RecursiveArrayIterator(json_decode($response, TRUE)),
RecursiveIteratorIterator::SELF_FIRST);
foreach ($jsonIterator as $key => $val) 
{
 if(is_array($val)) 
 {
   echo "$key:\n";
 } 
 else 
 {
   echo "$key => $val\n";
   echo "$value";
 }
}

As i am new to JSON and PHP, i could not solve this, help would be appreciated.

PHPhil · Accepted Answer · 2015-06-15 16:49:30Z

1

    <?
$json = '{
"user_name": "USER",
"selected_date": "2015-06-08",
"selected_project": "Project1",
"tasks": [
    {
        "task_name": "task-1",
        "work_hours": [
            {
            "Monday": " 3"
            },
            {
            "Tuesday": " 0"
            },
            {
            "Wednesday": " 2.5"
            },
            {
            "Thursday": " 2"
            },
            {
            "Friday": " 0"
            },
            {
            "Saturday": " 0"
            },
            {
            "Sunday": " 0"
            }
        ]
    }
] 
}';

// decode your json  into associative arrays
$decoded = json_decode($json, true);

// use array
echo "Username: ". $decoded['user_name'] . "<br>";
echo "Date: ". $decoded['selected_date'] . "<br>";
echo "project: ". $decoded['selected_project'] . "<br>";
echo "Task: ". $decoded['tasks'][0]['task_name'] . "<br>";

foreach($decoded['tasks'][0]['work_hours'] as $key => $value) {
    foreach($value as $key2 => $value2){
        echo $key2 . ": ". $value2 . "<br>";
    }
}
?>

edited Jun 15, 2015 at 16:49

answered Jun 15, 2015 at 16:26

PHPhil

1,54013 silver badges27 bronze badges

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

1 Comment

WEshruth Over a year ago

Thank you so much @PHPhil, better one in such a small time span.

Collectives™ on Stack Overflow

Parse JSON on PHP and extract the particular value(s)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related