windows 7ÏÂÈçºÎ°²×°Apache + PHP + MySQL + SVNµÈµÈ
½üÀ´¶Ôphp±È½Ï¸ÐÐËȤ£¬¾Í¶Ï¶ÏÐøÐøµÄ»¨ÁËÁ½¸öÐÇÆÚµÄʱ¼ä°ÑÕû¸öphp¿ª·¢ÐèÒªÓõ½µÄ¶«Î÷¶¼×°ºÃÁË£¬´ó¸ÅµÄ°²×°¹ý³ÌÈçÏ¡£
Ò»¡¢°²×°µÄÈí¼þ:
Apache: 2.2.14
PHP:5.2.12
MySQL:5.1.42¡£
SVN:1.5.6
PHPMyAdmin:3.2.5
Zend Studio: 7.1
Zend Debugger: 5.1.14
¶þ¡¢°²×°¹ý³Ì£º
1. °²×°ºÍÅäÖÃapache
°²×°£ºÊ×ÏÈ´Óhttp://apache.etoak.com/httpd/binaries/win32/apache_2.2.14-win32-x86-openssl-0.9.8k.msiÏÂÔØapacheµÄwindows°²×°°æ±¾£¬Ë«»÷°²×°³ÌÐò£¬Ëü½«Òýµ¼ÄãÍê³ÉÕû¸ö°²×°¹ý³Ì£¬Çë±£Ö¤ÄãÊäÈëµÄ·þÎñÆ÷urlÊÇÕýÈ·µÄ¡£ÔÚ°²×°¹ý³ÌÖУ¬Î¨Ò»ÐèҪעÒâµÄ¾ÍÊÇÈç¹ûÒѾÓÐÒ»¸öIIS»òÕ߯äËüµÄ³ÌÐòʹÓÃÁË80¶Ë¿Ú£¬ÄÇô°²×°»áʧ°Ü¡£Èç¹ûÕâÑù£¬Çëµ½³ÌÐòµÄĿ¼Ï£¨±¾ÀýΪ£ºD:\Program Files\Apache Software Foundation\Apache2.2£©£¬ÕÒµ½confĿ¼£¬´ò¿ªÎļþhttpd.conf£¬½«ÆäÖеÄÒ»ÐÐListen 80¸ÄΪһ¸öû±»Õ¼ÓõĶ˿ڣ¬Èç±¾ÀýΪListen 8080¡£È»ºóÔÙÖØÐÂÔËÐа²×°³ÌÐò£¬Õâ´ÎÓ¦¸Ã¾ÍûÎÊÌâÁË
°²×°½áÊøºóÔÚä¯ÀÀÆ÷ÊäÈëhttp://localhost:8080£¬Èç¹û³ÊÏÖÁËÒ»¸öÒѾÅäÖúõÄÍøÕ¾£¬ÄÇô¹§Ï²Ä㣬ÄãµÄapache¾ÍËã°²×°³ÉÁË¡£
ÅäÖãºapacheµÄÅäÖù¤×÷Ö÷ÒªÊÇÐÞ¸Ähttpd.conf¡£ ´ò¿ªApacheµÄ°²×°Ä¿Â¼, ÕÒµ½Îļþ /conf/httpd.conf, ´ò¿ªËü½øÐÐÅäÖõıà¼. ÅäÖÃÎļþÖжÔÓÚ¸÷Ïî¶¼ÓбȽÏÏêϸµÄÃèÊö, ÔÚÅäÖýáÊøÖ®ºó¿ÉÒÔÔËÐпªÊ¼²Ëµ¥ÖÐApache°²×°Îļþ¼ÐÖеÄTest Configuration¹¤¾ßÀ´¼ìÑéÅäÖÃÎļþÊÇ·ñÕýÈ·. Èç¹ûÅäÖò»ÕýÈ·»á¸ø³ö¼òÒªµÄ˵Ã÷. Èç¹ûÔÚÅäÖýáÊøÖ®ºóͨ¹ýÁËTest Configuration¹¤¾ß, µ«ÊÇÈÔÈ»²»Äܹ»Ë³ÀûÔËÐÐApache, ¿ÉÒÔµ½[Apache°²×°Ä¿Â¼]/logs/ Õâ¸öĿ¼Öв鿴¼Ç¼, ÒÔÕÒ³öÎÊÌâËùÔÚ¡£
Ö÷ÒªµÄÅäÖþÍÊÇÉèÖÃapacheµÄÎĵµÄ¿Â¼ºÍÐéÄâ·¾¶¡£ÕÒµ½DocumentRoot, ĬÈϵÄÓ¦¸ÃÊÇDocumentRoot "D:/Program Files/Apache Software Foundation/Apache2.2/htdocs"£¬ÕâÀÎÒÃǽ«ËüÉèÖóÉ×Ô¼ºÏ²»¶µÄ¹¤×÷·¾¶¡£±¾ÀýΪDocumentRoot "D:/Workspace"¡£ÖØÆôapache£¬ºÃÁË£¬ÏÖÔÚÈç¹ûÄã°Ñindex.htmlÎļþ·Åµ½D:/WorkspaceĿ¼Ï£¬ÎÒÃǾͿÉÒÔͨ¹ýhttp://localhost:8080/index.htmlÀ´·ÃÎʸÃÎļþ¡£Æä´Î£¬ÕÒµ½#Alias /webpath /full/filesystem/pat£¬½«Ç°ÃæµÄ#È¥µô£¬¸ÄΪÒÔÏÂÐéÄâĿ¼Alias /Webpath/ "D:/Data"£¬ÖØÆôapache£¬ÔÚä¯ÀÀÆ÷ÖÐÊäÈëhttp://localhost:8080/data/µÄʱºò¾Í»á·ÃÎÊ·þÎñÆ÷µÄ"D:/Data"Ŀ¼
2. °²×°ºÍÅäÖÃphp
°²×°£ºÊ×ÏÈÇëÈ¥www.php.netÍøÕ¾ÏÂÔØphp°²×°³ÌÐò¡£Ä¿Ç°µÄ°²×
Ïà¹ØÎĵµ£º
<?php
function page ( $totalPage , $currentPage,$url ,$halfPer=5)
{
$total=$totalPage-1;
$re="<td><a href="\" mce_href="\""$url\" onclick=\"page=prompt('¹²{$totalPage}Ò³\\n×Ô¶¨ÒåÌø×ªµ½µÚ¼¸Ò³£º','');if(page>0&&page<$total)location.href=this.href+'='+(page-1);r ......
<?php
function make_rand($length="32"){//ÑéÖ¤ÂëÎÄ×ÖÉú³Éº¯Êý
$str="abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890";
$result="";
for($i=0;$i<$length;$i++){
$num[$i]=rand(0,61);
$result.=$str[$num[$i]];
}
return $result;
} ......
JavaÁ¬½ÓmysqlÊý¾Ý¿â£¬´úÂë¾¹ýÔËÐÐ׼ȷÎÞÎó¡£
ÏÂÃæÎªÊµÀý---->
ÓÃÊý¾Ý¿â²Ù×ݹ¤¾ß£¨Àý£ºSQLyogEnt£©²Ù×Ýmysql½¨±í£¬»òdosϽ¨£¬ÈçÏ£º
Êý¾Ý¿âÃû£ºscutcs
±íÃû£ºstudent
±íÄÚÈÝ£º
sno char[7] NO NULL Primary Key;
sname varchar[8] NO NULL;
sex char[2] NO NULL; ......
http://book.51cto.com/art/200803/68118.htm
ÕªÒª£º¡¶ÉîÈëdz³öMySQL——Êý¾Ý¿â¿ª·¢¡¢ÓÅ»¯Óë¹ÜÀíά»¤¡·´ÓÊý¾Ý¿âµÄ»ù´¡¡¢¿ª·¢¡¢ÓÅ»¯¡¢¹ÜÀí4·½Ãæ¶ÔMySQL½øÐÐÁËÏêϸµÄ½éÉÜ£¬ÆäÖÐÿһ²¿·Ö¶¼¶ÀÁ¢³Éƪ£¬Ã¿Ò»ÆªÓÖ°üÀ¨¶à¸öÕ½ڡ£±¾ÊéÃæÏòʵÓã¬ÄÚÈݸ²¸Ç¹ã·º£¬½²½âÓÉdzÈëÉÊʺÏÓÚ¸÷¸ö²ã´ÎµÄ¶ÁÕß¡£
µÚ20ÕÂ ËøÎÊÌâ
ËøÊÇ ......
×öÏîĿʱÓÉÓÚÒµÎñÂß¼µÄÐèÒª£¬±ØÐë¶ÔÊý¾Ý±íµÄÒ»Ðлò¶àÐмÓÈëÐÐËø£¬¾Ù¸ö×î¼òµ¥µÄÀý×Ó£¬Í¼Êé½èÔÄϵͳ¡£¼ÙÉè id=1 µÄÕâ±¾Êé¿â´æÎª 1 £¬µ«ÊÇÓÐ 2 ¸öÈËͬʱÀ´½èÕâ±¾Ê飬´Ë´¦µÄÂ߼Ϊ
view plaincopy to clipboardprint?
Select restnum from book where id =1 ; ......