Separate content from Response Content

[Rogerio_Rios (Professional Support)]

1-Your php return is right?
2- Click and DO IT on the blue block “list of pairs to …”

What do you get as a result?

3- Click on DO IT in the blocks below: Get Value for Key…

[Rogerio_Rios (Professional Support)]

Using a Json:
[{“plate_num”:“30”,“b_class”:“Class 3 Unit”,“b_dep”:“9:30”,“b_arriv”:“11:30”,“b_driv”:“Arnel Ignacio”},
{“plate_num”:“20”,“b_class”:“Class 5 Unit”,“b_dep”:“8:30”,“b_arriv”:“12:30”,“b_driv”:“Juan Pedro”}]
and Lookup Pairs Key Block

@Rogerio_Rios

2- Click and DO IT on the blue block “list of pairs to …”

What do you get as a result?

[Gelo_Reuben]

The Do It is not working for me idk y

[Rogerio_Rios (Professional Support)]

Connect to Companion…
Check your JSON return from your PHP :

JSON Formatter & Validator

Help with displaying data from mysql database please

Nobody knows what you did. There are 2 PHP Scripts ( here in community )ready to help beginners. You do not need an extension to access Mysql. OK ? In web got, you will have to use response Content (this is where you will have the data returned from your Script). You can use the response code to check the return code You can use the Json Decode text Block to handle Response Content. You can use dictionary blocks. You can use lookup pairs Key together with Json Decode text to get values by…

[Gelo_Reuben]

my companion always stops, I’m just using an emulator

[Rogerio_Rios (Professional Support)]

.JSON File Parsing - How I understood It

.JSON File - How I understood It What is Json? (Collected from W3Schools) -JSON stands for JavaScript Object Notation -JSON is a lightweight format for storing and transporting data -JSON is often used when data is sent from a server to a web page -JSON is "self-describing" and easy to understand My View: Now a days .JSON is a language which are mostly used in API services, data structures for storing and receiving as well as dor GeoCoding etc.GeoJson is a perfect…

[Gelo_Reuben]

I already adjusted that blocks awhile ago this is now my current blocks:

and I always got this:

[Rogerio_Rios (Professional Support)]

Did you check your Json here ?

JSON Formatter & Validator

[HritikR]

can you share your AIA? post it here or at least share your API endpoint

[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);