Timeline sample how to integrate with mysql

Scheduler Javascript
#1

Hi,

You have been probably asked before but how does the timeline sample 02_lines.html connect to a mysql database, is there a database creation file somewhere on how to set the tables up and then how to connect the sample? I need the data to be saved in a database rather than just static data…

Thanks in advance

#2

Same as for normal scheduler

dhtmlxScheduler\samples\01_initialization_loading\05_loading_mysql.html

scheduler.load("php/events.php");
		
var dp = new dataProcessor("php/events.php");
dp.init(scheduler);

and in events.php

[code]

<?php include ('../../../codebase/connector/scheduler_connector.php'); include ('../../common/config.php'); $res=mysql_connect($server, $user, $pass); mysql_select_db($db_name); $scheduler = new schedulerConnector($res); //$scheduler->enable_log("log.txt",true); $scheduler->render_table("events","event_id","start_date,end_date,event_name,user_id"); ?>[/code]

where user_id holds id for timeline section