Guest User

Untitled

a guest
May 16th, 2018
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.02 KB | None | 0 0
  1. $sql_server = "localhost";      //sqlserver url
  2. $sql_server_usr = "sqlserver_username";
  3. $sql_server_pas = "sqlserver_password";
  4.  
  5. $mysql = mysql_connect($sql_server, $sql_server_usr, $sql_server_pas) or die("couldn't connect to server");
  6. mysql_select_db("sql_database", $mysql) or die("couldn't select the database");
  7.  
  8. $check = mysql_query('SELECT * FROM table_name WHERE username_column = '."'".$username."'") or die("couldn't check the query");
  9. $info = mysql_fetch_array($check); //or die("couldn't get the array");
  10.        
  11. $sql_str_username = $regOptions["username"];
  12.        
  13. if ($req_username == $sql_str_username)
  14. {
  15.     echo '<script type="text/javascript">
  16.             alert("Username or email already exist!")
  17.                     </script>';
  18. }
  19. else
  20. {
  21.     $req_username = $regOptions["username"];
  22.     $req_password = $regOptions["password"];
  23.     $req_email = $regOptions['email'];
  24.     mysql_query('INSERT INTO Users(username_column, password_column) VALUES '."('".$req_username."', '".$req_password."'");
  25.  
  26. };
  27. mysql_close($mysql) or die("couldn't close server");
Add Comment
Please, Sign In to add comment