Php login system -null value logging in -


my php login system mysql logging in null values. why happening?

session_start();  $username = $_post['username']; $password = $_post['password'];   mysql_connect("localhost" , "root" , ""); mysql_select_db("deirastaff");  $result = mysql_query("select * users username ='$username' , password = '$password' ")      or die("login failed" .mysql_error());  $row = mysql_fetch_array($result);  if ($row['username']==$username && $row['password']==$password) {     $_session['username']=$username;      echo '<script type="text/javascript"> window.open("staff.php","_self");</script>';      //header("location:staff.php");      //echo "login successfull "."welcome ".$row['username'];      }else {      echo '<script type="text/javascript">     window.alert("login failed!");     window.open("index.php","_self");     </script>';      //header("location:index.php");     //echo "login failed !";     break; } 

mysqli better use...

but if want use mysql try code..

if(isset($submit)) //name of submit button {     $result = mysql_query("select * users username ='$username' , password = '$password' ") or die("login failed" .mysql_error());     if(mysql_num_rows($rs)<1)     {         echo "login failed" ;     }     else     {         $_session[username]=$username;     } } 

Comments

Popular posts from this blog

commonjs - How to write a typescript definition file for a node module that exports a function? -

openid - Okta: Failed to get authorization code through API call -

thorough guide for profiling racket code -