Please help on fetching database data to json

[neilfurry]

hello mate,

 

i need help on creating the json file with data are fetched from mysql database. here will be the result i want to get.

 

{
   "freebusys":[
      {
         "start":"2012-12-20T16:29:34.000+0000",
         "end":"2013-02-06T16:44:24.000+0000",
         "free":true
      }
   ],
   "events":[
      {
         "start":"2013-01-04T03:57:06.000+0000",
         "end":"2013-02-18T03:57:06.000+0000",
         "id":2,
         "title":"A lesson"
      },
      {
         "start":"2013-01-04T12:43:30.000+0000",
         "end":"2013-02-18T12:43:30.000+0000",
         "id":4,
         "title":"A lesson"
      }
   ]
}

 

i have a table named "schedules" on my database with the following fields, start, end, id, title, and free,  all i need is to do php array "freebusys" and "events" then their values will be fetched from my database. how can i do this.

 

please help.

 

Thank you

 

[requinix]

Given that sample JSON data, what would the table look like? Because I'm not sure that anyone here has any idea what the difference between "freebusys" and "events" is.

[neilfurry]

I already solved this mate. Thank you for your time :-)

 

Cheers!

 

Neil