Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\sc_db2\check_login.php on line 9
Username and Password Incorrect!
ดูเหมือนว่ามัน UNION ไม่สมบูรณ์ ผมนั่งแก้มา 3 วันแล้ว
check_login.php (PHP)
<?
session_start();
require("connectdb.php");
$strSQL = "SELECT username , pass , status FROM sc_admin "
. " UNION SELECT username , pass , status FROM sc_user "
. " UNION SELECT username , pass , status FROM sc_sw WHERE username = '".trim($_POST['txtusername'])."'
and pass = '".trim($_POST['txtpassword'])."'";
$objQuery = mysql_query($strSQL);
$objResult = mysql_fetch_array($objQuery);
if(!$objResult)
{
echo "Username and Password Incorrect!";
}
else
{
$_SESSION["username"] = $objResult["username"];
$_SESSION["status"] = $objResult["status"];
session_write_close();
if($objResult["status"] == "admin")
{
header("location:admin_page.php");
}
else if($objResult["status"] == "user")
{
header("location:user_page.php");
}
else if($objResult["status"] == "sw")
{
header("location:sw_page.php");
}
else
{
echo "No Permission";
}
}
mysql_close();
?>
username varchar(50) tis620_thai_ci No
pass varchar(50) utf8_general_ci No
name varchar(50) tis620_thai_ci No
last varchar(50) tis620_thai_ci No
department varchar(50) tis620_thai_ci No
status varchar(10) utf8_general_ci No
softwarename varchar(50) utf8_general_ci No
mainindustry varchar(50) utf8_general_ci No
subindustry varchar(50) utf8_general_ci No