Hi,
After successfully configuring dhtmlxscheduler in my local server…I want show the scheduler on the user basis…I am using custom php codes with MYSQl.
I have created table “event” which save all the event schedule details, it has the following fields:
id,event_start,event_end,event_text,user_id,appointment_type
Used the following js code :
scheduler.config.hour_date="%h:%i %A";
scheduler.config.xml_date="%Y-%m-%d %H:%i";
// Some common configurations
scheduler.config.first_hour = 6;
scheduler.config.last_hour = 24;
scheduler.config.start_on_monday = true;
scheduler.init('scheduler_here',null,"week");
scheduler.load("connector.php");
var dp = new dataProcessor("connector.php");
dp.init(scheduler);
</script>
& in the connector.php
require_once(“codebase/connector/scheduler_connector.php”);
global $scheduler;
$res=mysql_connect(“localhost”,“root”,"");
mysql_select_db(“docsinc”);
$conn = new SchedulerConnector($res);
$conn->enable_log(“temp.log”);
$conn->render_table(“event”,“id”,“event_start,event_end,event_text,user_id,appointment_type”);
Everything is pretty fine. Saves all the events in the database table & show all of them in one page…
Now what I want to do is, whenever a new event is adding/updateting the user_id
& appointment_type
field should also update…and render the specific events on the basis of user_id
& appointment_type
field.(Much Like… Select * from event
where user_id
=21 and appointment_type
=8)
Any help will appreciable. Thanks in advance.