MySQL - Add/Edit/Delete

Scheduler Javascript
#1

How can i add/edit/delete events with the help of this code?
I’ve tried to follow the guides, but it’s all so unclear for me.

I’m using MySQL as database.

[code]

Testing 
<link rel='stylesheet' type='text/css' href='codebase/dhtmlxscheduler.css'>
html, body{ margin:0px; padding:0px; height:100%; overflow:hidden; } .one_line{ white-space:nowrap; overflow:hidden; padding-top:5px; padding-left:5px; text-align:left !important; }
 
 
[/code]
#2

And apparently, my ‘Save’ button doesn’t work…

#3

Code which you are using creates autonomous scheduler, which doesn’t linked to the database.
Check samples\01_initialization_loading\05_loading_mysql.html

There code which you are missing is the next

[code] scheduler.load(“data/events.php”);

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

[/code]

first line load data from db, others enable data saving.
for quick start you can just alter db connection and table name in events.php
For more info how connector works, check
dhtmlx.com/docs/products/dhtmlxC … ndex.shtml

#4

Thank you Stanislav!

However this seems totaly messy to me anyways!

I successfully got the data from MySQL with the code below!

However - I can’t delete records, from MySQL with it, i can’t add new records (clicking save does nothing). And i can’t get the list from Database to work in ‘Timeline’-mode?

If someone can provide me with a working sample of it, i would be verry thankful!
It’s easier to understand how it works that way!

[code]

Testing 
<link rel='stylesheet' type='text/css' href='codebase/dhtmlxscheduler.css'>
html, body{ margin:0px; padding:0px; height:100%; overflow:hidden; } .one_line{ white-space:nowrap; overflow:hidden; padding-top:5px; padding-left:5px; text-align:left !important; }
 
 
[/code]
#5

Now i have noticed another problem, wich i find verry odd.

Even if i just copy over all the code from an example into like new.php, and then save it - i can’t add event.
But if i use the examplecode in it’s original file, it works… strange.

This script seems rather unstable?

#6

Nothing?

#7

a) Be sure that you have not whitespaces before <?php tag in your new file.
b) Be sure that paths to connector includes in the php files are still valid and you have all connectors file at that location

If someone can provide me with a working sample of it
Next two files includes all logic for scheduler-db data saving.
samples\01_initialization_loading\05_loading_mysql.html
samples\01_initialization_loading\data\events.php

#8

Ok, so i’ve pretty much have gotten it to work.
However, how can i populate it with database information?

Like replace the y-units with Database information.
And when i try to add a note inside the ‘timeline view’, it’s not saved.

Thank you for your help!

[code]

html, body{ margin:0px; padding:0px; height:100%; overflow:hidden; }
 
 
	</div>
	<div class="dhx_cal_header">
	</div>
	<div class="dhx_cal_data">
	</div>		
</div>
[/code]
#9

Hello,

Check viewtopic.php?f=6&t=24051 on your first question.
And for the second one please provide logs. Do you save event in scheduler and it is not being saved in database?

Kind regards,
Ilya

#10

Hello,
I am trying to test DHTMLXSchedular Application with MySQL Database.

Please let me know steps for the same.

Thanks in Advance.

Regards,
Grab.