IIS6.0+PHP+MYSQLÅäÖÃ
Win2003server ϼÜÉèPHPWind²úÆ·»·¾³
°²×°Ç°×¼±¸:1¡¢°²×°ºÃiis6
2¡¢ÏÂÔØphp»·¾³µÄÏàÓ¦µÄÈí¼þ
ÍÆ¼öÅäÖãºphp-5.2.6-Win32.zip
¡¡¡¡¡¡¡¡¡¡mysql-5.0.18-win32.zip
¡¡¡¡¡¡¡¡¡¡ZendOptimizer-3.3.3-Windows-i386.exe
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
MysqlµÄÏÂÔØµØÖ·
http://download.mysql.cn/download_file/zip/5.0/mysql-5.0.18-win32.zip
phpµÄÏÂÔØµØÖ·:
http://cn2.php.net/distributions/php-5.2.6-Win32.zip
ZendµÄÏÂÔØµØÖ·:
http://downloads.phpchina.com/zend/optimizer/3.3.3/ZendOptimizer-3.3.3-Windows-i386.exe
µÚÒ»²½¡¢°²×°php
½âѹphp-5.2.6-Win32.zipΪphp-5.2.6-Win32£¬È»ºó°ÑÆäphp-5.2.6-Win32¸ü»»Îªphp£¬¿½±´µ½EÅÌ(¿ÉÑ¡)
°ÑE:/php/ϵÄphp.ini-distÖØÃüÃû¸ÄΪphp.ini,´ò¿ªphp.ini,
²éÕÒext,°Ñext = "./"¸ÄΪextension_dir = "E:\php\ext"
°ÑÏÂÃæÕâЩÀ©Õ¹¹¦ÄÜÖеÄ
;extension=php_gd2.dll
;extension=php_mbstring.dll
;extension=php_mysql.dll
Ç°ÃæµÄ;×¢Ê͸øÈ¥µô,
È»ºó¿½±´php.iniµ½c:/windowsĿ¼
µÚ¶þ²½¡¢iis6ϼÓÔØphpÀ©Õ¹
´ò¿ªIIS¹ÜÀíÆ÷,µãweb·þÎñÀ©Õ¹--Ìí¼ÓÒ»¸öеÄweb·þÎñÀ©Õ¹,À©Õ¹ÃûΪphp,ÔÚÒªÇóµÄÎļþÄÄÀï,Ìí¼ÓÒ»¸öÎļþ·¾¶ÎªE:\php\php5isapi.dllµÄÎļþ,ÔÚÉèÖÃÀ©Õ¹×´Ì¬ÎªÔÊÐíÄÄÀï´ò¹³,
ÈçÏÂͼËùʾ
ÔÚÍøÕ¾ÉϵãÓÒ¼ü--ÊôÐÔ,ÈçÏÂͼËùʾ:
ÔÚISAPIɸѡÆ÷ÄÇÀïÌí¼ÓÒ»¸öеÄɸѡÆ÷,Ãû³Æ:php,¿ÉÖ´ÐÐÎļþ»¹ÊÇÉÏÃæµÄE:\php\php5isapi.dll
ÔÚÖ÷Ŀ¼,Ö´ÐÐȨÏÞÄÇÀï,¸ÄΪ½Å±¾ºÍ¿ÉÖ´ÐÐÎļþ,µãÅäÖÃ,ÈçÏÂͼËùʾ:
È»ºóÔÙµã»÷<ÅäÖÃ>£¬Ìí¼ÓphpÓ¦ÓóÌÐòÀ©Õ¹ÃûÓ³Éä
×îºóµã»÷È·¶¨¡£
¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢¡¢
ÅäÖÃĬÈÏÕ¾µã
ÏÈÔÚEÅ̽¨Á¢wwwrootĿ¼
ÓÒ¼ü ĬÈÏÕ¾µã--->
µã»÷<ÊôÐÔ>
°Ñ±¾µØÂ·¾¶ÐÞ¸ÄΪ E:\wwwrootĿ¼
Ö´ÐÐȨÏÞ ÐÞ¸ÄΪ ½Å±¾ºÍ¿ÉÖ´ÐÐÎļþ
Æä´Î µã»÷ <Îĵµ> Ñ¡Ï  
Ïà¹ØÎĵµ£º
Á¬½Ó£ºmysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë £¨×¢:uÓëroot¿ÉÒÔ²»Óüӿոñ£¬ÆäËüÒ²Ò»Ñù£©
¶Ï¿ª£ºexit £¨»Ø³µ£©
´´½¨ÊÚȨ£ºgrant select on Êý¾Ý¿â.* to Óû§Ãû@µÇ¼Ö÷»ú identified by \"ÃÜÂë\"
ÐÞ¸ÄÃÜÂ룺mysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
ɾ³ýÊÚȨ: revoke select,insert,update,delete om *.* from ......
ÿһÖÖÓïÑÔ¶¼ÓÐ×Ô¼ºµÄ×Ô¶¯À¬»ø»ØÊÕ»úÖÆ£¬ÈóÌÐòÔ±²»±Ø¹ý·Ö¹ØÐijÌÐòÄÚ´æ·ÖÅ䣬µ«ÊÇÔÚOOPÖУ¬ÓÐЩ¶ÔÏóÐèÒªÏÔʽµÄÏú»Ù£»·ÀÖ¹³ÌÐòÖ´ÐÐÄÚ´æÒç³ö¡£
Ò»¡¢PHP À¬»ø»ØÊÕ»úÖÆ(Garbage Collector ¼ò³ÆGC)
ÔÚPHPÖУ¬Ã»ÓÐÈκαäÁ¿Ö¸ÏòÕâ¸ö¶ÔÏóʱ£¬Õâ¸ö¶ÔÏó¾Í³ÉΪÀ¬»ø¡£PHP»á½«ÆäÔÚÄÚ´æÖÐÏú»Ù£»ÕâÊÇPHP µÄGCÀ¬»ø´¦Àí»úÖÆ£¬·ÀÖ¹ÄÚ´æÒç³ö¡ ......
½ñÌìÓöµ½ÁËÒ»¸ö¹ÖÎÊÌ⣬ÎÒÓÃ$fp=fopen("access_log.txt","ab")´ò¿ªÒ»¸öÎļþºó¿ªÊ¼ÍùÀïÃæÐ´Êý¾Ý£¬Ð´µÄÄÚÈÝÊÇ 'XXX\nXXX\n'£»
µ«ÊÇÆæ¹ÖµÄÊÇ ²»¹ÜÎÒÔõôÍùÀïÃæÐ´ ËûÊDz»»»ÐÐ,¼Çʱ¾Àï¼Ç¼µÄÊý¾Ý ¾ÍÊÇ 'xxx\nxxx\n'£¬
ºÜÊÇÄÕ»ð£¬È¥ÍøÉÏËѼ¯×ÊÁÏ£¬ÓеÄ˵¸Ä³É'\r\n'ʲôµÄ£¬½á¹ûÊÇд½øÈ¥ºó»¹ÊÇ 'xxx\r\nxx ......
½ñÌìȷʵÊÇÎÞÁÄÁË£¬Ð´ÁËÒ»¸ö±¸·ÝÈËÈËÍøµÄÈÕÖ¾£¬µ½±¾µØhtmlµÄÀà¡£
Ö÷ÒªÊÇcURLµÇ¼£¬ÕýÔò½âÎöÒ³Ãæ¡£
ʹÓ÷½·¨£¬×îºóÄǸö½Å±¾µÄ×îºóÁ½Ðиĵô£¬ÄãÖªµÀµÄ¡£»òÕßÖØÐÂдһ¸öÔËÐнű¾£º
<?php
include("renren.php");
$test = new renren("ÄãµÄÈËÈËÍøÕ˺Å","ÄãµÄÈËÈËÍøÃÜÂë");
$test->do ......
½ñÌ쿪¶àÒ»¸öÓ¦ÓÃÔÚ APP SERVER ÉÏ£¬±¨¸æÒ»¸ö´íÎó:
ERROR 1040 (00000): Too many connections
Õâµ¹ÊÇ´ÓÀ´Ã»Åöµ½¹ý£¬²»¹ýÔÚ console Ï¿ÉÒÔÓà root µÇ¼ £¨console ÏÂÓÃÆäËûÓû§Ò²²»¿ÉµÇ¼£¬Too many connections£©
mysql -uroot -p
mysql > show processlist;
...
ÕâÀïÁÐÁË100¸öÁ´½Ó£¡£¡ÆäÖÐÖ»ÓÐ2¸öÁ´½ÓÊÇQ ......