PHPºÍMySQL Web¿ª·¢ (ÔÊéµÚ4°æ) »úе¹¤Òµ
http://www.xhsd.com.cn/books/views.asp?plucode=711126281
Õâ±¾Êé±»³ÆÎªPHPºÍMySQLµÄ“Ê¥¾”£¬×Ðϸ¿´ÁËһϣ¬µÄÈ·Óкܶà¶Àµ½µÄµØ·½¡£
Ê×ÏÈ£¬ÄÚÈÝÃ÷È·Í»³ö¡£Õâ±¾ÊéµÄÄ¿µÄÊǶÔPHPºÍMySQL×öÉîÈëdz³öµÄ·ÖÎö£¬¶ÔÆäWebÓ¦ÓÃ×öÁ˽ÏÈ«ÃæµÄ²ûÊö£¬Àý×Ó¾µäʵÓá£
Æä´Î£¬Ð¡£PHP5.3£¬MySQLµÄ´æ´¢¹ý³ÌºÍ´æ´¢ÒýÇæ£¬Ajax¼¼ÊõÓëWeb2.0£¬WebÓ¦ÓõݲȫÎÊÌâ……ÎÞÒ»²»Õ¹Ê¾×Åм¼Êõ¡£
µÚÈý£¬Ð´×÷ˮƽ½Ï¸ß¡£ÊéÖеĸÅÄî¼°Óï·¨½éÉܼܺòÁ·£¬Ê¾Àý×î¼Ñ£¬Óï¾ä¾«¶Ì£¬Ã¿½ÚµÄÄÚÈÝÒ²²»Ì«¶à¡£
µÚËÄ£¬¹á´©Èí¼þ¹¤³Ì˼Ï룬¼°×÷ÕߵľÑé¡£Á½Î»×÷Õß¶¼ÊǾÑé·á¸»µÄ´ÓÒµÈËÔ±¡£
µÚÎ壬´úÂëʵÓá£ÉÔ×÷Ð޸ļ´¿ÉÖ±½ÓʹÓá£
µ±È»Õâ±¾ÊéÒ²Óв»×ãµÄµØ·½¡£
±¾ÊéµÄ¶ÁÕß¶ÔÏóÒªÇóÓÐÒ»¶¨µÄ¾Ñ飬¶ÔÓÚÍêÈ«µÄ³õѧÕßÀ´Ëµ£¬¶ÁÆðÀ´¿ÉÄÜ»á±È½Ï³ÔÁ¦¡£ÁíÍâÕë¶Ô´óÐÍ»òµç×ÓÉÌÎñÀàÐÍWebÕ¾µãÓ¦Óã¬ÆäËû·½ÃæµÄÓ¦Óò»×ã¡£
¼Û¸ñÆ«¹ó£¬714Ò³£¬95Ôª¡£
¿ÉÒÔ½è¼øµÄµØ·½ÈçÏ¡£
Ê×ÏÈ£¬Ò»¶¨ÒªÇå³þµØ¸æËß¶ÁÕߣ¬PHPºÍMySQLÊÇ×öʲôµÄ£¬¿ÉÒÔͨ¹ýÒ»¸öµäÐ͵ÄʵÀý˵Ã÷¡£
Æä´Î£¬ÒªÈöÁÕß¿ìËÙÈëÃÅ¡£
µÚÈý£¬ÊµÀýÒ»¶¨Òª·á¸»¡¢ÊµÓá£
µÚËÄ£¬Æª£¨Ê¹ÓÃPHP£¬Ê¹ÓÃMySQL£¬µç×ÓÉÌÎñÓ밲ȫÐÔ£¬£Ð£È£ÐµÄ¸ß¼¶¼¼Êõ£¬´´½¨ÊµÓõģУȣкͣͣù£Ó£Ñ£ÌÏîÄ¿£©
µÚÎ壬ÓÐЩ¶«Î÷ҪעÃ÷¶ÁÕßÐèÒª×Ô¼º¶¯ÊÖѧ¡£
¡¶£Ð£È£Ð¿ª·¢ÊµÕ½±¦µä¡·
½á¹¹£º»ù´¡ÖªÊ¶£ÜºËÐļ¼Êõ£Ü¸ß¼¶Ó¦ÓãÜÏîĿʵս
Ŀ¼£ºÍ»³öÏÔʾ“ʵս”£¬Èç¡¶£Ã£«£«±¦µä¡·Í»³öÏÔʾ“×ÛºÏʵÀý”
¡¶£Ð£È£Ð£«£Á£ê£á£ø¡¡£×£å£â¡¡£²£®£°¡¡±à³Ì¼¼ÊõÓëÏîÄ¿¿ª·¢´óÈ«¡·
Ŀ¼£ºÄ¿Â¼Öмӱ¾Õ¹ؼüÄÚÈÝ
Ïà¹ØÎĵµ£º
Linux + Apache2.0 + Mysql + PHP + phpBB3.0
1.°²°ü£º
Apache2.0
#tar -zxf httpd-***.tar.gz -C /usr/local/src/
#cd /usr/local/src/httpd-***
  ......
