Guest User

Untitled

a guest
Dec 14th, 2017
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.09 KB | None | 0 0
  1. <html>
  2. <body>
  3. <div>
  4. <form style="display:inline_block" action="insert_data.php" method="post">
  5. FirstName: <input type="text" name="FirstName"><br>
  6. LastName: <input type="text" name="LastName"><br>
  7. E-mail: <input type="text" name="email"><br>
  8. <input type="submit" value="Insert">
  9. </form>
  10. <form style="display:inline_block" action="show_data.php">
  11. <input type="submit" value="Show Database">
  12. </form>
  13.  
  14. <form style="display:inline_block" action="delete_form.html">
  15. <input type="submit" value="Delete Data">
  16. </form>
  17.  
  18. </div>
  19. </body>
  20. </html>
  21.  
  22. <html>
  23. <body>
  24. <?php
  25. include('connect_db.php');
  26.  
  27. //function insert(){
  28. $firstname = $_POST["FirstName"];
  29. $lastname = $_POST["LastName"];
  30. $email = $_POST["email"];
  31.  
  32. echo $firstname . '<br/>' . $lastname . '<br/>' . $email . '<br/>';
  33.  
  34. $sql_insert = "INSERT INTO Pacient(firstname,lastname,email)
  35. VALUES ('$firstname', '$lastname','$email')";
  36.  
  37.  
  38. if( mysqli_query($conn, $sql_insert))
  39. echo "New record created successfullly";
  40. else
  41. die("Failed inserting data: " . mysqli_error($conn));
  42. //}
  43. //insert();
  44. ?>
  45. <form action="form.php">
  46. <input type="submit" name="Home" value="Home">
  47. </form>
  48. </body>
  49. </html>
  50.  
  51. <html>
  52. <body>
  53. <?php
  54. $servername = "localhost";
  55. $username = "user";
  56. $password = "password";
  57. $dbname = "Data_Base_Name";
  58.  
  59. //Create connection
  60. $conn = new mysqli($servername, $username, $password, $dbname);
  61.  
  62. //Check connection
  63. if (!$conn)
  64. die("Connection failed: " . mysqli_error($conn) . '<br/>');
  65. else
  66. echo "Connected successfully" . '<br/>';
  67.  
  68. if(mysqli_query("USE $dbname" ) )
  69. die("Failed selecting database: " . mysqli_error($conn) . '<br/>');
  70. else
  71. echo "Selected with success" . '<br/>';
  72. ?>
  73. </body>
  74. </html>
  75.  
  76. if( mysqli_query($conn, $sql_insert))
  77. echo "New record created successfullly";
  78. else
  79. die("Failed inserting data: " . mysqli_error($conn));
Add Comment
Please, Sign In to add comment