Split comma separated values into multiple rows

Hi ,
I had location field in scheduler,
in that i’,m entering Chennai, US, UK, UAE.
I want it to be save in separate rows in db.
How to fix it.

Hello,

Do I undestand correctly, that you sending to the backend event like following:

id: 1235
start_date: “2016-10-01 00:00”
start_date: “2016-10-02 00:00”
location: “Chennai, US, UK, UAE”

and you want it do be saved to the database as four different event entries, like this:

[code]id: 1
start_date: “2016-10-01 00:00”
start_date: “2016-10-02 00:00”
location: “Chennai”

id: 2
start_date: “2016-10-01 00:00”
start_date: “2016-10-02 00:00”
location: “US”

id: 3
start_date: “2016-10-01 00:00”
start_date: “2016-10-02 00:00”
location: “UK”

id: 4
start_date: “2016-10-01 00:00”
start_date: “2016-10-02 00:00”
location: “UAE”[/code]

If so, there won’t be a built-in solution or method in dhtmlxConnector. What you’ll probably need to do is to detect a request that adds a new event (you’ll need to check the request values), and for such request insert data into the db manually instead of initializing dhtmlxConnector