windowsÏÂPHP5+APACHE+MYSQLÍêÕûÅäÖÃ
Èí¼þ°æ±¾:
php-5.2.13-Win32
apache_2.2.9-win32-x86-no_ssl-r2.msi(×¢Ò⣺APACHE 2.2.X°æ±¾ÒÔÉÏÒªÔö¼Ó²å¼þ²ÅÖ§³ÖPHP 5µÄ)
mysql-5.1.44-win32.msi
ÏÈ×°µÄphp5,Ö±½Ó½âѹÎļþµ½C:\php(°²×°µ½ÄÄÀï²¢²»»áÓÐÓ°Ï죬ƾ¸öÈËϲºÅ£¬±¾ÎÄÖеÄËùÓз¾¶¶¼ÒÔÎҵݲװ·¾¶£¬Çë´ó¼ÒÔÚ×Ô¼ºµÄ»úÆ÷ÉÏ°²×°µÄʱºò×¢ÒâÐÞ¸ÄΪ×Ô¼ºµÄ·¾¶)
½Ó×Å°²×°APACHE£¬ÎÒÖ±½Ó°ÑËü×°µ½CÅ̸ùĿ¼Ï£¬ÔÚ°²×°¹ý³ÌÖÐ,»á³öÏÖ3¸öÎı¾¿ò£¬ÉÏÃæÁ½¸öÊäÈë±¾»úIP£¬×îÏÂÃæµÄÊäÈëEMAIL£¬°²×°Íê±Ï¡£ÏÖÔÚ±à¼..\Apache2\conf\ϵÄhttpd.confÎļþ¡£ÓüÇʱ¾´ò¿ª¸ÃÎļþ£¬ÔÚ×îºóÌíÉÏÕâÁ½ÐдúÂ룺
LoadModule php5_module "C:/php/php5apache2.dll"
AddType application/x-httpd-php .php
(php½âѹËõºóĿ¼ÀïÓÐÈý¸öÕâÑùµÄÎļþ£ºphp5apache.dll£¬php5apache2.dll£¬php5apache2_2.dll£» ÕâÈý¸öÎļþ·Ö±ð¶ÔÓ¦apacheµÄ°æ±¾Îª£ºApache1£¬Apache2.1.*£¬Apache2.2.*¡£ËùÒÔÔÚ¼ÓÔØÄ£¿éµÄʱºò£¬²»Äܸã´í°æ±¾£¬·ñÔò¾Í»áÌáʾÉÏÃæµÄ´íÎóÁË¡£)
ÔÚC:\Ŀ¼Ï½¨Á¢ÁËÒ»¸öwwwµÄĿ¼ÓÃÓÚ´æ·ÅÎÒµÄÕ¾µãÎļþ£¬ÔÚhttpd.confÀïÕÒµ½ÕâÑùÒ»¾ä»°£ºDocumentRoot "C:/Apache2/htdocs"¸Ä³ÉÁËDocumentRoot "C:/www"¡£ÕâÑù£¬¾Í½«Ö÷Ŀ¼ÉèÖóÉÁËC:\www¡£Èç¹ûÄã²»Ïë¸ü¸ÄÖ÷Ŀ¼λÖ㬿ÉÒÔ²»¸ü¸Ä´ËÏî¡£
ÐÞ¸ÄĿ¼µÄĬÈÏÊ×Ò³£º
ÕÒµ½DirectoryIndex ºóÃæдÉÏÄãÏëÉèÖÃΪÊ×Ò³µÄÎļþÃû£¬È磺index.html index.phpµÈ¡£
ÓïÑÔÓÅÏȼ¶£¬ÕÒµ½ÏÂÁÐÓï¾ä
LanguagePriority zh-CN zh-TW en ca cs da de el eo es et fr he hr it ja ko ltz nl nn no pl pt pt-BR ru sv °ÑÖÐÎÄ£¨zh-CN zh-TW£©µÄ²¿·Ö¼ôÇзŵ½Ç°Ã棨Ҳ¾ÍÊǽ«ÔÀ´ÎļþÖеÄÏàÓ¦²¿·Ö¸Ä³ÉÈçÉϵġ£
ÆäËûҲûʲôºÃ¸Ä¶¯µÄ¡£APACHµÄÅäÖþ͵½ÕâÀï¡£½Ó׎²PHPµÄÅäÖá£
°Ñphp.ini-dist¸´ÖƵ½C:\windows ϸÄÃûΪ php.ini£¨×°¹ýphpµÄ¶¼×ö¹ý°É£©È»ºóÐÞ¸ÄÁ˼¸¸öµØ·½£º
ÔÚData HandlingÏÂÕÒµ½post_max_size = 8M
ÕâÊÇPHP½«½ÓÊܵÄPOSTÊý¾Ý×î´ó´óС£¬¿É¸ü¸ÄΪ20M¡£
ÔÚPaths and DirectoriesÏÂÕÒµ½extension_dir=
ÕâÀïÉèÖõÄÊÇPHPËÑË÷À©Õ¹¿âµÄλÖ㬽«Æä·¾¶ÉèΪextensionsÎļþ¼ÐµÄλÖ㬼´¸Ä³É£º
extension_dir= "C:\php\ext"
ÔÚFile UploadsÏÂÕÒµ½upload_max_filesize = 2M£¬ÔÊÐíÉÏ´«µÄµÄ×î´óÎļþ´óС
¿É¸ü¸ÄΪ20M¡£
Dynamic ExtensionsÕâÀïÊÇPHPÀ©Õ¹ÉèÖò¿·Ö£¬ÁгöÁËPHPËùÓеĿÉÖ§³ÖÀ©Õ¹£¬Ç°Ã涼¼ÓÁË·ÖºÅ×¢ÊÍ£¬±íʾĿǰPHPÅäÖò»Ö§³ÖÀ©Õ¹£¬ÎÒÃÇ¿ÉÒÔ½«·ÖºÅÈ¥µôÈÃPHPÖ§³Ö¸ÃÀ
Ïà¹ØÎĵµ£º
½üÈÕ³¢ÊÔ½«Ò»¸öphp³ÌÐòÒÔµ¥µãµÇ¼·½Ê½ºÍÔÓеÄϵͳÕûºÏÔÚÒ»Æð¡£
ÑéÖ¤·þÎñÆ÷Ñ¡ÓõÄÊÇCAS£¬ÆäÌṩÓÐÏàÓ¦µÄphp¿Í»§¶Ë¡£
Õû¸ö¹ý³ÌÈçÏ£º
1¡¢´î½¨CAS·þÎñÆ÷
2¡¢´î½¨phpÓ¦Óû·¾³
3¡¢ÏÂÔØÏàÓ¦µÄphp¿â
4¡¢ÐÞ¸ÄphpÓ¦Óû·¾³ÅäÖÃ
5¡¢²âÊÔcasµÄphp¿Í»§¶Ë
6¡¢ÐÞ¸ÄÔÓеijÌÐò£¬Ê¹ÓÃCASÀ´Íê³ÉµÇ¼¡£
¾ßÌåϸ½ÚÈçÏ£º
Ò» ......
±¾Ê¾Àýͨ¹ý while...end while Ñ»·¿ØÖÆÓαêÀ´ÊµÏÖ²åÈë±í¼Ç¼¡£
DROP PROCEDURE IF exists pro_initCategoryForTradingEntity;
create procedure pro_initCategoryForTradingEntity(tradingEntityId int)
begin
declare f_parent,entityId int;
declare b int default 0; ......
ÓÃMySQL´´½¨Êý¾Ý¿âºÍÊý¾Ý¿â±í
Á˽âÁËһЩ×î»ù±¾µÄ²Ù×÷ÃüÁîºó£¬ÎÒÃÇÔÙÀ´Ñ§Ï°ÈçºÎ´´½¨Ò»¸öÊý¾Ý¿âºÍÊý¾Ý¿â±í¡£
¡¡¡¡1¡¢Ê¹ÓÃSHOWÓï¾äÕÒ³öÔÚ·þÎñÆ÷Éϵ±Ç°´æÔÚʲôÊý¾Ý¿â£º
mysql> SHOW DATABASES; +----------+
| Database | +----------+ | mysql |
| test | +----------+ 3 rows in set (0.00 sec)
¡¡¡¡2¡¢´´½¨Ò ......