|
|
|
ช่วยด้วยครับ please ผมสร้างตาราง member มี mem_id,mem_name,mem_password login ไม่สำเร็จครับ ช่วยดู |
|
|
|
|
|
|
|
ผมสร้างตาราง member มี mem_id,mem_name,mem_password
login ไม่สำเร็จครับ ช่วยดู code หน่อยคร้าบ
<?php
function ChkLogin ($conn,$name,$password)
{
$strSQL = "SELECT * FROM member";
$strSQL = $strSQL . " WHERE mem_name='$name' ";
$strSQL = $strSQL . " AND mem_password='$password' ";
$result=mysql_query($strSQL, $conn);
if(!$result)die ("SELECT have problem".mysql_error());
if(mysql_num_rows($result))return true;
return false;
}
$conn = mysql_connect("localhost","user","arsenal");
if(!$conn)
die ("can not connect to MySQL");
mysql_select_db("member",$conn)
or die ("can not select database");
if ($_COOKIE["CK"]["Flag"]!=true)
if (ChkLogin($conn,$name,$password))
{
$strSQL = "SELECT * FROM member";
$strSQL = $strSQL."WHERE mem_name='$name'";
$strSQL = $strSQL."AND mem_password='$password'";
$result=mysql_query($strSQL,$conn);
if(!$result)die ("SELECT have problem".mysql_error());
$rs=mysql_fetch_array($result);
setcookie("CK[Flag]",true,time()+3600);
setcookie("CK[mem_id]",$rs[mem_id],time()+3600);
setcookie("CK[mem_name]",$rs[mem_name],time()+3600);
setcookie("CK[mem_tracking]",1,time()+3600);
echo"<html>\n";
echo"<head>\n";
echo"<title>Member Login</title>\n";
echo"</head>\n";
echo"<body bgcolor\"#E3E3E3\">\n";
echo"<b>$rs[mem_name]</b>login for<b>1</b>time<p>";
echo"<a href=\"Logout.php\">Logout</a>";
echo"</body>\n";
echo"</html>\n";
}
else
{
echo"username or password fail<br>";
echo"<a href=\"FrmMemberLogin.php\">Log in</a>";
}
else
{
$_COOKIE["CK"]["mem_tracking"]++;
setcookie("CK[mem_tracking]",$_COOKIE["CK"]["mem_tracking"],time()+3600);
echo"<html>\n";
echo"<head>\n";
echo"<title>Member Login</title>\n";
echo"</head>\n";
echo"<body bgcolor\"#E3E3E3\">\n";
echo"Cookie auto Login <br>";
echo"<b>$CK[mem_name]</b>login for<b>$CK[mem_tracking]</b><p>";
echo"<a href=\"Logout.php\">Logout</a>";
echo"</body>\n";
echo"</html>\n";
}
?>
Tag : - - - -
|
|
|
|
|
|
Date :
25 ก.ย. 2550 15:12:54 |
By :
jeangna |
View :
1662 |
Reply :
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
แก้ได้แล้วครับ ขอโทษที
|
|
|
|
|
Date :
25 ก.ย. 2550 15:53:01 |
By :
jeangna |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 01
|