$mysql_servername = "localhost";
$mysql_username = "數據庫用戶名";
$mysql_password ="密碼";
$mysql_database ="數據庫名";
mysql_connect($mysql_servername , $mysql_username , $mysql_password);
mysql_select_db($mysql_database);
$name=$_POST['user_name'];
$passowrd=$_POST['user_password'];
if ($name && $passowrd){
$sql = "SELECT * FROM admin WHERE name = '$name' and password='$passowrd'";
$res = mysql_query($sql);
$rows=mysql_num_rows($res);
if($rows){
header("location='主頁'");
exit;
}
echo "<script language=javascript>alert('用戶名密碼錯誤');history.back();</script>";
}else {
echo "<script language=javascript>alert('用戶名密碼不能為空');history.back();</script>";
}