Separate content from Response Content

[Gelo_Reuben]

Yes and this is the result:

{
   "bus":[
      {
         "Bus_Plate_Number":"30",
         "Bus_Class":"Class 3 Unit",
         "Bus_Branch":"Calbayog",
         "Bus_Route":"Allen",
         "Bus_Dep_Time":"9:30 AM",
         "Bus_Arriv_Time":"11:30 AM",
         "Bus_Driver":"Arnel Ignacio",
         "Bus_Contact":"09123456789",
         "Bus_DateAdded":"2021-08-07"
      }
   ]
}{
   "bus":[
      {
         "Bus_Plate_Number":"30",
         "Bus_Class":"Class 3 Unit",
         "Bus_Branch":"Calbayog",
         "Bus_Route":"Allen",
         "Bus_Dep_Time":"9:30 AM",
         "Bus_Arriv_Time":"11:30 AM",
         "Bus_Driver":"Arnel Ignacio",
         "Bus_Contact":"09123456789",
         "Bus_DateAdded":"2021-08-07"
      },
      {
         "Bus_Plate_Number":"35",
         "Bus_Class":"Class 3 Unit",
         "Bus_Branch":"Calbayog",
         "Bus_Route":"Allen",
         "Bus_Dep_Time":"9:30 AM",
         "Bus_Arriv_Time":"11:30 AM",
         "Bus_Driver":"Efren Catalan",
         "Bus_Contact":"09123456789",
         "Bus_DateAdded":"2021-08-07"
      }
   ]
}

[dora_paz (Dora)]

This is not a valid json

[HritikR]

you need to make some changes in your php code for generating valid json.

[Rogerio_Rios (Professional Support)]

@HritikR

you need to make some changes in your php code for generating valid json.

@dora_paz

This is not a valid json

I already warned you about this…
I’ve already shown you the topic about JSON…
Showed the link to test JSON…

But it seems that the users here on the forum want to solve it in a few minutes…

[Gelo_Reuben]

Sorry, the app that I’m generating right now is part of my thesis that’s why I’m really eager to solve the problem quickly. I’m currently adjusting the php file right now. This JSON is really new to me that’s why I always got this error since last week.

[Still-learning (1-2-3-4...)]

(post deleted)

Already Rogerio shared a site . Please make use of it and correct your json

[Rogerio_Rios (Professional Support)]

@Still-learning

Try this site to correct your

What he needs is to adjust the php script that generates the JSON.

[Gelo_Reuben]

I already knew what’s the valid json. The only problem is how I will correct it through php. This is my code:

$conn = new mysqli($host,$username,$password,$dbname);
$data = mysqli_query($conn, "SELECT * FROM bus WHERE Bus_Dep_Time='9:30 AM' AND Bus_Branch='Calbayog'");
$array = array();
while ($result=mysqli_fetch_assoc($data))
{
    $array['bus'][]=$result;
    echo json_encode($array);
}

I keep adjusting the $array[‘bus’]=$result; but I always got the wrong json

[Still-learning (1-2-3-4...)]

@Rogerio_Rios

adjust the php script

I got it, i got it…

[Rogerio_Rios (Professional Support)]

From search in GOOGLE …

How to convert mysqli result to JSON?

[HritikR]

It made some change. try it

$conn = new mysqli($host,$username,$password,$dbname);
$data = mysqli_query($conn, "SELECT * FROM bus WHERE Bus_Dep_Time='9:30 AM' AND Bus_Branch='Calbayog'");
$array = array();
while ($result=mysqli_fetch_assoc($data))
{
    $array[]['bus'][]=$result;
}
echo json_encode($array);

[Gelo_Reuben]

omg you got it!

[Rogerio_Rios (Professional Support)]

https://www.w3schools.com/PHP/php_looping_while.asp

[Gelo_Reuben]

I’m still adjusting my blocks, I can’t still separate the 2 records.

[Gelo_Reuben]

I have this error:

[Gelo_Reuben]

I got that error from these blocks I guess:

[Gelo_Reuben]

Hello, I finally separated the 2 records from response content, the only problem is that it only produces 1 record not 2. This is the result:

then this are my current blocks:

[Gelo_Reuben]

can you please check it and tell me what’s wrong?

[HritikR]

Share your AIA @Gelo_Reuben