windows2003+iis6+php+mysql ·þÎñÆ÷ÅäÖÃ
ÔÚÍøÉÏ¿´Á˺ܶà¹ØÓÚwindows2003+iis6+php+mysql ·þÎñÆ÷ÅäÖõÄÎÄÕ£¬´óÌåÉ϶¼ÊÇ»¥Ïà³Ï®£¬²»¹ýһЩ¹«¹²µÄÐÅÏ¢»¹ÊǺÜÕýÈ·µÄ£¬µ«ÊÇÕë¶ÔһЩÌرðµÄ»úÆ÷»òÕßÒòΪ¸öÈ˲»Í¬µÄÅäÖÃ×ܲ»ÄÜ°´ÕÕÎÄÕµÄÄÚÈݲÙ×÷³É¹¦£¬ÏÂÃæ˵һÖÖ½ÏΪ¼òµ¥µÄ²Ù×÷·½·¨£¬²½ÖèÈçÏ£º
1.iis°²×°£¨ÂÔ£©
2.ÏÂÔØAppServ²¢°²×°
3.ÔÚc:\½¨php5Îļþ¼Ð£¬È»ºóÔÙphp5Îļþ¼ÐϽ¨php.iniÎļþ£¨¾ÍÊÇ´ÓAppServ|php5Ï¿½±´¹ýÀ´£©
4.ÐÞ¸Äphp.ini,ÕÒµ½ register_globals = Off ¸ÄΪ register_globals = On
ÕÒµ½ extension_dir = "./" ¸ÄΪ extension_dir = "F:\php\ext"
ÕÒµ½
;extension=php_dbase.dll
;extension=php_gd2.dll £¨ÕâÊÇÓÃÀ´Ö§³ÖGD¿âµÄ£©
;extension=php_mbstring.dll £¨Õⲻѡһ°ãÓÃPHPMYADMIN»á³öºìÉ«Ìáʾ£¬¹Ê±ØÑ¡£©
;extension=php_mcrypt.dll
;extension=php_mssql.dll £¨Õâ¸öÊÇÓÃÀ´Ö§³ÖMSSQLµÄ£¬¿ÉÑ¡£©
;extension=php_mysql.dll £¨Õâ¸öÊÇÓÃÀ´Ö§³ÖMYSQLµÄ£¬ÒªÖ§³ÖMYSQL±ØÑ¡£©
½«ÕâЩÎÄ×ÖÇ°ÃæµÄ"£»"È¥µô£¬ÆäËûµÄÄãÐèÒªµÄÒ²¿ÉÒÔÈ¥µôÇ°ÃæµÄ;È»ºó¹Ø±Õ±£´æ¸ÃÎļþ¡£
5.ÉèÖÃiis£¬ÈÃÆäÖ§³Öphp£¬
1)´ò¿ª¿ØÖÆÃæ°å→¹ÜÀí¹¤¾ß→InternetÐÅÏ¢·þÎñ(IIS)¹ÜÀíÆ÷
2)ÓÒ»÷ÐèÒªPHP¹¦ÄܵÄÍøÕ¾£¬Ñ¡ÔñÊôÐÔ
3)µ¥»÷“ISAPIɸѡÆ÷”Ñ¡Ï£¬ÔÙµã»÷“Ìí¼Ó”°´Å¥£¬ÔÚµ¯³öµÄ“ɸѡÆ÷ÊôÐÔ”¶Ô»°¿òÖУ¬ÒÀ´ÎÌîÈëɸѡÆ÷Ãû³Æ“php”£¬¿ÉÖ´ÐÐÎļþ“F:\php\php5isapi.dll”×îºóµã»÷“È·¶¨”°´Å¥Í˳ö¡£
4)µ¥»÷“Ö÷Ŀ¼”Ñ¡Ï£¬Ñ¡Ôñ“ÅäÖÔ°´Å¥£¬¿ÉÖ´ÐÐÎļþÖÐÊäÈë“F:\php\php5isapi.dll”£¬À©Õ¹ÃûÖÐÊäÈë“.PHP”
5)µ¥»÷“Îĵµ”Ñ¡Ï£¬Ìí¼ÓĬÈÏÖ÷ҳΪ“index.php”
6)ÔÚIIS¹ÜÀíÆ÷Öе¥»÷“Web·þÎñÀ©Õ¹”£¬ÔÙµã»÷“Ìí¼ÓÒ»¸öÐ嵀 Web ·þÎñÀ©Õ¹”£¬ÉèÖÃÀ©Õ¹ÃûΪ“.PHP”£¬Ìí¼ÓÒªÇóµÄÎļþΪ“F:\php\php5isapi.dll”£¬²¢Ñ¡ÖГÉèÖÃÀ©Õ¹×´Ì¬ÎªÔÊÐ픸´Ñ¡¿ò¡£
7)¿ªÊ¼²Ëµ¥→ÔËÐУ¬ÊäÈë“CMD”ÃüÁ½øÈëÃüÁîÐУ¬ÒÀ´ÎÊäÈëÒÔÏÂÃüÁî¡£
net stop w3svc
net stop iisadmin
net start w3svc
8)ÔÚFÅ̵ÄWEBĿ¼ÏÂн¨Ò»¸öÃûΪ“phpinfo.php”µÄÎļþ£¬ÄÚÈÝÈçÏ£º
<?php phpinfo();?>
6.ÖØÆô»úÆ÷
µ½´ËΪֹһÇд󹦸æ³É£¡
Ïà¹ØÎĵµ£º
ÓÐÖÖ˵·¨£ºPHPÊÇ×î¼òµ¥µÄÍøÕ¾¿ª·¢ÓïÑÔ£¬ÕâÖÖ¹ÛµãÊÇ´íµÄ¡£
ľͷ±È»ýľ¼òµ¥£¬µ«Ä¾½³ºÍº¢×ӵIJî±ðÊÇľ½³ÄÜ°ÑľͷºÍ»ýľ¶¼±ä³É·¿×Ó£¬º¢×ÓÖ»ÄÜ°Ñ»ýľ±ä³É·¿×Ó£¬¶ÔÓÚľͷËûÃÇÖ»ÄÜÔÚÉÏÃ滸ö·¿×Ó¶øÒÑ¡£
PHP¾ÍÏñľͷ£¬²ËÄñÖ»ÄÜÓÃËü×öµã¼òµ¥µÄÊÂÇ飬¸ßÊ־ͻá°ÑËü±ä³ÉÎÞËù²»ÄÜ¡£
¼ÈÈ»PHP¼òµ¥ÓÖÊǸßÊÖìÅÒ«µÄ¶«Î÷£¬ÄÇÔõôѧ²ÅÄܱä³É¸ ......
1.ÏÂÔØ°²×°mcrypt
ÏÈÈ¥http://www.sourceforge.netÏÂÔØLibmcrypt,mhash,mcrypt°²×°°ü
2 .ÏÈ°²×°Libmcrypt
#tar -zxvf libmcrypt-2.5.8.tar.gz
#cd libmcrypt-2.5.8
#./configure
#make
#make install
˵Ã÷£ºlibmcriptĬÈÏ°²×°ÔÚ/usr/local
3.°²×°mhash
#tar -zxvf mhash-0.9.9.9.tar.gz
#cd mhash-0.9.9.9
#./ ......
´úÂëinterface StringSearchable
{
public function search($substring, $buffer);
}
class BoyerMooreStringSearch implements StringSearchable
{
public $substring = null;
public ......
²»ÖªµÀÊDz»ÊÇÇý¶¯¼ÓÔØÓÐÎÊÌ⣬ÔÚMyEclipseÖÐдÁ˼òµ¥µÄÊý¾Ý¿â²âÊÔ³ÌÐòÕÒ²»µ½Çý¶¯À࣬ϣÍû´óϺÄܸøÓè°ïÖú£¬Ð»ÁË¡£
ÑÏÖØ: Servlet.service() for servlet jsp threw exception
java.lang.ClassNotFoundException: org.aspectj.lang.Signature
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClas ......
http://immike.net/blog/2007/04/09/how-not-to-optimize-a-mysql-query/
ÕâƪÎÄÕ½¨Ò飺
£¨1£©²»ÒªÊ¹ÓÃһЩmysqlµÄtip£¬È磺SQL_SMALL_RESULT, HIGH/LOW_PRIORITY, and INSERT DELAYED£¬STRAIGHT_JOIN£¬³ý·ÇûÓÐÆäËû·½·¨£¬ÒòΪÕâÑùʧȥÁËSQLµÄ¿ÉÒÆÖ²ÐÔ
£¨2£©Êʵ±¶Ô±í½øÐÐË÷Òý
£¨3£©±ÜÃâ¶Ô²»±ØÒªÊý¾ÝµÄ²éѯ
£¨4£©´¦Àí× ......