Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚ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 °²×°³ÌÐò(Ö÷ÒªÊÇÒÔºó°²×°À©Õ¹Âé·³£©¡£
ÔÚ×ÊÔ´¹ÜÀíÆ


Ïà¹ØÎĵµ£º

mysqlµÄÈýÖÖ°²×°·½Ê½

°²×°µÄ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Ãü ......

mysqlÖвåÈëÒ»Ìõ¼Ç¼·µ»Ø¸Ã¼Ç¼id

1.select max(id) from user;
2.select last_insert_id() as id from user limit 1; 
(Õâ¸ö²âÊԵķµ»ØidÒ»Ö±ÊÇ0£¬ÓеãÎÊÌâ)
3.´¢´æ¹ý³Ì
1£©
oracelÖÐ
create sequence seqID
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
nocache
order;
create or replace procedure ......

¹ØÓÚMySQLµÄ²éѯ»º´æ

Ô­Àí
QueryCache(ÏÂÃæ¼ò³ÆQC)ÊǸù¾ÝSQLÓï¾äÀ´cacheµÄ¡£Ò»¸öSQL²éѯÈç¹ûÒÔselect¿ªÍ·£¬ÄÇôMySQL·þÎñÆ÷½«³¢ÊÔ¶ÔÆäʹÓÃ
QC¡£Ã¿¸öCache¶¼ÊÇÒÔSQLÎı¾×÷ΪkeyÀ´´æµÄ¡£ÔÚÓ¦ÓÃQC֮ǰ£¬SQLÎı¾²»»á±»×÷Èκδ¦Àí¡£Ò²¾ÍÊÇ˵£¬Á½¸öSQLÓï¾ä£¬Ö»ÒªÏà²îÄÄÅÂÊÇÒ»¸ö×Ö·û£¨ÀýÈç´óСд²»Ò»Ñù£»¶àÒ»¸ö¿Õ¸ñµÈ£©£¬ÄÇôÕâÁ½¸öSQL½«Ê¹Óò»Í¬µÄÒ» ......

MySQL´´Ê¼ÈË·¢ÓʼþÑ°ÇóÖйú°ïÖú!

Ç×°®µÄÕü¾ÈMySQLµÄÖйúÇ©ÃûÖ§³ÖÕß:
    Å·ÃË¿ÉÄÜÎÞ·¨Õü¾ÈMySQL, ÖйúºÍ¶íÂÞ˹¿ÉÄÜÊÇÕü¾ÈMySQLµÄÏ£ÍûÖ®ËùÔÚ¡£ÖйúÓµÓÐÇ¿´ó¡¢¶ÀÁ¢ÒÔ¼°×ÔÐŵķ´Â¢¶ÏÖ÷¹Ü»ú¹Ø£¬Òò´Ë£¬ÎÒ±¾ÈËÔÚ´ËÇëÇóÄúµÄ°ïÖú¡£¶ÔÓÚÄúÔÚ http://helpmysql.org/cn/petition
µÄÇ©Ãû£¬ÎÒÃÇÉî±í¸Ðл¡£Èç¹û¿ÉÒԵĻ°£¬ÎÒÃÇÐèÒªÄúµÄ½øÒ»²½°ïÖú£º
&nb ......

mysqlÖбàÂëµÄÉèÖÃ

1.ÐÞ¸ÄmysqlµÄĬÈϱàÂëΪgbk£ºÐÞ¸Ämy.initÎļþÖеģº[client]ºÍ[mysqld]ϵÄdefault-character-set=gbk£»
2.²é¿´mysqlÊý¾Ý¿âµÄ±àÂ룺show variable like 'character%';»òstatus
3.²é¿´Êý¾Ý¿â±íµÄ±àÂ룺show create table ±íÃû£»
4.ÐÞ¸ÄÊý¾Ý¿âµÄ±àÂ룺ALTER DATABASE `database_name` DEFAULT CHARACTER SET gbk COLLATE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