IIS+PHP+MySQLÅäÖÃ
ÄÏÈý·½
ÔÚÍøÉÏÕÒÁ˺ܶàIIS+PHPµÄÅäÖõķ½·¨£¬ÊÔ¹ýÖ®ºóºÜ¶à¶¼²»ÄܴﵽЧ¹û¡£ÓÚÊÇ×ܽáÁ˴󲿷ֵÄÎÄÕºó¾ÍµÃ³öÁËÕâÑùµÄ·½·¨£º£¨±¾´Î²Ù×÷ϵͳÒÔWin2000ΪÀý£¬Èç¹ûÄãÒª¸ÄΪÆäËüϵͳ¾Í°Ñϵͳ¸ùĿ¼±äһϾÍOkÁË£©
Ò»¡¢ÏÂÔØ±ØÐëµÄ³ÌÐò£º
(1) Ïȵ½PHPµÄ¹Ù·½ÍøÕ¾ÏÂÔØÒ»¸öPHP£¨±¾ÎľÍÒÔPHP 4.4.2ΪÀý£©¡£ÍøÖ·ÈçÏ£ºhttp://cn.php.net/downloads.php£»
(2) È»ºó¾Íµ½ZendµÄ¹Ù·½ÍøÕ¾ÏÂÔØÒ»¸öZend optimizer£¨±¾ÎÄÒÔZend 2.6.2ΪÀý£©¡£ÍøÖ·ÈçÏ£ºhttp://downloads.zend.com/optimizer/£»
(3) ¼ÈȻҪװPHPµ±È»¾Í×°MySQLÀ²£¨±¾´ÎÒÔMySQL 3.23.49ΪÀý£©£¬µ½¹Ù·½ÍøÕ¾ÉÏÈ¥ÏÂÔØÒ»¸ö°É£¬ÍøÖ·ÈçÏ£ºhttp://www.mysql.com£»
(4) ×îºóÒªÏÂÔØÒ»¸öÓÃÀ´·½±ã¹ÜÀíMySQLµÄ¹¤¾ß£¬ÕâÑùÔÚ¹ÜÀíʱ¿ÉÒÔʰ빦±¶£¬ÏÂÔØµØÖ·ÈçÏ£ºhttp://www.dnsing.com/upfiles/phpmyadmin.rar£»
¶þ¡¢ ÕýʽÅäÖÿªÊ¼£º
(1) ÏȽâѹÏÂÔØ»ØÀ´µÄÈ«²¿Ñ¹Ëõ°ü£¬Ê×ÏȰÑPHPµÄѹËõ°ü½âѹµ½CÅ̵ÄC:\php£¬È»ºó°Ñ·Ö±ð°ÑÎļþ¼Ðϵēphp4ts.dll”¸´ÖƵ½“C:\winnt\system32\”Ï£¬°ÑC:\PHP\sapi\Ŀ¼Ïµēphp4isapi.dll”¸´ÖƵ½“C:\winnt\system32\”Ï£¬½ÓמͰÑC:\PHP\dlls\Ŀ¼ÏµÄËùÓÐ*.dllÎļþ¶¼¿½µ½“C:\winnt\system32\”Ŀ¼Ï£¨Èç¹ûÔÀ´ÓеľÍÏȱ¸·Ý¾ÉµÄÎļþºóÔÙ½øÐи´¸Ç²Ù×÷£©£¬×îºó¾Í°ÑC:\phpĿ¼Ïµēphp.ini-dist”¸ÄΪ“php.ini”¸´ÖƵ½C:\winntĿ¼Ï£¬È»ºó¾Í´ò¿ª°ÑÀïÃæµÄ extension_dir = "./" ¸ÄΪ extension_dir = "c:\php\ext" Ð޸ĺ󱣴棻
(2) È»ºó¾Íµ½¿ØÖÆÃæ°æµÄ¹ÜÀí¹¤¾ßÕÒµ½“Internet ·þÎñ¹ÜÀíÆ÷”£¨¼´IIS£©£¬È»ºó¾ÍÒÀ´Î²Ù×÷£¬ÓÒ»÷ĬÈÏÕ¾µã->µã»÷ÊôÐÔ->Ö÷Ŀ¼->ÅäÖÃ->Ó¦ÓóÌÐòÓ³Éä->Ìí¼Ó->È»ºóÔÚ¿ÉÖ´ÐÐÎļþ´¦ÊäÈ룺C:\WINNT\system32\php4isapi.dll ,À©Õ¹ÃûÊäÈë.PHP£¨ÓÐÒ»¸öµã“.”£©->½Óמ;͵ã»÷ISAPI ɸѡÆ÷->Ìí¼Ó->ÔÚɸѡÆ÷Ãû³Æ´¦ÊäÈëphp£¨Õâ¸öûÓÐÒ»µã“.”£©£¬ÔÚ¿ÉÖ´ÐÐÎļþ´¦ÊäÈ룺C:\WINNT\system32\php4isapi.dll °ÑÈ«²¿¶¼ÅäÖÃÍêºó¾ÍÍ˳öIIS£»
(3) È»ºó£¬ÔÚ¿ªÊ¼²Ëµ¥µÄÔËÐУ¬ÊäÈë net stop iisadmin ÏÈÍ£Ö¹IIS£¬Ä¿Â¼ÊÇΪÁËÖØÆôIISʹ¸Õ²ÅµÄÅäÖÃÉúЧ£¬×îºó¾ÍÔÚÔËÐд¦ÊäÈë net start w3svc ÖØÆôIIS·þÎñ£»µ½ÕâÀïΪֹIIS+PHP¾Í»ù±¾ÉÏÅäÖÃÍêÁË£¬ÏÂÃæ»¹ÓÐ×öµÄ¹¤×÷¾ÍÊǰÑZend×°ÉÏ»¹ÓÐÒ»¸öMySQL·þÎñÆ÷×°ÉÏ£¬²»¹ýÕâЩ¶¼²»ÊÇ
Ïà¹ØÎĵµ£º
http://hi.baidu.com/tianxia_1209/blog/item/a2613822fec7e7f6d6cae267.html
MYSQLµÄʼþÊÇ5.1ÐÂÔö¼ÓµÄ£¬Èç¹ûÏëÌåÑ飬½¨ÒéÉý¼¶°æ±¾¡£
ÖÁÓÚÓï·¨ÎҾͲ»¶à˵ÁË£¬ÊÖ²áÉϽ²µÄºÜÏêϸ£¬ÎÒÀ´ËµËµ¼¸¸öÒªµãÒÔ¼°Ò»Ð©ÊµÀý¡£
×¢ÒâÊÂÏ
1¡¢EVENTȨÏÞÊÇÕë¶ÔģʽµÄ£¨ÔÚMYSQLÖÐÒ²¾ÍÊÇ¿âµÄ¼¶±ð£©£¬²»ÄܶԵ¥¶À±íÀ´¸³ÓèȨÏÞ¡£
2¡¢±ØÐëÔÚ ......
MYSQLÊý¾Ý¿âÖеij£ÓÃSQLÓï¾ä
1¡¢SELECT ²éѯÓï¾äºÍÌõ¼þÓï¾ä
SELECT ²éѯ×Ö¶Î from ±íÃû WHERE Ìõ¼þ
²éѯ×ֶΣº¿ÉÒÔʹÓÃͨÅä·û* ¡¢×Ö¶ÎÃû¡¢×ֶαðÃû
±íÃû£º Êý¾Ý¿â.±íÃû £¬±íÃû
³£ÓÃÌõ¼þ£º = µÈÓÚ ¡¢<>²»µÈÓÚ¡¢in °üº¬ ¡¢&nb ......
¡¡¡¡´Ó PHP 3 ¿ªÊ¼Îª±£´æ¶ÔÏóÌṩÁËÒ»×éÐòÁл¯ºÍ·´ÐòÁл¯µÄº¯Êý£ºserialize¡¢unserialize£¬Ëü¿ÉÒÔ·½±ãµÄ±£´æÊý¾Ý·½±ãµÄ×ö³ÉCACHE£¬¶ø´æ´¢Ìå»ýÒ²±ÈXMLҪСµÄ¶à£¬Ëü½á¹¹Óë JS µÄ JSON ÏàÄâ£¬ÍøÉÏÓÐÒ»×éÓà JS Ä£Äâ serialize ʵÏֵķ½·¨£¬Ê¹ÓÃËü¿ÉÒÔºÍPHP ÔÚÊý¾Ý´«µÝÉϸü½ôÃܵĽáºÏ£®
¡¡¡¡JavaScript °æ±¾£¨stable£©£ ......
Ò»¡¢MySql¼ò½é¸ÅÒª
MySQLÊÇÒ»¸öСÐ͹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ£¬¿ª·¢ÕßΪÈðµäMySQL AB¹«Ë¾£¬ºóÀ´
±»Sun¹«Ë¾ÊÕ¹º£¬ÏÖÔÚÕýÔÚ±»¼×¹ÇÎÄÊÕ¹º£¬Ö§³ÖFreeBSD¡¢Linux¡¢MAC¡¢Windows
µÈ¶àÖÖ²Ù×÷ϵͳ ÓëÆäËûµÄ´óÐÍÊý¾Ý¿âÀýÈçOracle¡¢DB2¡¢SQL ServerµÈÏà±È¹¦ÄÜÉÔÈõ
һЩ ÌâÍâ»°£ºPostgresql&n ......