search envelope-o feed check
Home Unanswered Active Tags New Question
user comment-o

How can I fetch value of new column from database and display it on the calendar?

Related article: HTML5/JavaScript Calendar with Day/Week/Month Views (PHP, MySQL)
Asked by Quy
11 months ago.

I've just created a new column named "staff" to "event" table from sample "day-week-month" database.
In the backend_events.php, I add this:
foreach($result as $row) {
$e = new Event();
$e->id = $row['id'];
$e->text = $row['name'];
$e->start = $row['start'];
$e->end = $row['end'];
$e->staff = $row['staff'];
$events[] = $e;
but How can I make it display on the front-end view of the calendar? like this:

Answer posted by Dan Letecky [DayPilot]
11 months ago.

You can use onBeforeEventRender event handler to modify the event HTML ( using the staff column (

You can also modify the $e->text value on the server side (in your snippet above).

Comment posted by Quy
11 months ago.

Thanks but I am using trial version, can I make use of that modification and other functions written in the doc?

This question is more than 3 months old and has been closed. Please create a new question if you have anything to add.