Windowsϰ²×°×îеÄApache+PHP+MySQLÖ¸ÄÏ
´ËÎÄյݲװ·½·¨ÊÊÓÃÓÚ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
* 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
×ÓĿ¼ÖÐµÄ httpd.conf
Îļþ¡£
1.
ÕÒµ½£º
DocumentRoot “xxxxxxx&rd
Ïà¹ØÎĵµ£º
³£ÓÃPHPÔËËãÀàÐͽéÉÜÓëÓ¦ÓÃ
1¡¢ËãÊõÔËËã
Àý£º
5 * 6 - 12
2*(28+1)
×¢£ºËãÊõÔËËã×ñÑÊýѧÔËËã¹æÔò
´Ó×óµ½ÓÒ£¬ÏÈËã³Ë³ýºóËã¼Ó¼õ£¬Óöµ½À¨ºÅÏÈËãÀ¨ºÅÄÚ
2¡¢¸³ÖµÔËËã
Àý£º
$a=1;
$a+=2;
$a*=3;
......
ÐÞ¸ÄrootÃÜÂëµÄʱºò°´ÕÕÍøÉϵÄ˵µÄ¾ÓȻɵɵµÄÖ´ÐÐÁËupdate user set password="asdf" where user="root"£»Ö´ÐÐÖ®ºó·¢ÏÖÃÜÂë´íÁË£¬½øÈ¥²»ÁË£¬ÓÚÊÇÕÛÌÚÁ˰ëÌ죬·¢ÏÖmysqlµÄÃÜÂëÊǼÓÃܵIJ»ÊÇÃ÷ÎÄ´æ´¢µÄ£¬ËùÒԸĵÄʱºòÐèÒªÕâÑùset password=password("asdf")¡£´íÎóÒѾ·¢ÉúÁË£¬ÓÚÊǾͰ´ÕÕÏÂÃæµÄ· ......
http://www.cnblogs.com/rethink/archive/2009/10/09/1579634.html
mysql cache¹¦ÄÜ·ÖÎö£º
1
mysqlµÄcache¹¦ÄܵÄkeyµÄÉú³ÉÔÀíÊÇ£º°ÑselectÓï¾ä°´ÕÕÒ»¶¨µÄhash¹æÔòÉú³ÉΨһµÄkey£¬selectµÄ½á¹ûÉú³Évalue£¬¼´key=>value¡£ËùÒÔ¶ÔÓÚcache¶øÑÔ£¬selectÓï¾äÊÇÇø·Ö´óСдµÄ£¬Ò²Çø·Ö¿Õ¸ñµÄ¡£Á½¸öselectÓï¾ä±ØÐëÍêÍêȫȫһÖ ......
ĬÈϵ¼³öµ½µ±Ç°Ä¿Â¼ÖÐ
¡¡¡¡1.µ¼³öÕû¸öÊý¾Ý¿â
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
¡¡¡¡2.µ¼³öÒ»¸ö±í
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
¡¡¡¡mysqldum ......
PHPÑ»·Óï¾äµÄ½éÉÜÓëÓ¦ÓÃ
1¡¢break n Ñ»·¿ØÖÆÓï¾ä
Break Ìø³öÒ»²ã£¨±¾´Î£©Ñ»·;break n Ìø³ön²ãÑ»·;
2.Continue:continue ÔÚÑ»·½á¹¹ÓÃÓÃÀ´Ìø¹ý±¾´ÎÑ»·ÖÐÊ£ÓàµÄ´úÂë²¢ÔÚÌõ¼þÇóÖµÎªÕæÊ±¿ªÊ¼Ö´ÐÐÏÂÒ»´ÎÑ»·¡£×¢:×¢ÒâÔÚ PHP ÖÐ switch Óï¾ä±»ÈÏΪÊÇ¿ÉÒÔʹÓà con ......