Advertisement
Guest User

Simplest jQuery, PHP, AJAX, and sqlite example

a guest
Feb 20th, 2012
712
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. <ul>
  2. <li>hello</li>
  3. <li id="formItem">
  4. <form action="" method="post">
  5. <input type=text name="content"/>
  6. </form>
  7. </li>
  8. <li>world</li>
  9. </ul>
  10.  
  11. $("form").submit(function() {
  12. var inputText = $("input").val();
  13. $.ajax({
  14. type: "POST",
  15. url: "add.php",
  16. data: inputText,
  17. success: function() {
  18. $('#formItem').prev().after(
  19. "<li>" + inputText + "</li>"
  20. )}
  21. });
  22. });
  23.  
  24. <?php
  25. $base = new PDO('sqlite:todo.db');
  26. $sql = $base->prepare("INSERT INTO ThisTable (content, priority) VALUES ('lolololol', 1);");
  27. $sql->execute();
  28. $base = null;
  29. ?>
  30.  
  31. $('#yourForm').bind('submit', function (event) {
  32. jQuery.get('/ajax/interact.php', 'a=1&b=2', function (response) {
  33. alert("AJAX request succeeded, response from the server was: " + response);
  34. });
  35.  
  36. event.preventDefault();
  37. });
  38.  
  39. $('form.ajax').live('submit', function (event) {
  40. var self = $(this);
  41.  
  42. jQuery[(self.attr('method') || 'get').toLowerCase()](self.attr('action'), self.serialize(), function (response) {
  43. alert("AJAX request succeeded, response from the server was: " + response);
  44. });
  45.  
  46. event.preventDefault();
  47. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement