DHTMLx Scheduler link with DB Table

Discontinued products Uncategorized discussions
#1

I have a table below which I would link to link with the schduler but cant get it to work will



May comeone help



CREATE TABLE IF NOT EXISTS yearplanner (

ItemID mediumint(9) NOT NULL AUTO_INCREMENT,

UniqueID varchar(10) NOT NULL DEFAULT ‘0’,

Category int(10) unsigned NOT NULL DEFAULT ‘0’,

StartDate datetime NOT NULL,

EndDate datetime NOT NULL,

Title varchar(200) NOT NULL,

Description varchar(50) NOT NULL DEFAULT ‘’,

Compulsory tinyint(1) NOT NULL DEFAULT ‘1’,

TransactionDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (ItemID,UniqueID)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;





Thanks for the help.





#2

You can use events.php from default package, just change last line as

$scheduler->render_table(“yearplanner”,“ItemID”,“StartDate,EndDate,Title”);

#3


My question is how do you add additional input fields on the popup that adds a new event in order to correspond with additional fields in the database.


Thanks

#4

Two steps
a) include them in connector init line
$scheduler->render_table(“yearplanner”,“ItemID”,“StartDate,EndDate,Title,some”);
b) include them in client side form config
scheduler.config.lightbox.sections=[
{name:“description”, height:130, map_to:“text”, type:“textarea” , focus:true},
{name:“custom_name”, height:43, type:“textarea”, map_to:“some” },
{name:“time”, height:72, type:“time”, map_to:“auto”}
]

the document , attached to the next post, contains some advanced details
dhtmlx.com/docs/products/kb/inde … ler%20form

#5


Thanks guys for the answers.


My next question . How do filter certain events depending using a common key value for those events in the database table


??

#6

On server side, you can use render_sql instead of render_table

$scheduler->render_sql(“select * from yearplanner where Category = 1”,“ItemID”,“StartDate,EndDate,Title”);