Retrieving Data from mysql database

Scheduler Javascript
#1

Hello,
I’ve searched this form and tried to fix the problem for over a week with no success. any help would be appreciated…
my html is as followed:

		scheduler.init('scheduler_here',new Date(),"week");
		scheduler.setLoadMode("month")
		scheduler.load("./data/events.php");
		var dp = new dataProcessor("./data/events.php");
		dp.init(scheduler);

with the correct path to events.php.

events.php is as followed:

[code]<?php
include (’…/…/common/connector/scheduler_connector.php’);

$res=mysql_connect(“localhost”,“root”,“my_password”);
mysql_select_db(“my_database_name”);

$calendar = new SchedulerConnector($res);
$calendar->render_table(“events”,“id”,“start_date,end_date,text”);
?>
[/code]
table name is events with the following structure:

id int(11) NOT NULL AUTO_INCREMENT,
start_date datetime NOT NULL,
end_date datetime NOT NULL,
text varchar(255) NOT NULL,
PRIMARY KEY (id)

checked the path to: scheduler_connector.php and it’s fine.
running events.php in browser I get the xml file with all the data from dump.sql, but none of the events are displayed in the calendar. Furthermore I can’t add any events and any event which is added disappear upon refresh.

thanks in advance…

#2

another addition which might be relevant is that I"m trying to get the calendar to work on xampp platform on my local computer.

#3

Hello,
Try setting default format for dates in the ajax data. Maybe it’s not displayed because dates aren’t parsed correctly: scheduler.config.xml_date="%Y-%m-%d %H:%i";
You can also check /samples/01_initialization_loading/05_loading_database.html example from the scheduler package