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±¾»ú
Ïà¹ØÎĵµ£º
CodeIgniterÊÇÒ»¸ö·Ç³£Ð¡£¬PHP ÍøÕ¾¿ª·¢ÕßʹÓõÄÓ¦ÓóÌÐò¿ª·¢¿ò¼ÜºÍ¹¤¾ß°üºÜÓÐÇ°¾°µÄPHP¿ª·¢¿ò¼Ü¡£ËüÌṩһÌ׷ḻµÄ±ê×¼¿âÒÔ¼°¼òµ¥µÄ½Ó¿ÚºÍÂß¼½á¹¹£¬ÆäÄ¿µÄÊÇʹ¿ª·¢ÈËÔ±¸ü¿ìËٵؽøÐÐÏîÄ¿¿ª·¢¡£Ê¹Óà CodeIgniter ¿ÉÒÔ¼õÉÙ´úÂëµÄ±àдÁ¿£¬²¢½«ÄãµÄ¾«Á¦Í¶Èëµ½ÏîÄ¿µÄ´´ÔìÐÔ¿ª·¢ÉÏ¡£
ÍƼöÖ¸Êý£º8ÐǼ¶
ѧϰ³É±¾£ºÒ»¸öÀñ°Ý
ƽ ......
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Ô ......
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
mysql´æ´¢¹ý³ÌµÄ´´½¨£¬É¾³ý£¬µ÷Óü°ÆäËû³£ÓÃÃüÁî
mysql 5.0´æ´¢¹ý³Ìѧϰ×ܽá
Ò».´´½¨´æ´¢¹ý³Ì
1.»ù±¾Óï·¨£º
create procedure sp_name()
begin
………
end
2.²ÎÊý´«µÝ
¶þ.µ÷Óô洢¹ý³Ì
1.»ù±¾Óï·¨£ºcall sp_name()
×¢Ò⣺´æ´¢¹ý³ÌÃû³ÆºóÃæ±ØÐë¼ÓÀ¨ºÅ£¬ÄÄŸô洢¹ ......
Ê×ÏȽéÉÜһϴ˺¯ÊýµÄÓ÷¨£º
¶¨ÒåºÍÓ÷¨£¨php5£©
microtime() º¯Êý·µ»Øµ±Ç° Unix ʱ¼ä´ÁºÍ΢ÃëÊý¡£·µ»ØµÄ×Ö·û´®µÄ¸ñʽ£ºmsec sec
Óï·¨
microtime(get_as_float)
²ÎÊý ÃèÊö
get_as_float Èç¹û¸ø³öÁË get_as_float ²ÎÊý²¢ÇÒÆäÖµµÈ¼ÛÓÚ TRUE£¬¸Ãº¯Êý½«·µ»ØÒ»¸ö¸¡µãÊý¡£
˵Ã÷
±¾º¯Êý½öÔÚÖ§³Ö gettimeofday() ϵͳµ÷ ......
./home/a.php
./b.php
b.php
<?php
setcookie('name[1]',"aaa");
setcookie('name[2]',"bbb");
setcookie('name[3]',"ccc");
?>
ÔÚa.php ÖÐ
&nb ......