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
Post a Comment