Separate content from Response Content

Discuss
,
#21

Screenshot_20211004-092009
Screenshot_20211004-092009720×1512 49.8 KB

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

:point_up:

4 Likes
#22

The Do It is not working for me idk y :cold_sweat:

#23

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

#24

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

#25

:point_down:

#26

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

blocks
blocks949×1855 120 KB

and I always got this:
image
image1920×1080 232 KB

#27

Did you check your Json here ?
:point_down:

#28

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

#29

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"
      }
   ]
}
#30

This is not a valid json

2 Likes
#31

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

1 Like
#32

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

invalid
invalid1212×726 40.4 KB

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

4 Likes
#33

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.

#34

(post deleted)

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

#35

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

2 Likes
#36

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

#37

I got it, i got it…

#38

:point_down:

From search in GOOGLE …

1 Like
#39

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);
3 Likes
#40

omg you got it! :scream:

1 Like