Advertisement
AllenEly

Untitled

Jan 25th, 2017
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.94 KB | None | 0 0
  1. <html lang="en">
  2. <head>
  3. <meta charset="utf-8">
  4. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  5. <meta name="viewport" content="width=device-width, initial-scale=1">
  6.  
  7. <title>Bootstrap</title>
  8. <link href = "css/bootstrap.min.css" rel="stylesheet">
  9. </head>
  10. <body>
  11. <p><br/></p>
  12. <div class="container">
  13. <p></p>
  14. <button class="btn btn-primary" data-toggle="modal" data-target="#addData">Insert Data</button>
  15.  
  16. <!-- Modal -->
  17. <div class="modal fade" id="addData" tabindex="-1" role="dialog" aria-labelledby="addLabel">
  18. <div class="modal-dialog" role="document">
  19. <div class="modal-content">
  20. <div class="modal-header">
  21. <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  22. <h4 class="modal-title" id="addLabel">Insert Data</h4>
  23. </div>
  24. <form>
  25. <div class="modal-body">
  26. <div class="form-group">
  27. <label for="nm">Full Name</label>
  28. <input type="text" class="form-control" id="nm" placeholder="Name">
  29. </div>
  30. <div class="form-group">
  31. <label for="em">Email</label>
  32. <input type="email" class="form-control" id="em" placeholder="Sure">
  33. </div>
  34. <div class="form-group">
  35. <label for="hp">Phone Number</label>
  36. <input type="number" class="form-control" id="hp" placeholder="Telp/HP">
  37. </div>
  38. <div class="form-group">
  39. <label for="al">Address</label>
  40. <textarea class="form-control" id="al" placeholder="Alamat"></textarea>
  41. </div>
  42. </div>
  43. <div class="modal-footer">
  44. <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
  45. <button type="submit" onclick="saveData()" class="btn btn-primary">Save changes</button>
  46. </div>
  47. </form>
  48. </div>
  49. </div>
  50. </div>
  51. <p></p>
  52. </div>
  53.  
  54.  
  55. <script src = "js/jquery-3.1.1.js"></script>
  56. <script src = "js/bootstrap.min.js"></script>
  57. <script>
  58. function saveData(){
  59. var name = $('#nm').val();
  60. var email = $('#em').val();
  61. var phone = $('#hp').val();
  62. var address = $('#al').val();
  63. $.ajax({
  64. type: "POST",
  65. url: "server.php?p=add",
  66. data: "nm="+name+"&em="+email+"&hp="+phone+"&al="+address,
  67. success: function(msg){
  68. alert('success');
  69. }
  70.  
  71. });
  72.  
  73. }
  74. </script>
  75. </body>
  76. <html>
  77.  
  78. <?php
  79. $servername = "localhost";
  80. $username = "root";
  81. $password = "";
  82. $db = new PDO("mysql:host=$servername;dbname=db_ajax", $username , $password);
  83. $page = isset($_GET[ 'p' ])?$_GET[ 'p' ]:'';
  84. if($page=='add'){
  85.  
  86. $name = $_POST['nm'];
  87. $email = $_POST['em'];
  88. $phone = $_POST['hp'];
  89. $address = $_POST['al'];
  90. $stmt = $db->prepare("insert into crud VALUES('',?,?,?,?)");
  91. $stmt->bindParam(1,$name);
  92. $stmt->bindParam(2,$email);
  93. $stmt->bindParam(3,$phone);
  94. $stmt->bindParam(4,$address);
  95. $stmt->execute()
  96.  
  97. } else if($page=='edit'){
  98.  
  99.  
  100.  
  101.  
  102. }else if($page=='del'){
  103.  
  104.  
  105.  
  106. } else{
  107.  
  108.  
  109.  
  110. }
  111.  
  112. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement