php mysql 验证用户_使用php和mySql进行用户身份验证

在下面的代码中面临挑战;请帮忙：

session_start();

$con = mysql_connect("localhost","root","");

if (!$con){

die('Could not connect: ' . mysql_error());

}

$db_exist = mysql_select_db("seta", $con);

$myUName = $_POST["username"];

$myPwd = $_POST["pwd"];

$loFmUname = strtolower($myUName);

if($db_exist){

$sql = "SELECT * FROM Persons WHERE $loFmUname = 'strtolower($db_field['UserName'])' AND $myPwd = '$db_field['UserPwd']'";

$result = mysql_query($sql);

if($result){

$_session['loged'] = '$loFmUname';

header('location:index.html');

die();

}

else{

echo"Invalid username and/or password please";

echo "try again";

}

}

else{

echo "Sorry Database Not Found";

}

mysql_close($con);

?>The error is coming on line 15.

请注意，strtolower()正用于忽略区分大小写的用户名。