Guest User

Untitled

a guest
Sep 24th, 2018
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. <?php
  2. error_reporting(0);
  3. ?>
  4.  
  5. <!DOCTYPE html>
  6. <html>
  7. <head>
  8. <title>Program</title>
  9. </head>
  10. <body>
  11. <form action="" method="post">
  12. <p>Roll no</p>
  13. <input type="number" name="roll" placeholder="Enter Roll no">
  14. <p>Name</p>
  15. <input type="text" name="name" placeholder="Enter Name">
  16. <p>Course name</p>
  17. <input type="text" name="dept" placeholder="Enter Course name">
  18. <br> <br>
  19. <input type="submit">
  20. </form>
  21. </body>
  22. </html>
  23.  
  24. <?php
  25. $roll = $_POST["roll"];
  26. $name = $_POST["name"];
  27. $dept = $_POST["dept"];
  28. $dbhost = "loaclhost";
  29. $dbuser = "root";
  30. $dbpass = "";
  31. $dbname = "db5";
  32. $conn = mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
  33. $query = "INSERT INTO student (roll,name,dept) VALUES ($roll,'$name','$dept')";
  34. $data = mysqli_query($conn,$query);
  35. if($data)
  36. {
  37. echo "Submitted";
  38. }
  39. else
  40. {
  41. mysql_error();
  42. }
  43. ?>
Add Comment
Please, Sign In to add comment