How to loop through an Json object with array in PHP

Question

I get the following data in JSON format.

{"Students":
[{"ID":"600","datetime":"26-11-2019 04-32-31","age":"12"},
{"ID":"601","datetime":"26-11-2019 04-32-31","age":"13"},
{"ID":"602","datetime":"26-11-2019 04-32-31","age":"12"},
{"ID":"603","datetime":"26-11-2019 04-32-31","age":"14"}
]}

I want to write a PHP script to insert this data in MYSQL.

I'm not sure how to write the Loop to go through this data.

I tried the following code, and it does not work.

//encode the Json request.
$obj = json_decode($content);

foreach($obj as $key){
 // $email = $decode['RouteID'];

}

Can you dump $key

executable
– executable

2019-11-28 13:16:15 +00:00
Commented Nov 28, 2019 at 13:16 — executable
– executable, Commented Nov 28, 2019 at 13:16

Akam · Accepted Answer · 2019-11-28 13:19:02Z

$json = '{"Students":
[{"ID":"600","datetime":"26-11-2019 04-32-31","age":"12"},
{"ID":"601","datetime":"26-11-2019 04-32-31","age":"13"},
{"ID":"602","datetime":"26-11-2019 04-32-31","age":"12"},
{"ID":"603","datetime":"26-11-2019 04-32-31","age":"14"}
]}';
//convert json to array
$array = json_decode($json, true);

//loop
foreach($array['Students'] as $key => $val){
 echo "$key = $val \n"; 
}

//or print whole array
print_r($array);

The result of print_r will be like this:

(
    [Students] => Array
        (
            [0] => Array
                (
                    [ID] => 600
                    [datetime] => 26-11-2019 04-32-31
                    [age] => 12
                )

            [1] => Array
                (
                    [ID] => 601
                    [datetime] => 26-11-2019 04-32-31
                    [age] => 13
                )

            [2] => Array
                (
                    [ID] => 602
                    [datetime] => 26-11-2019 04-32-31
                    [age] => 12
                )

            [3] => Array
                (
                    [ID] => 603
                    [datetime] => 26-11-2019 04-32-31
                    [age] => 14
                )

        )

)

jagad89 · Accepted Answer · 2019-11-28 13:21:34Z

// creating connection to mysql
$servername = "localhost";
$username = "username";
$password = "password";

try {
    $conn = new PDO("mysql:host=$servername;dbname=DatbaseName", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connected successfully";
    }
catch(PDOException $e)
    {
    echo "Connection failed: " . $e->getMessage();
    }

$content = '{"Students":
[{"ID":"600","datetime":"26-11-2019 04-32-31","age":"12"},
{"ID":"601","datetime":"26-11-2019 04-32-31","age":"13"},
{"ID":"602","datetime":"26-11-2019 04-32-31","age":"12"},
{"ID":"603","datetime":"26-11-2019 04-32-31","age":"14"}
]}';
$data= json_decode($content);

foreach($data->Students as $student){

$sql = "INSERT INTO users (ID, datetime, age) VALUES (?,?,?)";
$conn->prepare($sql)->execute([$student->ID, $student->datetime, $student->age]);

}

Enrico Cortinovis · Accepted Answer · 2019-11-28 13:17:14Z

0

To loop through the object and get its members you can try this:

foreach($json as $obj){
   echo $obj->name;
   .....

}

Using $key won't work!

answered Nov 28, 2019 at 13:17

Enrico Cortinovis

8913 gold badges11 silver badges35 bronze badges

Comments

Ripa Saha · Accepted Answer · 2019-11-28 13:46:41Z

0

Below is the simple working example code:-

<?php
$jsonData = '{"Students": [{"ID":"600","datetime":"26-11-2019 04-32-31","age":"12"},{"ID":"601","datetime":"26-11-2019 04-32-31","age":"13"},{"ID":"602","datetime":"26-11-2019 04-32-31","age":"12"},{"ID":"603","datetime":"26-11-2019 04-32-31","age":"14"}]}';

$JD = json_decode($jsonData);

 // print_r($JD);

   foreach ($JD->Students as $key => $value) {
    echo $value->ID . ", " . $value->datetime . ", " . $value->age . "<br>";
    //print_r($value);
}



 ?>

answered Nov 28, 2019 at 13:46

Ripa Saha

2,5406 gold badges29 silver badges54 bronze badges

Comments

zemrin · Accepted Answer · 2019-11-29 12:23:09Z

0

$data = '{"Students":
[{"ID":"600","datetime":"26-11-2019 04-32-31","age":"12"},
{"ID":"601","datetime":"26-11-2019 04-32-31","age":"13"},
{"ID":"602","datetime":"26-11-2019 04-32-31","age":"12"},
{"ID":"603","datetime":"26-11-2019 04-32-31","age":"14"}
]}';

$r = json_decode($data);


foreach($r->Students as $key => $value)
{
  //inser query
  $q = 'INSERT INTO <table_name>('ID','datetime','age') VALUES($value->ID,$value->datetime,$value->age);

}

answered Nov 29, 2019 at 12:23

zemrin

273 bronze badges

Comments

BCM · Accepted Answer · 2019-11-29 12:44:44Z

You can convert your JSON data to object or array.
Use php json_decode function to do it.

Convert to object

$data = '{"Students":
[{"ID":"600","datetime":"26-11-2019 04-32-31","age":"12"},
{"ID":"601","datetime":"26-11-2019 04-32-31","age":"13"},
{"ID":"602","datetime":"26-11-2019 04-32-31","age":"12"},
{"ID":"603","datetime":"26-11-2019 04-32-31","age":"14"}
]}';

$obj = json_decode($data);

foreach ($obj->Students as $key => $value) {
  echo $value->age;    
}

If you want convert JSON data to array put second argument (true) to json_decode. function

$data = '{"Students":
    [{"ID":"600","datetime":"26-11-2019 04-32-31","age":"12"},
    {"ID":"601","datetime":"26-11-2019 04-32-31","age":"13"},
    {"ID":"602","datetime":"26-11-2019 04-32-31","age":"12"},
    {"ID":"603","datetime":"26-11-2019 04-32-31","age":"14"}
    ]}';

    $array = json_decode($data, true);

    foreach ($array['Students'] as $key) {
      echo $key['age'];    
    }

Collectives™ on Stack Overflow

How to loop through an Json object with array in PHP

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related