一個基於mysql的登陸驗證程序

******************************************************
file name: login.PHP3
Login Check
編碼： PHP 4
作者： Kevin Lee < webwing@21cn.com >

Database: MySQL。
Host: localhost Database : mydb
Table structure for table 'user'
--------------------------------------------------------
CREATE TABLE user (
id smallint(6) NOT NULL auto_increment,
user varchar(12) NOT NULL,
passwd varchar(12) NOT NULL,
name varchar(20),
email varchar(30),
level char(1),
status char(1),
UNIQUE id (id)
);
--------------------------------------------------------


*******************************************************/
?>

$db_id = MySQL_pconnect("localhost", "root", "");
$sql="select id, user, passwd from user where user='".$name."' and passwd='".$pwd."'";
$result = MySQL_db_query("mydb",$sql);
$row = MySQL_fetch_array($result);
$id = $row[id] ;

if ($id!="") {
session_start();
session_register("yn");
$yn="yes" ;
echo "";
echo "你已經成功登陸。。。"."

";
echo "

"."窗口10秒鐘後自動關閉"."";
echo "";

}
else {
echo "帳號或密碼錯誤！！！";
echo "

";
echo "

";
echo "back";
echo "" ;
}
?>


您正在看的MySQL教程是:一個基於MySQL的登陸驗證程序。 用戶密碼

/************************
file name: login_chk.PHP3
************************/
if ($yn!="yes") {

echo "