¼ÌÐøÕª³£º½ÌÄãÓÃPHPдMySQLÊý¾Ý¿âµÄÓû§ÈÏ֤ϵͳ
Óû§ÈÏÖ¤µÄÔÀíºÜ¼òµ¥£ºÊ×ÏÈÐèÒªÓû§ÔÚÒ³ÃæÉÏÌîÈëÓû§ÃûºÍÃÜÂ룬µ±È»Ã»×¢²áµÄÓû§ÐèÒªÏÈ×¢²á¡£È»ºóµ÷ÓÃÊý¾Ý¿âËÑË÷ÊÇ·ñÓÐÏàÓ¦µÄÓû§¡£Èç¹ûÓоÍÈ·ÈÏ£¬Ã»ÓÐÔòÌáÐÑÓû§ÏÈ×¢²á¡£Ê¹ÓÃPHPÀ´Íê³ÉÕâÒ»Çкܼòµ¥£¬µ«ÐèҪעÒâµÄÊÇÈç¹ûÏëÔÚÒÔºóµÄÒ³ÃæÖж¼ÄÜÈ·ÈÏÓû§Éí·Ý¡£
µÚÒ»²½ÊÇ×öÒ»¸öµÇ¼µÄÒ³Ãæ¡£
µÚ¶þ²½¿ªÊ¼µÇ¼ºóµÄÈ·ÈϳÌÐòµÄÉè¼Æ¡£
ÒÔÏÂΪÒýÓõÄÄÚÈÝ£º
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 Çë½ø£¡
;
}
?>
µÚÈý²½×öºÃ×¢²áµÄÒ³Ãæ¡£
µÚËIJ½ÊÇ×¢²áºóµÄÉí·ÝÈ·ÈϺÍÊäÈëÊý¾Ý¿â¡£
ÒÔÏÂΪÒýÓõÄÄÚÈÝ£º
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 ÇëµÇ¼!;}
?>
ÏÂÒ»²½ÊÇcookieµÄʹÓã¬ÎÒÔ´òËãʹÓÃcookieÀ´Ê¹Ã¿Ò»Ò³¶¼ÄÜʶ±ðÓû§Éí·Ý£¬µ«ÓÉÓÚ±ðµÄÒ³
Ïà¹ØÎĵµ£º
Ôø¾Ê§°Ü¹ýn´Î£¬ÈÃÎÒÏ൱ÎÞÄÎ×îºóÖÕÓÚÕÒµ½ÁËÒ»¸ö½â¾ö·½°¸£¬¹©´ó¼Ò·ÖÏí
ɾµô×¢²á±íµÄ·½·¨£¬ÎÒÒ²Ôø¾Óùý£¬µ«×ÜÊÇʧ°Ü£¬½¨ÒéÈçÏÂ
Ò»£ºÏÈÐ¶ÔØÈí¼þmysql
¶þ£ºÏÈɾע²á±íµÄ¶«Î÷£»
Èý£º×îºóÔÚÄãµÄµ±Ç°Óû§ÀïcÅÌÏÂC:\Documents and Settings\All Users\Application Data\ÕÒµ½mysqlµÄĿ¼£¬É¾µô£¬ÍüÁ˸æËßÒ»¾ä£»
ÄÇÊÇÒþ²ØÎļþ£ ......
MySQL Migration ToolkitÊÇMySQL³öµÄÊý¾ÝÇ¨ÒÆ¹¤¾ß(ÊÊÓÃÓÚMySQL5.0»òÒÔÉÏ)£¬Ê¹Óò¢²»¸´ÔÓ£¬Ö§³ÖOracle,Microsoft SQL Server,Microsoft Access,Sybase,MaxDBµ½MySQLÖ®¼äµÄת»»¡£ÒÔÏÂʵÀýÊÇOracleµ½MySQLµÄ¡£
1. °²×°jdk1.6
×°ÍêMySQL Migration Toolkit»¹Ðè°²×°jdk1.6£¬ÐèÒªjre1.5.0.8ÒÔÉϵÄÖ§³Ö¡£
2. ÔËÐÐMySQL Mi ......
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure
sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall
sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ý³ÌûÓвÎÊý´«µÝ
Èý.ɾ³ý´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
drop procedure ......
mysql½Ì³Ì:¸ßÊÖÊÇÔõÑùÁ¶³ÉµÄ:¾«ÃîSQLÓï¾ä½éÉÜ
[ÈÕÆÚ£º2009-06-02] À´Ô´£º ×÷Õߣº
ÈçºÎ´Óһλ²ËÄñÍɱä³ÉΪ¸ßÊÖ£¬Áé»îʹÓõÄSQLÓï¾äÊDZز»¿ÉÉٵġ£±¾ÎÄÊÕ¼¯Á˲¿·Ö±È½Ï¾µä£¬³£ÓõÄSQLÓï¾ä¹©´ó¼Ò²Î¿¼£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
¡¡¡¡ËµÃ÷£º¸´ÖƱí(Ö»¸´Öƽṹ,Ô´±íÃû£ºa бíÃû£ºb)¡¡¡¡
¡¡¡¡SQL: select * into ......
ΪÁËÓ¦¸¶Êý×ÖýÌåʵ¼ùСѧÆÚ£¬ÓÃÁ½ÈýÌìµÄʱ¼ä´Ò´ÒææµØ¼ÜÆðÀ´Ò»¸öPHPÍøÕ¾¡£ÍøÕ¾ºÜ´é£¬ÀÏʦ¸øµÄ·ÖÊýÈÃËü¿´ÆðÀ´¸ü´é¡£
×öÕâ¸öÍøÕ¾µÄÄǶÎʱ¼äÕýºÃÔÚ¿´BrooksµÄÄDZ¾¿õÊÀ¾µä¡¶ÈËÔÂÉñ»°¡·£¬Á˽âÁËÆäÖеēThe Surgical
Team”µÄ¿ª·¢Ä£Ê½£¬¾õµÃÔÚÌØÊⳡºÏÏ£¬ÕâÖÖ¿ª·¢Ä£Ê½È·Êµ»áÓµÓм«¸ßµÄ¿ª·¢Ð§ÂʺÍÍŶÓÕ½¶·Á¦¡£
Ò ......