Windowsϰ²×°×îеÄApache+PHP+MySQLÖ¸ÄÏ
×¢Ò⣺֮ǰÎÒÔÚÍøÉÏÕÒÁ˺öàµÄ×ÊÁÏ NND¶¼²»ÄÜÕý³£ÅäÖóɹ¦ ¸ãµÃÎÒÊǷdz£µØÓôÃÆ£¡
ÕÒµ½ÕâÆªÎÄÕÂÖ®ºóÎÒÖÕÓÚÅäÖóɹ¦ÁË£¡ÍÛºÃˬѽ£¡Ö»Òª°´ÕÕ ÉÏÃæµÄ²½Öè¾ÍÒ»¶¨Äܹ»³É¹¦µÄ£¡
´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚWindows XPϵÄApache+PHP+MySQL°²×°£¬Í¬Ê±Ò²ÊÊÓÃÓÚWindows 2003ϵͳϵݲװºÍÅäÖá£
1. °²×°»·¾³
²Ù×÷ϵͳÊÇ Windows XP ÖÐÎİæ, Apache, PHP, MySQL µÄ×îа汾ÊǽØÖ¹µ½ 2007.09.07£¬·Ö±ðÔÚÆä¹ÙÍøÏÂÔØµÄ:
* Apache 2.2.6£ºhttp://apache.mirror.phpchina.com/httpd/binaries/win32/
* PHP 5.2.4 (Windows Binaries PHP 5.2.4 zip package£©: http://www.php.net/downloads.php ÎÒ֮ǰÊÇÏÂÔØÁËÒ»¸öexe¸ñʽµÄ¹þ¹þ ÏÖÔÚÏÂÁËÒ»¸özip¸ñʽµÄ
* MySQL 5.0.45 Windonws: http://dev.mysql.com/downloads/
2. °²×°µÄĿ¼½á¹¹¹æ»®
ΪÁË·½±ãά»¤£¬¿ÉÒÔ½«·þÎñÆ÷Èí¼þ°²×°ÔÚϵͳÅÌ£¨CÅÌ£©¶ø°Ñ×Ô¼ºµÄÎļþ¶¨Î»µ½ÆäËûÅÌ£¬ÕâÑù¶ÔÓÚÒÔºóµÄά»¤ºÜÖØÒª¡£
3. ÔÚ Windows XP ϰ²×° Apache 2.2.6
Windows XP ϵݲװ
1. ÔËÐÐ apache 2.2.6 µÄ°²×°³ÌÐò£¬¸ù¾ÝÌáʾһ· Next ¼´¿É¡£ÔÚ Server Information µÄ Network Domain¡¢Server Name ×Ö¶ÎËæ±ãÌîÉÏÒ»¸öÓòÃû¼´¿É£¬Èçphp.com£¬È»ºó¸ù¾ÝÌáʾһ· Next Íê³É¼´¿É¡£
2. ÔÚ°²×°½áÊøÊ±£¬»áµ¯³öÒ»¸ö DOS ´°¿Ú£¬È»ºó¾ÍÏûʧÁË£¬ÕâÊÇϵͳapache×Ô¶¯Æô¶¯ÁË¡£
4. ÔÚ Windows XP ϰ²×° php 5.2.4
1. ½«ÏÂÔØµÄ php 5 ZIP °üÖ±½Ó½âѹ£¬ÎÒÖ±½Ó½« PHP 5.2.4 zip Îļþ½âѹµ½ d:\php Ŀ¼ÏÂÃæ¡£°²×° php ²»½¨ÒéʹÓà win32 °²×°³ÌÐò(Ö÷ÒªÊÇÒÔºó°²×°À©Õ¹Âé·³£©¡£
2. ÔÚ×ÊÔ´¹ÜÀíÆ÷ÖнøÈë php µÄ°²×°Ä¿Â¼£¬½« php.ini-dist »ò php.ini-recommended ¸´ÖÆÒ»·Ý£¬ÃüÃûΪ php.ini¡£È»ºó´ò¿ª php.ini¡£
3. ÕÒµ½:
;extension=php_mysql.dll
½«Ç°ÃæµÄ ; ºÅÈ¥µô£¬ ¸Ä³É£º
extension=php_mysql.dll
4. ÕÒµ½:
extension_dir = “./”
½«Æä¸ÄΪÄãµÄ php °²×°Ä¿Â¼Ï ext ×ÓĿ¼µÄ¾ø¶Ô·¾¶¡£ÀýÈçÎҵģº
extension_dir = “D:/php/ext/”
Õâ²½ºÜÖØÒª ¡£·ñÔò½ÓÏÂÀ´ php »áÕÒ²»µ½ php_mysql.dll Ä£¿é£¬ÎÞ·¨×°ÔØ¡£
5. ÔÚ“¿ØÖÆÃæ°å”->“ϵͳ”->“¸ß¼¶”->“»·¾³±äÁ¿”£¬Ôړϵͳ±äÁ¿”ÀïÃæÕÒµ½path£¬±à¼pathµÄ±äÁ¿Öµ£¬Ìí¼ÓÄãµÄphpĿ¼D:\php£¬Ç°ÃæÒ»¶¨ÒªÓ÷ֺÅ(;)°ÑËüºÍÇ°ÃæµÄÖµ·Ö¿ª¡£
5. ÅäÖà Apache ºÍ PHP
´ò¿ª Apache °²×°Ä¿Â¼Ï嵀 conf ×ÓÄ¿Â
Ïà¹ØÎĵµ£º
Àý×Ó£º½«cdb_pms±ísubject×Ö¶ÎÖеÄWelcom toÌæ»»³É »¶Ó¹âÁÙ
UPDATE `cdb_pms`
SET `subject` = REPLACE(`subject`, ¡®Welcome to¡¯, ¡®»¶Ó¹âÁÙ¡¯)
WHERE INSTR(`subject`,¡¯Welcome to¡¯) < 0 Ìæ»»cdb_posts±íµÄmessage×ֶΣ¬½«¡°viewthread.php?tid=3989¡±Ìæ»»³É¡°viewthread.php?tid=16546¡± U ......
MySQLµÄmysqldump¹¤¾ßµ¼Èëµ¼³öÊý¾Ý¿â£¡
1.µ¼³öÕû¸öÊý¾Ý¿â(DosÏÂ)
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
mysqldump -u chai -p smgp_apps_wcnc > chai.sql
2.µ¼³öÒ»¸ö±í
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
mysqldump -u chai -p smgp_apps_wcnc users>c ......
sessionÎļþ±£´æÔÚ·þÎñÆ÷£¬¶Ôÿ¸ösession¶¼»áËæ»úÉú³ÉÒ»¸öΨһµÄsessionIdÀ´½øÐбêʶ£¬Ò»°ãÈç¹ûûÓÐÉèÖÃsessionµÄÉú´æÖÜÆÚ£¬Ôòsession»á±£´æÔÚÄÚ´æÖУ¬¹Ø±Õä¯ÀÀÆ÷£¬¸Ãsessionid»á×Ô¶¯×¢Ïú£¬ÖØÐÂÇëÇóʱÔò×Ô¶¯ÖØÐ·ÖÅä¡£
Èç¹û¿Í»§¶ËûÓнûÓÃcookie£¬ÔòÔÚʹÓÃsessionʱ£¬cookie»á°èÑÝ´æ´¢sessionIdºÍsessionÉú´æÖÜÆÚµÄ½ÇÉ«¡£¡ ......
PHP³ÉΪÊÀ½çÉÏ×îÁ÷ÐеĽű¾ÓïÑÔÓÐÐí¶àÔÒò£ºÁé»îÐÔ£¬Ò×ÓÃÐԵȵȡ£µ«Í¨³£Ö»ÓÃPHP»òÕ߯äËûÓïÑÔ±àÂë¾Í»áÏԵõ¥µ÷¡¢Öظ´£¬Õâʱºò¾ÍÐèÒªÒ»¸öPHP¿ò¼ÜÀ´´úÌæ³ÌÐòÔ±Íê³ÉÄÇÐ©ÖØ¸´²»±äµÄ²¿·Ö¡£±¾ÎÄͨ¹ý»Ø´ðWhat, When, Why ÒÔ¼° WhichÕâЩÎÊÌ⣬½«¶ÔPHP¿ò¼Ü½øÐÐÈ«Ãæ½âÎö¡£
¡¡¡¡PHP¿ò¼ÜÊÇʲô£¿
¡¡¡¡PHP¿ò¼ÜÌṩÁËÒ»¸öÓÃÒÔ¹¹½¨ ......