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±¾»ú
Ïà¹ØÎĵµ£º
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Ô ......
½ñÌìµ÷³ÌÐò´ÓÊý¾Ý¿âÀïÈ¡Êý¾Ý£¬Ò»Ö±È¥²»³öÀ´£¬°ÑÈÕÖ¾Àï´ò³öÀ´µÄsql·Åµ½Êý¾Ý¿âÀïÈ¥Ö´ÐУ¬È´ÓÖÄÜ
È¡³öÊý¾ÝÀ´£¬ºÜÊÇÓôÃÆ¡£
Êý¾Ý¿âÊÇmysqlµÄ£¬Ò»¹²128¸ö¿â£¬Í¨¹ýij¸ö×ֶηֿ⡣
ºóÀ´·¢ÏÖÒª²éµÄÕâÌõÊý¾ÝµÄ·Ö¿â×ֶα»¸Ä¹ý£¬°´ÕÕ³ÌÐòÀïÖ´ÐеÄÈ¥²é£¬Ëû¾ÍÈ¥ÁËÁíÍâÒ»¸ö¿â ......
mastering Phpmyadmin
Beginning Php And Mysql³ÌÐòÉè¼Æ
Beginning PHP and MySQL from Novice to Professional 3rd Edition
Head First PHP MySQL
MySQLÈëÞµä
MySQL Stored Procedure Pr ......
ÿ¸öÈ˵Äѧϰ·½Ê½²»Í¬£¬Ð´ÕâÆªÎÄÕµÄÄ¿µÄÊÇ·ÖÏíÒ»ÏÂ×Ô¼ºµÄѧϰ¹ý³Ì£¬½ö¹©²Î¿¼£¬²»ÒªÒ»Î¶µÄÓñðÈ˵Äѧϰ·½·¨£¬ÕÒ¶Ô×Ô¼ºÓÐÓõÄѧϰ·½Ê½
¾³£ÔÚijЩÂÛ̳ºÍQQȺÀï¿´µ½Ò»Ð©ÅóÓÑ»áÎÊ“ÔõÑù²ÅÄÜѧºÃPHP£¬ÔõÑù²ÅÄÜѧºÃ***ÓïÑÔ ”£¬µ«±ðÈ˻شð×î¶àµÄÊÇ£º´Ó×òµ¥”µÄ¿ªÊ¼¡£
Õâ¸ö¼òµ¥Ò²ÐíÕæµÄ²»¼òµ¥£¬ºÇºÇ¡£Ï ......
<?php
//µ÷ÊÔÊä³öÐÅÏ¢
$pageCount=15;
for($i=1;$i<=$pageCount;$i++){
dump(GetPageRange($i,$pageCount),$i);
}
//$currentPage µ±Ç°Ò³Âë
//$pageCount ×ÜÒ³Êý
//$leftSize ×ó²àÒ³Â뷶Χ
//$rightSize ÓÒ²àÒ³Â뷶Χ
//·µ»ØÒ³ÂëÇø¼äÊý×é
function GetPageRange($currentPage,$pageCount,$leftSize=3, ......