windows 7 ϰ²×°apache php ºÍmysqlµÄһЩÎÊÌâ¡£
ÔÚwindowsϰ²×°ampÍøÉϵĽéÉܺܶàÁË¡£
ÎÒÕâÀïֻ˵Щ¹Ø¼üµÄ²¿·Ö£¬Ò»·½Ãæ×÷Ϊ±Ê¼Ç£¬ÁíÒ»·½ÃæºÍ´ó¼Ò¹²Ïí¡£
1.°²×°apache
a.ÕâÀïҪעÒ⣬ÔÚ¸Õ¿ªÊ¼ÌîдÖ÷»úÓòÃûʱ£¬Èç¹ûÄãûÓÐÓòÃû£¬¾ÍÔÚ±¾µØ°²×°£¬ÄǾÍÌîд±¾»úipÐÐÁË¡££¨ÎÒ¾õµÃÌîд127.0.0.1¸üºÃ£¬¾ßÌåÎÒûÊÔ¹ý£©
b.apache µÄĬÈ϶˿ÚÊÇ80£¬ÎҵĻúÆ÷²»ÖªÎªºÎ80¶Ë¿Ú×ÜÊÇ´¦ÓÚ¼àÌý״̬Ï£¨¿ÉÓÃnetstat -a ÃüÁî²é¿´£©£¬Òò´ËapacheÎÞ·¨Æô¶¯ÆðÀ´¡£Äã¿ÉÒÔ´ÓÆôһϻúÆ÷ÊÔÊÔ£¬¿´apacheÄܲ»Äܵõ½80¶Ë¿Ú£¬ÊµÔÚ²»ÐÐÁËÄãÔÚhttp.confÖÐÐÞ¸Äһ϶˿ڣ¬±ÈÈçµ½8080£¨ÄãËÑÒ»ÏÂ80¾Í¿ÉÒÔÕÒµ½ÔÚÄÄÀïÐÞ¸ÄÁË£©¡£
c.ÒªÊÇûÓÐʲôÎÊÌâÔÚä¯ÀÀÆ÷ÖÐÊäÈëlocalhostÓ¦¸Ã»áÓГIt work!” ÕâÑùµÄ×Ö·û,·ñÔò£¬ÎҾͲ»ÖªµÀÁË£¬ÄúÔÙgoogle°É¡£
2.°²×°php
a.½âѹ°²×°Îļþµ½ÄãµÄĿ¼£¨ÎÒÕâÀïÊÇG:\php5£©
b.ÐÞ¸Äphp.iniÎļþÇëÏÈÐÞ¸Ä doc_root [Ö¸ÏòÄãµÄÍøÕ¾¸ùĿ¼¡£ÎÒµÄÊÇ G:\Apache\htdocs ] extension_dir[phpµÄÀ©Õ¹¹¦ÄÜÄ£¿éλÖ㬾ÍÊÇphpÎļþ¼ÐÖеÄextÎļþ¼ÐλÖÃ]£¬×îÖÕÐÞ¸ÄΪ
doc_root = G:\Apache\htdocs
extension_dir = G:\php5\ext
3.apacheºÍphp¹ØÁªÆðÀ´
ÐÞ¸Ähttp.confÎļþ£¬ÔÚ×îÃæ¼ÓÉÏÈçÏ´úÂë
LoadModule php5_module "G:/php5/php5apache2_2.dll"
AddType application/x-httpd-php .php
AddType application/x-httpd-php .htm
PHPIniDir "G:/php5/"
ËùÓкÍ·¾¶Ïà¹ØµÄ£¬Çë×ÔÐÐÐ޸ġ£
ÏÖÔÚ ÔÚG:\Apache\htdocs Ŀ¼ÏÂн¨Ò»¸ötest.phpÎļþ£¬ÄÚÈÝΪ<?php phpinfo(); ?>
ÔÚä¯ÀÀÆ÷ÖÐÊäÈëlocalhost/test.phpÓ¦¸Ã»á¿´µ½ÄĸöphpµÄÅäÖÃÐÅÏ¢Ò³Ãæ¡££¨ÍøÉ϶àµÄÊÇ£¬ÎҾͲ»ÌùÁË£©
4.°²×°mysql
…………ÕâÀïʡȥN°Ù×Ö£¨Ã»Ê²Ã´ÒªËµµÄ£©
6.php¼ÓÔØmysql´¦ÀíÄ£¿é
ÐÞ¸Äphp.ini È¥µôextension=php_mbstring.dll£¬extension=php_mysql.dll֮ǰµÄ‘;’
Ôٴδò¿ªlocalhost/test.php ¿´ÀïÃæÊDz»ÊÇÓÐÁ˹ØÓÚmysqlµÄÏà¹ØÐÅÏ¢¡£
over
±¸×¢£¬ÔÚ½ÓÏÂÀ´°²×°discuzʱÈôÊÇÓöµ½Êý¾Ý¿âÁ¬½Ó³¬Ê±£¬ºÜ¿ÉÄÜÊÇipµØÖ·ÎÊÌâ¡£ÐÞ¸Älocalhost±¾»ú
Ïà¹ØÎĵµ£º
Óà PHP ¿ØÖÆä¯ÀÀÆ÷»º´æÊǷdz£ÈÝÒ׵ģ¬ÊÖ²áÉÏÒ²Ïà¹ØµÄ˵Ã÷£¬ÓÉÓںܶà³õѧÕßûÓаÑÊֲῴÍ꣬ËùÒÔ»¹ÊÇ»áÓÐºÜ¶à¹ØÓÚÕâ¸öÎÊÌâµÄÒÉÎÊ£¬¹ÊÔÚ´ËרÃÅ·¢Ò»ÆªÎÄÕ£¬Í¬Ê±¶ÔÏà¹ØµÄÓï·¨×öÁËÏêϸµÄ˵Ã÷£¬·½±ãÐÂÊÖ²éÔÄ¡£
¡¡¡¡Òª½â¾öÕâÒ»ÎÊÌ⣬¿ÉÒÔͨ¹ý PHP ÖÐµÄ header() º¯Êý£¬·¢ËÍÌØ¶¨µÄ»º´æ¿ØÖÆÔʼ HTTP ±êÍ·£¬¾ßÌå´úÂëÈçÏ£º
Exampl ......
ºÚ¿ÍÈëÃż¼ÊõÖ®php+mysql×¢ÉäÓï¾ä¹¹Ô죺
Ò».ǰÑÔ£º
²âÊÔ°æ±¾ÐÅÏ¢£ºOkphp BBS v1.3 ¿ªÔ´°æ
ÓÉÓÚPHPºÍMYSQL±¾ÉíµÃÔÒò,PHP+MYSQLµÄ×¢ÉäÒª±ÈaspÀ§ÄÑ£¬ÓÈÆäÊÇ×¢ÉäʱÓï¾äµÄ¹¹Ôì·½Ãæ¸üÊǸöÄѵ㣬±¾ÎÄÖ÷ÒªÊǽè¶ÔOkphp BBS v1.3һЩÎļþµÃ¼òµ¥·ÖÎö£¬À´Ì¸Ì¸php+mysql×¢ÉäÓï¾ä¹¹Ô췽ʽ£¬Ï£Íû±¾ÎĶÔÄãÓеã°ïÖú¡£
¡¡¡¡ÉùÃ÷£ºÎÄÕÂËùÓ ......
MYSQL Castº¯Êý ÀàÐÍת»»
BINARY
BINARY²Ù×÷·û½«ºóÃæµÄ×Ö·û´®Å׸øÒ»¸ö¶þ½øÖÆ×Ö·û´®¡£ÕâÊÇÒ»ÖÖ¼òµ¥µÄ·½Ê½À´´ÙʹÖð×Ö½Ú¶ø²»ÊÇÖð×Ö·ûµÄ½øÐÐÁбȽϡ£ÕâʹµÃ±È½ÏÇø·Ö´óСд£¬¼´Ê¹¸ÃÁв»±»¶¨ÒåΪ BINARY»ò BLOB¡£BINARYÒ²»á²úÉú½áβ¿Õ°×£¬´Ó¶ø¸ü¼ÓÏÔÑÛ¡£
mysql> SELECT 'a' = 'A';
-> 1
mysql> SELECT BINARY ' ......
from_unixtime()ÊÇMySQLÀïµÄʱ¼äº¯Êý
dateΪÐèÒª´¦ÀíµÄ²ÎÊý(¸Ã²ÎÊýÊÇUnix ʱ¼ä´Á),¿ÉÒÔÊÇ×Ö¶ÎÃû,Ò²¿ÉÒÔÖ±½ÓÊÇUnix ʱ¼ä´Á×Ö·û´®
ºóÃæµÄ '%Y%m%d' Ö÷ÒªÊǽ«·µ»ØÖµ¸ñʽ»¯
ÀýÈç:
mysql>SELECT from_UNIXTIME( 1249488000, '%Y%m%d' )
->20071120
mysql>SELECT from_UNIXTIME( 1249488000, '%YÄê%mÔ ......
Ì×½Ó×Ö±à³Ì£¬Ò»°ãʹÓÃc»òc++¡£ÌرðµÄÔÚwebÓ¦ÓóÌÐò¿ª·¢ÖУ¬³£ÓÃperlʵÏÖÌ×½Ó×Ö¡£³ý´ËÒÔÍ⣬ÓÃphp½øÐÐÌ×½Ó×Ö±à³ÌÒ²ÊÇÒ»¸öÑ¡Ôñ¡£Php¿ÉÒÔʤÈÎÂ𣿵±È»¿ÉÒÔ¡£PhpÊÇһßßÖÊÁ¿µÄwebÓ¦ÓóÌÐò¿ª·¢ÓïÑÔ£¬ËûµÄÐí¶àÌØÐÔ¿ÉÒÔ´¦ÀíÖÚ¶àµÄÈÎÎñ£¬ÍøÂç±à³ÌÒ²²»ÀýÍâ¡£
1. Àí½âÌ×½Ó×Ö
Mail¡¢ftp¡¢telnet¡¢nameºÍfingerÕ ......