Guest User

Untitled

a guest
May 21st, 2018
219
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.62 KB | None | 0 0
  1. <?php
  2. session_start();
  3. include("SQL.php");
  4. $DBConn = mysql_connect($SQLServ,$SQLUser,$SQLPass);
  5. mysql_select_db($SQLDb,$DBConn);
  6. ?>
  7. <html>
  8. <head>
  9. <link rel='stylesheet' type='text/css' href='style.css'/>
  10. </head>
  11. <body>
  12. <div id='container'>
  13. <div id='containerouter'>
  14. <div id='containerinner'>
  15. <p id='menu'>
  16. <?php
  17. include('header.php');
  18. ?>
  19. </p>
  20. </div>
  21. </div>
  22. <div id='containerouter'>
  23. <div id='containerinner'>
  24. <h2>Register</h2>
  25. <table align='center'>
  26. <form id='register' action='' method='POST'>
  27. <tr><td>Username : </td><td><input type='text' name='username'/></td></tr>
  28. <tr><td>Password : </td><td><input type='password' name='password'/></td></tr>
  29. <tr><td>E-Mail : </td><td><input type='text' name='email'/></td></tr>
  30. <tr><td colspan='2'><center><input type='submit' name='submit_register' value='Register !'/></center></td></tr>
  31. </form>
  32. </table>
  33. </div>
  34. </div>
  35. </div>
  36. </body>
  37. </html>
  38. <?php
  39. function checkText($text){
  40. return preg_match('/^[a-zA-Z0-9]+$/',$text) ? TRUE : FALSE;
  41. }
  42. function checkEmail($email){
  43. return preg_match('/^\S+@[\w\d.-]{2,}\.[\w]{2,6}$/iU', $email) ? TRUE : FALSE;
  44. }
  45. if(isset($_POST["submit_register"])){
  46. $username = mysql_real_escape_string($_POST["username"]);
  47. $password = mysql_real_escape_string($_POST["password"]);
  48. $email = mysql_real_escape_string($_POST["email"]);
  49. $UserCheck = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE username='".$username."'")) or die(mysql_error());
  50. if($UserCheck['username']==$username)
  51. {
  52. echo "<div id='formErrors'><center>There is already an account with that username !</center></div>";
  53. exit();
  54. }
  55. $EmailCheck = mysql_fetch_array(mysql_query("SELECT * FROM users WHERE email='".$email."'"));
  56. if($EmailCheck['email']==$email)
  57. {
  58. echo "<div id='formErrors'><center>There is already an account with that e-mail address !</center></div>";
  59. exit();
  60. }
  61. if(checkText($username)==FALSE)
  62. {
  63. echo "<div id='formErrors'><center>Username is invalid !</center></div>";
  64. exit();
  65. }
  66. if(checkEmail($email)==FALSE)
  67. {
  68. echo "<div id='formErrors'><center>E-Mail is invalid !</center></div>";
  69. exit();
  70. }
  71. $lastuid = mysql_fetch_array(mysql_query("SELECT uid FROM users ORDER BY uid desc")) or die(mysql_error());
  72. $uid = $lastuid[0]+1;
  73. mysql_query("INSERT INTO users VALUES ('".$uid."','".$username."','".$password."','".$email."','0')") or die(mysql_error());
  74. echo "<div id='formErrors'><center><font color='green'>Successfully registered !</font></center></div>";
  75. }
  76. ?>
Add Comment
Please, Sign In to add comment