Timeline sample how to integrate with mysql


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

Same as for normal scheduler


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

and in events.php


<?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