Advertisement
Guest User

Untitled

a guest
Apr 1st, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.93 KB | None | 0 0
  1. <?php
  2.  
  3. $conn = mysqli_connect("localhost", "b4014107", "Win1", "b4014107_db2") or die (mysqli_connect_error());
  4.  
  5. ?>
  6.  
  7. <?
  8. error_reporting(E_ALL);
  9. ini_set('display_errors', 1);
  10. include('ConnectorCode.php');
  11.  
  12. if(isser($_POST['Submit'])) {
  13. session_start();
  14. $FName = $POST['First_Name'];
  15. $LName = $POST['Last_Name'];
  16. $Email = $POST['Email'];
  17. $UName = $POST['User_Name'];
  18. $Password = $POST['Password'];
  19.  
  20. $FName = mysqli_real_escape_string($conn, $FName);
  21. $LName = mysqli_real_escape_string($conn, $LName);
  22. $Email = mysqli_real_escape_string($conn, $Email);
  23. $UName = mysqli_real_escape_string($conn, $UName);
  24. $Password = mysqli_real_escape_string($conn, $Password);
  25.  
  26. $sql = "SELECT Email FROM tbl_Users WHERE Email='$Email'";
  27. $result = mysqli_query($conn, $sql);
  28. $row = mysqli_fetch_array($result, MYSQLI_ASSOC);
  29.  
  30. if(mysqli_num_rows($result) == 1)
  31. {
  32. echo "Sorry, the email you are trying to enter already exists";
  33. }
  34. else
  35. {
  36. $query = mysqli_query($conn, "INSERT INTO tbl_Users(First_Name, Last_Name, Email, User_Name, Password) VALUES ('$FName', '$LName', '$Email', '$UName', '$Password')");
  37. if($query)
  38. {
  39. echo "Thank you for registering";
  40. }
  41. header('Location: Index.php');
  42. }
  43.  
  44. }
  45. ?>
  46.  
  47. <!DOCTYPE HTML>
  48. <head>
  49. <title>Register</title>
  50. </head>
  51. <body>
  52.  
  53. <h1> Register Page </h1>
  54.  
  55. <p> Please fill in the form to register <p>
  56.  
  57. <form method="post" action="">
  58. <fieldset>
  59. First Name: <br />
  60. <input name="First_Name" type="text" class="input" size="25" required /> <br /> <br />
  61. Last Name: <br />
  62. <input name="Last_Name" type="text" class="input" size="25" required /> <br /> <br />
  63. Email: <br />
  64. <input name="Email" type="email" class="input" size="25" required /> <br /> <br />
  65. Username: <br />
  66. <input name="User_Name" type="text" class="input" size"25" required /> <br /> <br />
  67. Password: <br />
  68. <input name="Password" type="password" class="input" size="25" required /> <br /> <br/>
  69. <input type="submit" name="submit" value="Register!" />
  70. </fieldset>
  71. </form>
  72. </body>
  73. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement