±àдMySQLÊý¾Ý¿âµÄÓû§ÈÏ֤ϵͳʵÀý

login.php:£  

mysql_connect("localhost","user","password") 

/*Á¬½ÓÊý¾Ý¿â£¬Óû§ÃûºÍÃÜÂë×ÔÐÐÐÞ¸Ä*/ 

or die("ÎÞ·¨Á¬½ÓÊý¾Ý¿â£¬ÇëÖØÊÔ"); 
mysql_select_db("userinfo") 

or die("ÎÞ·¨Ñ¡ÔñÊý¾Ý¿â£¬ÇëÖØÊÔ"); 

$today=date("Y-m-d H:i:s"); 
$query=" 

select id 

from usertbl 

where name=$name and password=$password 

/*´ÓÊý¾Ý¿âÖÐËÑË÷ºÍµÇ¼Óû§ÏàÓ¦µÄ×ÊÁÏ*/ 

"; 

$result=mysql_query($query); 

$numrows=mysql_num_rows($result); 
if($numrows==0){ 

/*ÑéÖ¤ÊÇ·ñÄÜÕÒ³öÏàͬ×ÊÁϵÄÓû§£¬²»ÄÜÔòδע²á*/ 

echo ·Ç·¨Óû§

; 

echo Çë×¢²áÏÈ

; 

echo ÖØÊÔ

; 

} 
else{ 

$row=mysql_fetch_array($result); 

$id=$row[0]; 

$query=" 

update usertbl 

set lastlogin=$today 

where id=$id"; 

$result=mysql_query($query); 

SetCookie("usercookie", "»¶Ó­Äã,$name");

/*ÕâÀïʹÓÃÁËcookie£¬ÒÔ·½±ãÖ®ºóµÄÒ³ÃæÈÏÖ¤¡£

µ«ÎÒ먦·¢ÍêÕâÒ»¿é¡£Ï£ÍûÓÐÐËȤµÄÅóÓÑÖ¸Õý*/ 

echo µÇ¼³É¹¦

; 

echo Çë½ø£¡

; 

} 

?> 

register.php: 

mysql_connect("localhost","user","password") /*ÇëÐÞ¸ÄÓû§ÃûºÍÃÜÂë*/ 

or die("ÎÞ·¨Á¬½ÓÊý¾Ý¿â£¬ÇëÖØÊÔ"); 
mysql_select_db("userinfo") 

or die("ÎÞ·¨Ñ¡ÔñÊý¾Ý¿â£¬ÇëÖØÊÔ"); 

$query="select id from usertbl where name=$name\";

/*´ÓÊý¾Ý¿âÖÐËÑË÷ÏàͬÃû×ÖµÄÓû§×ÊÁÏ*/ 

$result=mysql_query($query); 

$numrows=mysql_num_rows($result); 

if($numrows!=0) /*ÕÒµ½Á˵±È»¾ÍÊÇÓÐÈËÏÈ×¢²áÁËÏàͬµÄÃû×Ö*/ 

{echo ÒÑÓÐÈË×¢²á´ËÃû£¬ÇëÖØÐÂÑ¡ÔñÃû×Ö!;} 

else 

{$query="insert into usertbl values(0,$name,$password,\)";

/*ÕÒ²»µ½ÏàͬµÄ¾ÍÊäÈëеÄÓû§×ÊÁÏ*/ 

mysql_query($query); 

echo ×¢²á³É¹¦; 

echo ÇëµÇ¼!;} 

?> 

if(!$usercookie) 

{header("·Ç·¨Óû§"); 

} 

?> 
welcome.php: 
require("cookie.php"); /*µ÷ÓÃcookie.php*/ 

?> 
echo $usercookie; 

?> 

create table usertbl 

( 

ID int auto_increment primary key, 

Name varchar(30), 

Password varchar(20), 

Lastlogin varchar(20) 

);