Array becoming complicated

PHP
1

I am trying to make an events calendar based on this tutorial.
The calendar depicts events by accepting JSON(an array of objects where each object contains data related event) by the server.
Here is an example:

{id:3, title:kostas, staff_ID:5, start:2014-04-09 04:30:00, end:2014-04-09 06:00:00, color:#0072C6,…}

The above is what I see in the network tab of dev tools.

Here is the result of the above:http://1drv.ms/1if2oZ5

I have a problem though:
All the above data are taken from a single table row…there is some data though that exist in another table and it MAY be comprised of more that one row
It is a table which list services chosen by user and as you might guess an event might be associated with more than service(meaning more than one row).

How could I incorporate the services in the above JSON?
Should I add another member where it will be an array containing the services?

2

How does the data about the services relate to the calendar events?

3

yes,I must clarify that.The events calendar is actually a calendar where appointments are stored…and an appointment(in a hair salon for example) might be associated with more than one service-as is often the case.

Does it make sense now?

4

You could nest them within the appointment object:

{
    id:3,
    title: 'kostas',
    staff_ID:5,
    start:2014-04-09 04:30:00,
    end:2014-04-09 06:00:00,
    services: [
        {
            id:6,
            name: 'cut'
        },
        {
            id:8,
            name: 'perm'
        }
    ]
}

If you don’t need to display them unless the user clicks the appointment for more information (for example), then you could return the information about the services in a separate request, from a separate end-point of your API, to keep things cleaner.

5

You guessed right I want to display the services on clicking the appointment which might lead me adopt your advise-making a separate request for that.