ÔÚwindows7ÖдApache+PHP+MySQLƽ̨
½ñÌì¸ãÁËÒ»ÏÂÎ磬ÔÚµçÄÔÉϴÁËAPMƽ̨
ϵͳ:Windows7 Professional EN
Apache2.2.9:http://archive.apache.org/dist/httpd/binaries/win32/apache_2.2.9-win32-x86-openssl-0.9.8h-r2.msi
PHP5.3.1:http://windows.php.net/downloads/releases/php-5.3.1-Win32-VC6-x86.zip
MySQL5.1.42:http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.1/mysql-5.1.42-win32.msi
×¢Ò⣺PHP5.3.1ÓжàÖÖ£¬Ò»ÖÖÊÇfor VC9µÄ£¬ÔËÐл·¾³ÊÇIIS¶ø²»ÊÇApache£¬Èç¹ûÒªÓÃApache£¬¾ÍÖ»ÄÜÑ¡VC6µÄ¡£
ΪÁ˽ñºóÒÆÖ²µÄ·½±ã£¬ÎÒÖØÐ¶¨ÒåÁËĿ¼½á¹¹£º
<F:\>
|--<www>
| |--<server> # °²×° Web ·þÎñ³ÌÐò
| | |--<apache> # Apache°²×°Ä¿Â¼
| | |--<mysql> # MySql°²×°Ä¿Â¼
| | |--<php> # PHP°²×°Ä¿Â¼
| |
| |--<web> # ÍøÕ¾ÄÚÈÝ
| | |--<PHP³ÌÐò>
ÔÚ Windows7 ϰ²×° Apache 2.2.9
ÔËÐÐ apache 2.2.4 µÄ°²×°³ÌÐò£¬¸ù¾ÝÌáʾһ· Next ¼´¿É¡£×¢ÒâÔÚ Server Information µÄ Network Domain¡¢Server Name ×Ö¶ÎÌîÉÏ localhost£¬ÎÒ»¹ÖØÐÂÉ趨ÁËapacheµÄ¶Ë¿ÚºÅΪ8080¡£
ÔÚ°²×°ÀàÐ͵ÄλÖÃÑ¡ Custom£¬È»ºó¸Ä±ä°²×°Â·¾¶£¨ÎÒµÄĿ¼ÊÇ F:/www/server/apache£©¡£È»ºó¸ù¾ÝÌáʾһ· Next Íê³É¼´¿É¡£
È»ºóÔÚÃüÁîÌáʾÐÐÖдòÈëÏÂÁÐÃüÁÐèÒªÒÔ¹ÜÀíÔ±Éí·Ý´ò¿ªÃüÁîÌáʾÐУ©£º
# °²×° apache ·þÎñ£º
F:\www\server\apache\bin\> httpd -k install
#Æô¶¯ apahce ·þÎñ
F:\www\server\apache\bin\> httpd -k start
ÔÚ Windows7 ϰ²×° php 5.3.1
½«ÏÂÔØµÄ ZIP °üÖ±½Ó½âѹ£¬ÎÒÖ±½Ó½«zip Îļþ½âѹµ½ F:\www\server\php Ŀ¼ÏÂÃæ¡£°²×° php ²»½¨ÒéʹÓà win32 °²×°³ÌÐò(Ö÷ÒªÊÇÒÔºó°²×°À©Õ¹Âé·³£©¡£
ÔÚ×ÊÔ´¹ÜÀíÆ
Ïà¹ØÎĵµ£º
°²×°µÄOSΪSolaris10,mysql °æ±¾ÊÇ5.1.38
Ò»¡¢Ê¹ÓÃRPM°ü½øÐа²×°
Ê×ÏÈ¿ÉÒÔ´Ó°²×°¹âÅÌÖлòÕßµ½mysqlµÄÍøÕ¾ÉÏÏÂÔØ¶ÔÓ¦°æ±¾µÄrpm°üÈçÏ£º
MySQL-server-community-5.1.38-0.rhel5.i386.rpm
MySQL-client-community-5.1.38-0.rhel5.i386.rpm
½Ó×ÅÎÒÃÇ¿ÉÒÔʹÓÃrpmÃü ......
ÔÀí
QueryCache(ÏÂÃæ¼ò³ÆQC)ÊǸù¾ÝSQLÓï¾äÀ´cacheµÄ¡£Ò»¸öSQL²éѯÈç¹ûÒÔselect¿ªÍ·£¬ÄÇôMySQL·þÎñÆ÷½«³¢ÊÔ¶ÔÆäʹÓÃ
QC¡£Ã¿¸öCache¶¼ÊÇÒÔSQLÎı¾×÷ΪkeyÀ´´æµÄ¡£ÔÚÓ¦ÓÃQC֮ǰ£¬SQLÎı¾²»»á±»×÷Èκδ¦Àí¡£Ò²¾ÍÊÇ˵£¬Á½¸öSQLÓï¾ä£¬Ö»ÒªÏà²îÄÄÅÂÊÇÒ»¸ö×Ö·û£¨ÀýÈç´óСд²»Ò»Ñù£»¶àÒ»¸ö¿Õ¸ñµÈ£©£¬ÄÇôÕâÁ½¸öSQL½«Ê¹Óò»Í¬µÄÒ» ......
1. ½èÓñðÈ˵ÄÓòÃû×÷¸¸ÓòÃû.
2. ½èÓô˿ռ佨Á¢Ò»phpÎļþ,´Ëphp¹¦ÄÜΪ,ÌṩµØÖ·À¸µÄij¸ö²ÎÊýʱ,¼ì²â´Ë²ÎÊý,ÕýÈ·,¾Í»ñÈ¡µ±Ç°µÄÔ¶³ÌipдÈëÒ»js.
3. ÆäËüÈË·ÃÎÊ´Ëphp,Ö±½Ó·ÃÎÊ,²¢Ã»ÓÐÌṩ²ÎÊý,ËùÒÔ,Ö±½ÓÔØÈëÉÏÃæµÄjs,¼´Ö±½ÓתÏòµ½Ô¶³Ìip,ÕâÑù¾Í´ïµ½ ¸üÐÂ/Ìø×ª¹¦ÄÜÁË.ͬʱ¿ÉÒÔÀûÓÃjsµÄimg onerrʼþ¼ì²âÔ¶³ÌipÊÇ·ñÕýÈ·, ......
ÎÒ´ÓÊÂÁË6Äê¶àµÄ±à³Ì¹¤×÷£¬ÔÚÕâ֮ǰ×öÁ˽«½ü2ÄêµÄ´¿HTML+CSSµÄÍøÒ³ÖÆ×÷ºÍÉè¼Æ¡£±¾²©¿ÍºÜ¶à´ÎÌáµ½µÄphpcn5.0£¬ÊÇÒ»¿î¼ò½àʵÓõÄÎı¾¹¤¾ß¡£¶ÔÓÚPHP±à³ÌÓÐÊ®·ÖºÃµÄÖ§³Ö£¬¼¸ºõµ½ÁËÍêÃÀ¡£ÎÒµÄPHPÊ×Ñ¡±à³Ì¹¤¾ßÊÇphpcn5.0£¬Ê¹ÓÃphpcn5.0×öPHP±à³Ì£¬¼¸ºõ²»ÓÃÔÙÓÃÆäËüµÄÎı¾¹¤¾ß¡£¶ÔÓÚPHP±à³Ì£¬phpcn5.0ÓÐÕâЩÓŵ㣺
1 ......
Ò»¡¢ÊÂÎñ´¦Àí£¨myisamÒýÇæ²»Ö§³ÖÊÂÎñ£¬innodbÒýÇæÖ§³ÖÊÂÎñ£©
£¨1£©start transaction
£¨2£©commit
£¨3£©rollback£¬rollback to [savepoint name]
£¨4£©savepoint [savepoint name]
£¨5£©set autocommit=0 or 1
£¨6£©release savepoint [savepoint name]
×¢Ò⣺create¡¢dropµÈ²Ù×÷£¬²»ÄÜ»ØÍË
¶þ¡¢×Ö·û¼¯
1.×Ö·û±àÂë ......