How to fetch recurring and single post from database,

Scheduler Javascript
#1

I am using scheduler with php and mysql.

Using scheduler eveything is working fine. I have post that are just for the day and different reccurent post. No event last for more then one day.
I want to make a single list with all events in php for a specific date.

My question is:
How to fetch the recurrent post?

With this code I can fetch events for single day.

SELECT * FROM scheduler WHERE DATE(start_date) = DATE(NOW())

Scheduler table looks like this in mysql:
event_id, start_date, end_date, text, rec_type, event_pid, event_length, section_id, subject

Example post looks like this:
3652, 2015-11-18 06:55:00, 2015-11-18 07:00:00, Task A, [empty] 0, 0, 6, start
3628, 2015-11-16 14:30:00, 9999-02-01 00:00:00, Task B, week_2___3#no, 0, 2700, 1 , [empty]
3650, 2015-11-18 07:30:00, 2015-11-18 07:45:00, Task Z, [empty], 2453, 1447828200, 3, science

#2

Hello,
you’ll need to parse recurring format in order to get list of individual occurrences.
There is ready tool for this for php backend github.com/DHTMLX/scheduler-helper-php

#3

Thank you! I will take a look!