Guest User

Untitled

a guest
May 16th, 2018
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.00 KB | None | 0 0
  1. if ($username != '' && $_POST['passwrd1'] != '') {  //leave
  2.     $sql_server = "sqlserver_url";          //change
  3.     $sql_server_usr = "sqlserver_username";     //change
  4.     $sql_server_pas = "sqlserver_password";     //change
  5.  
  6.     $mysql = mysql_connect($sql_server, $sql_server_usr, $sql_server_pas) or die("couldn't connect to server");
  7.     mysql_select_db("sql_database", $mysql) or die("couldn't select the database"); //change
  8.     //change table_name and username_column
  9.     $check = mysql_query('SELECT * FROM table_name WHERE username_column = '."'".$username."'") or die("couldn't check the query");
  10.     $info = mysql_fetch_array($check); //or die("couldn't get the array");
  11.    
  12.     //leave most of the things below alone
  13.     $sql_str_username = $username;
  14.     $req_password = $_POST['passwrd1'];
  15.    
  16.     //change table_name, password_column, username_column
  17.     mysql_query('UPDATE table_name SET password_column='."'".$req_password."'"." WHERE username_column='".$username"'");
  18.                        
  19.     mysql_close($mysql) or die("couldn't close server");
  20. };
Add Comment
Please, Sign In to add comment