Advertisement
Guest User

Untitled

a guest
Jul 30th, 2015
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.99 KB | None | 0 0
  1. <script>
  2. $(document).ready(function() {
  3. $('body').on('click', '.save', function(e) {
  4. var string = $(this).serialize();
  5. $.ajax({
  6. type: "POST",
  7. url: "add_room.php",
  8. data: string,
  9. cache: false,
  10. success: function(data){
  11. $('#message').text('The id of the inserted information is ' + data);
  12. }
  13. });
  14. });
  15. });
  16. $(document).ready(function(){
  17. $('#addForm').on('click', function(){
  18. $('<label for="itemName[]">Item</label><input class="itemName" type="text" name="itemName[]"><label for="itemCondition">Condition</label><input class="itemCondition" type="text" name="itemCondition"><div class="save">Save Item</div>').fadeIn(500).appendTo('#mainForm');
  19. });
  20. });
  21. </script>
  22.  
  23. <?PHP
  24.  
  25. include('dbConfig.php');
  26.  
  27. $item = $db->real_escape_string($_POST['itemName']);
  28.  
  29. if ($stmt = $db->prepare("INSERT test (test_title) VALUES (?)"))
  30. {
  31. // Use an s per variable passed to the string, example - "ss", $firstname, $lastname
  32. $stmt->bind_param("s", $item);
  33. $stmt->execute();
  34. $stmt->close();
  35.  
  36. echo $db->insert_id;
  37. //echo "success";
  38. }
  39. // show an error if the query has an error
  40. else
  41. {
  42. echo "ERROR: Could not prepare SQL statement.";
  43. }
  44. ?>
  45.  
  46. var string = $(this).closest('form').serialize();
  47.  
  48. var string = $('#input1,#nextone,#somefield').serialize();
  49.  
  50. var string = $(this).serialize();
  51.  
  52. $_POST['itemName']
  53.  
  54. <form method="POST" class="save" action="add_room.php">
  55. <input type="text" name="itemName[]"/>
  56. <input type="text" name="itemName[]"/>
  57. <button type="submit">Save</button>
  58. </form>
  59.  
  60. $(document).on("submit",".save",function(e){
  61. e.preventDefault();
  62. $.post($(this).attr("action"),$(this).serialize(),function(r){
  63. //result
  64. alert(r);
  65. });
  66. });
  67.  
  68. $item = $_POST['itemName']
  69.  
  70. foreach( $item as $key => $val ) {
  71. //iterate itemName values
  72. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement