PHP-sandbox to read sql table, enquiry external API and then update back to sql table

[sam8881998]

I have an application to read the enquiry external API Json by reading SQL table, and then decode the result in Json file and store it back to SQL table:

Settings:

1. There is an API to show the cntr size of cntr, for example http://123/:cntr
   It will return the json file
2. I have mysql script to list all the cntr where is equal year 2024
   select cntr from tableA where year = 2024;
3. get the list of cntr and call the Schedule API to get the cntr size of each cntr.
   json file will be like:

[
"detail": {"cntr":"1234",
"size":"10"},
"detail": {"cntr":"4343",
"size":"20"},
"detail": {"cntr":"1353",
"size":"30"}
]

Logic:

1. Run the script to scan table A.
2. Get the above json file and then update it back to the table B

update the size and detail where cntr = cntr from json file.

Can I use one or more PHP-sandbox to complete the task?

Please help.

Thanks and Best Regards,

Samuel