Advertisement
Guest User

Untitled

a guest
Jul 18th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.67 KB | None | 0 0
  1. <?php
  2. $connection = mysql_connect("localhost","root","");
  3.  
  4. if (!$connection)
  5. {
  6.     die('Connection interupted, please try again later' . mysql_error());
  7. }
  8.  
  9. mysql_select_db("game", $connection);
  10.  
  11. if(isset($_POST['submit']))
  12. {
  13.     $user = mysql_real_escape_string($_POST['user']);
  14.     $pass = mysql_real_escape_string($_POST['pass']);
  15.     $name = mysql_real_escape_string($_POST['name']);
  16.     $lname = mysql_real_escape_string($_POST['lname']);
  17.     $email = mysql_real_escape_string($_POST['email']);
  18.     $secq = mysql_real_escape_string($_POST['secq']);
  19.     $secansw = mysql_real_escape_string($_POST['secansw']);
  20.  
  21.     if(empty($user) || empty($pass) || empty($name) || empty($lname) || empty($email) || empty($secq))
  22.     {
  23.         $errors[] = 'You have left empty fields';
  24.     }
  25.     else
  26.     {
  27.         $user_test_query = mysql_query("SELECT acc_name FROM account WHERE acc_name = '$user' LIMIT 1") or die(mysql_error());
  28.  
  29.         if (mysql_num_rows($user_test_query) == 1)
  30.         {
  31.             $errors[] = 'This username already exists. Please try again.';
  32.         }
  33.  
  34.         if(!preg_match('#^[a-z0-9]{8,16}$#i', $pass))
  35.         {
  36.             $errors[] = 'Bad password, make sure the password contains 0-9 and a-z ! and is longer then 8 characters and smaller then 16 characters';
  37.         }
  38.     }
  39.  
  40.     if(count((array) $errors)
  41.     {
  42.         $user_insert = mysql_query("INSERT INTO account (acc_name,acc_pw,acc_rn,acc_rsn,acc_em,acc_sq,acc_sa) VALUES ('" . $user . "', '" . $pass . "', '" . $name . "', '" . $lname . "', '" . $email . "', "' . $secq . "', '" . $secansw . "')") or die(mysql_error());
  43.  
  44.         if(isset($user_insert))
  45.         {
  46.             echo 'Registration succesfull, you can now log in';
  47.         }
  48.     }
  49.     else
  50.     {
  51.         implode("<br />", $errors);
  52.     }
  53. }
  54.  
  55. mysql_close($connection);
  56. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement