asked on
Mootools Javascript Autosave Form
Hi,
I tried to get this class to work with no success:
https://github.com/arieh/Autosave
Need help please. I get a javascript object error in (demo.html) line 15
The local storage seems to work but not the database storage.
I tried to get this class to work with no success:
https://github.com/arieh/Autosave
Need help please. I get a javascript object error in (demo.html) line 15
The local storage seems to work but not the database storage.
AJAXJavaScript
Last Comment
leakim971
ASKER
Yes, the Source folder is at the same level. I uploaded all the files/folder as is on the server and create the “data” database using the sql file.
Is the “demo.html” working and saving to the database on your machine? (without a javascript error in debugging mode)
Thanks :)
autosave.gif
Is the “demo.html” working and saving to the database on your machine? (without a javascript error in debugging mode)
Thanks :)
autosave.gif
Once I put the Source at the same level as the Demo folder the error line 15 left
You still get it?
For any others errors, did you create the table in a database and update the database login info in save.php?
You still get it?
For any others errors, did you create the table in a database and update the database login info in save.php?
ASKER
Yes. same error (see image)
and the database connection is (save.php):
$pdo = new PDO('mysql:host=localhost;
autosave2.gif
and the database connection is (save.php):
$pdo = new PDO('mysql:host=localhost;
autosave2.gif
You did not include Autosave.Request.js
ASKER
Thanks for your patience
I added the line :
<script type="text/javascript" src="../Source/Autosave.Re
So here is my demo.html source:
<!DOCTYPE HTML>
<html lang="en-US">
<head>
<meta charset="UTF-8">
<title>Autosave Demo</title>
</head>
<body>
<h1>Autosave Demo</h1>
<p>Enter some value into the textbox. That value will be autosaved every 5 seconds if changed. Even if you leave the page and open it again, The last data used will be saved.</p>
<textarea name="exp1" id="exp1" cols="30" rows="10"></textarea>
<a href="javascript:;" id='empty'>empty records</a>
<script type='text/javascript' src='http://ajax.googleapis.com/ajax/libs/mootools/1.2.4/mootools-yui-compressed.js'></script>
<script type="text/javascript" src="../Source/Autosave.js
<script type="text/javascript" src="../Source/Autosave.Re
<script type="text/javascript">
var as = new Autosave.Request('exp1','s
as.attach();
$('empty').addEvent('click
</script>
</body>
</html>
Code for the save.php:
<?php
$pdo = new PDO('mysql:host=localhost;
$pdo->setAttribute(PDO::AT
$pdo->query("SET NAMES 'utf8'");
$value = $pdo->quote($_POST['value'
$step = $pdo->quote($_POST['step']
$id = $pdo->quote($_POST['id']);
$pdo->query("INSERT INTO `data`(`id`,`step`,`value`
Still have javascript error and do not save to table
autosave3.gif
I added the line :
<script type="text/javascript" src="../Source/Autosave.Re
So here is my demo.html source:
<!DOCTYPE HTML>
<html lang="en-US">
<head>
<meta charset="UTF-8">
<title>Autosave Demo</title>
</head>
<body>
<h1>Autosave Demo</h1>
<p>Enter some value into the textbox. That value will be autosaved every 5 seconds if changed. Even if you leave the page and open it again, The last data used will be saved.</p>
<textarea name="exp1" id="exp1" cols="30" rows="10"></textarea>
<a href="javascript:;" id='empty'>empty records</a>
<script type='text/javascript' src='http://ajax.googleapis.com/ajax/libs/mootools/1.2.4/mootools-yui-compressed.js'></script>
<script type="text/javascript" src="../Source/Autosave.js
<script type="text/javascript" src="../Source/Autosave.Re
<script type="text/javascript">
var as = new Autosave.Request('exp1','s
as.attach();
$('empty').addEvent('click
</script>
</body>
</html>
Code for the save.php:
<?php
$pdo = new PDO('mysql:host=localhost;
$pdo->setAttribute(PDO::AT
$pdo->query("SET NAMES 'utf8'");
$value = $pdo->quote($_POST['value'
$step = $pdo->quote($_POST['step']
$id = $pdo->quote($_POST['id']);
$pdo->query("INSERT INTO `data`(`id`,`step`,`value`
Still have javascript error and do not save to table
autosave3.gif
update database login infos in save.php, empty.php and get.php
ASKER
Yes, I have already done that.
This maybe a silly question to ask but…
In the save.php file, where do the:
$value = $pdo->quote($_POST['value'
$step = $pdo->quote($_POST['step']
$id = $pdo->quote($_POST['id']);
POSTS come from?
There is only one textarea in the demo.html form ie:
<textarea name="exp1" id="exp1" cols="30" rows="10"></textarea>
And the name is exp1.
This maybe a silly question to ask but…
In the save.php file, where do the:
$value = $pdo->quote($_POST['value'
$step = $pdo->quote($_POST['step']
$id = $pdo->quote($_POST['id']);
POSTS come from?
There is only one textarea in the demo.html form ie:
<textarea name="exp1" id="exp1" cols="30" rows="10"></textarea>
And the name is exp1.
Did you create the table (run table.sql) ?
It run fine on my side.
>POSTS come from?
ajax call (Request.JSON) in the plugin
It run fine on my side.
>POSTS come from?
ajax call (Request.JSON) in the plugin
ASKER
You mean the data.sql ? Yes. I created the table using
DROP TABLE IF EXISTS `data`;
CREATE TABLE `data` (
`id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`step` int(11) NOT NULL DEFAULT '0',
`value` text COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`,`step`),
FULLTEXT KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Did you include other files to make it run or just the ones included in the Autosave package? ie: Demo and Source folders.
Thanks again. First time I play with Mootools :(
DROP TABLE IF EXISTS `data`;
CREATE TABLE `data` (
`id` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`step` int(11) NOT NULL DEFAULT '0',
`value` text COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`,`step`),
FULLTEXT KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Did you include other files to make it run or just the ones included in the Autosave package? ie: Demo and Source folders.
Thanks again. First time I play with Mootools :(
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Ok. I got the script to work on another server. I think, it was the mysql or PHP version that was the issue.
Thanks anyway :)
Thanks anyway :)
You're welcome! Thanks for the points! Have a nice week-end!
OR if you put the Source folder inside the Demo folder modify line 13 & 14 like this :
Open in new window