第一步
/*
先建立資料表 直接複製到你的phpmyadmin 直接運行就OK了。1
CREATE TABLE IF NOT EXISTS `useradmin` (
`id` int(4) NOT NULL auto_increment,
`username` varchar(20) default NULL,
`userpass` varchar(40) default NULL,
`logins` int(4) NOT NULL default '0' COMMENT '登陸次數',
`logintime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`mid` char(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
*/
第二步
用dw建立一個php檔案件
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>無標題文檔</title>
</head>
<body>
<form name="form1" method="post" action="">
<label>
<input name="uname" type="text" id="uname">
</label>
<label> <br>
<br>
<input name="password" type="password" id="password">
</label>
<p>
<label>
<input type="submit" name="Submit" value="提交">
</label>
</p>
</form>
</body>
</html>
第三步
mysql_connect('localhost','root','root') or die( mysql_error());//主機名稱，mysql使用者名稱，mysql密碼
mysql_select_db('111cnNet'); //資料庫名
mysql_query("set Names 'gbk'"); //設定編碼，要不容易出亂碼，最好資料庫與頁面的編輯一致
if( isset($_GET['uname']) && isset($_GET['password']))
{
$uname = $_GET['uname'];
$password = md5($_GET['password']); //md5在php是帶自的系統內建函數，不像asp教程使用者自義的
//現在構造sql語句
$sql ="Select * from useradmin where username='$uname' and userpass='$password' limit 1";
$query = mysql_query( $sql );
if( mysql_num_rows( $query ) )
{
echo '登入成功';
}
else
{
echo '登入失敗,使用者名稱密碼不正確';
}
}
////好了就OK了，本站原創教程轉載請註明來源碼教程 www.111cn.net
了看看這款php入門使用者登陸執行個體代碼與教程吧
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
