pshoeg
-
Posts
9 -
Joined
-
Last visited
Never
pshoeg's Achievements
Newbie (1/5)
0
Reputation
-
This works perfectly! Thank you so much!
-
So, this is what I got (not working): The saveToDb.php file: <?php $con = mysql_connect("localhost","root","root"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("test", $con); $sql="INSERT INTO Content (main) VALUES ('$_POST[content]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record added"; mysql_close($con) ?> The script that you provided me with: <script> var content = $('#editable').html(); $.ajax({ url: 'saveToDb.php', type: 'POST', data: { content: content } }); </script> The div and the button: <div id="editable" contentEditable="true">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</div> <input type="button" value="Save" name="save" onclick="$.ajax"> When I click the button, it sends 'null' to the table. What am I doing wrong?
-
I'm back All right, so how do I send the content? Do I create an input button inside a form element (I guess I'm not, as the jQuery script already tells the URL of the PHP file and that it should POST)? Can I use a regular link to send it off? And should the PHP file contain anything else that the database connection stuff and the code for putting the content in the tables?
-
Thanks, I'll get back to you if I can't make it work... Cheers!
-
All right, I'll try to explain it in more detail: I am going to use localStorage along with HTML5's new contentEditable feature to create a website that is editable directly from the browser. The localStorage should save what is written in a div with contentEditable=true on the client's computer. This is working: <!DOCTYPE html> <html> <head> <title>LocalStorage</title> <script> var addEvent = (function () { if (document.addEventListener) { return function (el, type, fn) { if (el && el.nodeName || el === window) { el.addEventListener(type, fn, false); } else if (el && el.length) { for (var i = 0; i < el.length; i++) { addEvent(el[i], type, fn); } } }; } else { return function (el, type, fn) { if (el && el.nodeName || el === window) { el.attachEvent('on' + type, function () { return fn.call(el, window.event); }); } else if (el && el.length) { for (var i = 0; i < el.length; i++) { addEvent(el[i], type, fn); } } }; } })(); </script> </head> <body> <div id="editable" contentEditable="true">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</div> <script> var editable = document.getElementById('editable'); addEvent(editable, 'blur', function () { // lame that we're hooking the blur event localStorage.setItem('contenteditable', this.innerHTML); document.designMode = 'off'; }); addEvent(editable, 'focus', function () { document.designMode = 'on'; }); addEvent(document.getElementById('clear'), 'click', function () { localStorage.clear(); window.location = window.location; // refresh }); if (localStorage.getItem('contenteditable')) { editable.innerHTML = localStorage.getItem('contenteditable'); } </script> </body> </html> However, I'd like that when the client hits a 'Save' button or something, all the stuff from the localStorage gets sent to a table in a MySQL database. How would you do that?
-
No, I want the opposite - I want to take the data from my div tags and put it in a database.
-
So I wouldn't be able to just say that the text in a table in the database should be equal to the text in the div?
-
I want to use it along with HTML5's new contentEditable feature - so I wouldn't be entering it into the div before I'm in the browser.
-
Hi there, Say I have this code: <div id="name>Lorem ipsum dolor sit amet.</div> I want to take the text inside the div and put it into a table in a database, in the same manner you would post content from a form to a database. Is that possible? And the follow-up question to that: How is it possible?