PHP5.2.4֮ǰµÄ°æ±¾ÎÞÐèÉèÖÃÊ±Çø¡£ÏÂÃæÊÇÐÞ¸ÄPHPÊ±ÇøµÄÈý¸ö°ì·¨¡£
1¡¢ÐÞ¸ÄPHP.iniÕâ¸öÎļþ
ÕÒµ½date.timezoneÕâÐУ¬È¥µôÇ°ÃæµÄ·ÖºÅ£¬¸Ä³É£º date.timezone = Asia/Shanghai 2¡¢ÐÞ¸Ä .htaccessÎļþ
ÐÞ¸Ä.htaccessÎļþÓÐÁ½ÖÖ°ì·¨£¬ÏÂÃæµÄÁ½ÌõÓï¾äÖ»ÒªÓÐÒ»Ìõ¼´¿É php_value date.timezone Asia/Shanghai
......
MysqlÊý¾Ý¿âÊÇÒ»¸ö¶àÓû§£¬¶àÏ̵߳ĹØÏµÐÍÊý¾Ý¿â£¬ÊÇÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄÓ¦ÓóÌÐò¡£ËüÊǶԸöÈËÓû§ºÍÉÌÒµÓû§ÊÇÃâ·ÑµÄ.
¡¡¡¡MysqlÊý¾Ý¿â¾ßÓÐÒÔÏÂÓŵ㣺
¡¡¡¡1.ͬʱ·ÃÎÊÊý¾Ý¿âµÄÓû§µÄÊýÁ¿²»ÊÜÏÞÖÆ
¡¡¡¡2.¿ÉÒÔ±£´æ³¬¹ý5ǧÍòÌõµÄ¼Ç¼
¡¡¡¡3.ÊÇĿǰÊг¡ÉÏÏÖÓÐÊý¾Ý¿â²úÆ·ÖÐÔËÐÐËÙ¶È×î¿ìµÄÊý¾Ý¿âϵͳ
¡¡¡¡4.Óû§È¨ÏÞ ......
×î½üµÄÏîÄ¿ÖÐʹÓÃÁËMySQLÊý¾Ý¿â£¬Ò»Ð©MySQLµÄÐÂÓû§ÔÚÅäÖÃʹÓÃʱ»¹ÓÐЩ²»¹»ÊìÁ·£¬ÌØÔڴ˼Ǽ£¬·½±ã¿ª·¢ÍŶÓʹÓ㬸ÃÎÄÕÂËùÉæ¼°ÄÚÈݾù¿ÉÒÔÔÚMySQL²Î¿¼ÊÖ²áµÚ¶þÕ“°²×°MySQL”ÖÐÕÒµ½¡£MySQL°²×°ºó×Ô´øÁËÓ¢ÎIJο¼ÊֲᣬҲ¿ÉÒÔÔÚhttp://dev.mysql.com/doc/refman/5.1/zh/index.html²é¿´ÖÐÎİ汾£ ......
1. ÈçºÎÓÃphpµÄ»·¾³±äÁ¿µÃµ½Ò»¸öÍøÒ³µØÖ·µÄÄÚÈÝ£¿ipµØÖ·ÓÖÒªÔõÑùµÃµ½£¿
[php]
echo $_SERVER ['PHP_SELF'];
echo $_SERVER ['SERVER_ADDR'];
[/php]
2. ÇóÁ½¸öÈÕÆÚµÄ²îÊý£¬ÀýÈç2007-2-5 ~ 2007-3-6 µÄÈÕÆÚ²îÊý
[php]
$begin=strtotime('2007-2-5');
$end=strtotime('2007-3-6');
echo ($end-$begin)/(24*3600);
[ ......