sheduler is not loading data from server(mysql)

hi,

Is I can display two different table data in one calender.

Please anyone reply me.

else
$conn->render_table(“ge_appointments”,“id”,“appt_date,appt_date,firstname,inhomes”);

Even If I have changed to above format, It is not updating . Please help me.

Here is my code.

<?php require_once("../codebase1/connector/scheduler_connector.php"); $res=mysql_connect("localhost","root","pw"); mysql_select_db("db"); $conn = new SchedulerConnector($res); if ($conn->is_select_mode())//code for loading data $conn->render_sql("select * from ge_roster where username='$username'","id","start_date,end_date,emp_sub"); else //code for other operations - i.e. update/insert/delete $conn->render_table("ge_roster","id","start_date,end_date,emp_sub");

Sir, Please anyone reply me. It will be great help

Sir,

Is I can use scheduler from 1 table and timeline from another table.

Both are two different table

You can load data from multiple server side scripts
docs.dhtmlx.com/scheduler/extens … ultisource

You can load data from two scripts and use client side filtering to show one set of data in scheduler view and other in the timeline view.

Please try to enable log and provide log’s content

$conn = new SchedulerConnector($res); $conn->enable_log("some.txt"); //post here content of some.txt

Where I can display some.txt file

Here is my code. Please help me

<?php require_once("../codebase/connector/scheduler_connector.php"); $res=mysql_connect("localhost","root","het&hd"); mysql_select_db("db_data"); $conn = new SchedulerConnector($res); $conn->enable_log("some.txt"); if ($conn->is_select_mode())//code for loading data $conn->render_sql("select * from ge_appointments where appt_setter_dispo='Appointment'","id","appt_date,appt_date,firstname,quality_comment"); else //code for other operations - i.e. update/insert/delete $conn->render_table("ge_appointments","id","appt_date,appt_date,firstname,inhomes");

Please post content of log file here ( or send it by PM )

Sir,

I dont know what has to be there in the log file.

Can you please help so that I can provide the log content

If you have added the next line

$conn->enable_log(“some.txt”);

then, each time as you load or save data, connector will record details about operations in the some.txt ( folder will be located in the same folder where php file located )

  • check that folder has write access
  • refresh page, try to load and save data
  • check the content of some.txt and post it here

Please find the content of some.txt file.

Thank you so much for your patience.

====================================
Log started, 19/11/2014 06:28:41

SELECT * FROM ge_appointments WHERE ( appt_setter_dispo=‘Appointment’)

Done in 0.0062081813812256s

sir , Please help me.

On client side you have something like

scheduler.load("data/connector.php");

on server side the connectors code.

If all goes fine, after page loading, scheduler will request connector.php file, which must output appointments data in XML format

Ok I git. Now how can I do it sir.

Sir,

Is I can display two text field value in scheduler.

Like 2:00 Name - City.

Please help me how can I do it.

Yep, you can use templates to define the visible text
Check

docs.dhtmlx.com/scheduler/custom … ntent.html

Sir,
Thank you for your help. It is coming in week & Day View, not in Month View.
For me month is very important.

Try settingevent_bar_text template, it defines the event content in Month and Timeline views
docs.dhtmlx.com/scheduler/api__s … plate.html

Hi Sir,

It is still not working.

Here is my piece of code

scheduler.attachEvent(“onTemplatesReady”, function(){
scheduler.templates.event_text=function(start,end,event){
return “” + event.text + “
” + event.suburb + “”;
}
});

Please help me to get in month view.