$sql = "SELECT * FROM member WHERE
login_name = '$login_name' AND
login_password = '$login_password'";
$result = mysql_query( $sql ) or die ("Error Query"); // error ตรงนี้น่ะครับ
$num = mysql_numrows( $result );
if ( $num != 0 )
{
$auth = true;
}
}
if ( ! $auth )
{
header( 'WWW-Authenticate: Basic realm="Private"' );
header( 'HTTP/1.0 401 Unauthorized');
echo " Name or Password incorrect<br>";
echo "<br><a href=\"home.php\">Sign in again</a>";
exit;
}
else
{
//header("Location : member_home.php");
}
?>
--------------------------------------------------------------------------------
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/virtual/site28/fst/var/www/html/member_home.php on line 39
Error Query
มัน error ตรงบรรทัดนี้
$result = mysql_query( $sql ) or die ("Error Query"); // error ตรงนี้น่ะครับ
ช่วยชี้แนะช่วยชี้แนะด้วยครับ มือใหม่จิง ๆ
Tag : - - - -
Date :
15 ธ.ค. 2547 14:46:52
By :
jack
View :
3203
Reply :
10
No. 1
Guest
$result = mysql_query( $sql ) or die ("Error Query"); // error ตรงนี้น่ะครับ
ลองแก้ไขแบบนี้นะคับแล้วเอาไปวางแทน อาจจะหายนะคับ
$result=mysql_db_query($dbname,$sql);
if (empty($result))
echo "Error Query";
else
echo "Query Ok";
end if
if (isset($login_name ) and isset($login_password))
{
$db = mysql_connect("$hostname", "$username", "$password") or die ("Error Connect DB");
mysql_select_db("$dbname",$db);
$sql = "SELECT * FROM member WHERE
login_name = '$login_name' AND
login_password = '$login_password'";
$result=mysql_db_query($dbname,$sql);
if (empty($result))
echo "Error Query";
else
echo "Query Ok";
$num = mysql_numrows( $result );
if ( $num != 0 )
{
$auth = true;
}
}
if ( ! $auth )
{
header( 'WWW-Authenticate: Basic realm="Private"' );
header( 'HTTP/1.0 401 Unauthorized');
echo " Name or Password incorrect<br>";
echo "<br><a href=\"home.php\">Sign in again</a>";
exit;
}
else
{
//header("Location : member_home.php");
}
?>
-----------------------------------------------------------------------------------------------------------
Error Query
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/virtual/site28/fst/var/www/html/member_home.php on line 47
Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site28/fst/var/www/html/member_home.php:5) in /home/virtual/site28/fst/var/www/html/member_home.php on line 58
Warning: Cannot modify header information - headers already sent by (output started at /home/virtual/site28/fst/var/www/html/member_home.php:5) in /home/virtual/site28/fst/var/www/html/member_home.php on line 59
:) Name or Password incorrect
Sign in again
------------------------------------------------------------------------------------------------------------
แก้ไขแล้วครับ แล้วก็ขึ้น error แบบนี้ แก้ไงต่อดีครับ ไม่รู้ผมพิมพ์ตรงไหนป่าว
/*
Logout a user
*/
function doLogout()
{
if (isset($_SESSION['db_projectfinal_user_id'])) {
unset($_SESSION['db_projectfinal_user_id']);
session_unregister('db_projectfinal_user_id');
session_destroy();
}