Advertisement
Guest User

Untitled

a guest
Feb 19th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.49 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>Form submission</title>
  5. </head>
  6. <body>
  7. <div class="content">
  8. <form action="SD.php" method="POST">
  9. <label>Name: </label><br>
  10. <input name="fullname" type="text" size="35"/><br>
  11.  
  12. <label>ID: </label><br>
  13. <input name="ID" type="text" size="35" /><br>
  14.  
  15. <label>email: </label><br>
  16. <input name="email" type="text" size="35" /><br>
  17.  
  18. <label>Phone number: </label><br>
  19. <input name="phonenummber" type="text" size="35" /><br>
  20.  
  21. <label>message: </label><br>
  22. <input name="message" type="text" size="65" /><br>
  23.  
  24. <input name="mySubmit" type="submit" value="Submit!" /><br>
  25. </form>
  26.  
  27. </div>
  28. </body>
  29. </html>
  30. <?php
  31.  
  32. $servername = "localhost";
  33. $username = "root";
  34. $password = "";
  35. $dbname = "firstform";
  36. $db = mysqli_connect('localhost','root','','firstform');
  37.  
  38. if ($db)
  39. echo '<br>successfully connected<br>';
  40. //Send Data
  41. if(isset($_POST['ID']) && isset($_POST['fullname']) && isset($_POST['email']) && isset($_POST['phonenummber']) && isset($_POST['message'])) {
  42. $myID = $_POST['ID'];
  43. $myName = $_POST['fullname'];
  44. $myMail = $_POST['email'];
  45. $myNummer = $_POST['phonenummber'];
  46. $message = $_POST['message'];
  47. $age = 5;
  48. $sql = "INSERT INTO cdb VALUES ('" . $myID. "', '".$myName."', '" . $age . "', '".$myMail."', '".$myNummer."', '".$message."')";
  49. $chk = $db->query($sql);
  50. $db->close();
  51. var_dump($chk);
  52. echo mysqli_error($db);
  53. echo "Submitted!";
  54. }
  55. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement