ºÚ¿ÍÈëÃż¼ÊõÖ®php+mysql×¢ÉäÓï¾ä¹¹Ô죺
Ò».ǰÑÔ£º
²âÊÔ°æ±¾ÐÅÏ¢£ºOkphp BBS v1.3 ¿ªÔ´°æ
ÓÉÓÚPHPºÍMYSQL±¾ÉíµÃÔÒò,PHP+MYSQLµÄ×¢ÉäÒª±ÈaspÀ§ÄÑ£¬ÓÈÆäÊÇ×¢ÉäʱÓï¾äµÄ¹¹Ôì·½Ãæ¸üÊǸöÄѵ㣬±¾ÎÄÖ÷ÒªÊǽè¶ÔOkphp BBS v1.3һЩÎļþµÃ¼òµ¥·ÖÎö£¬À´Ì¸Ì¸php+mysql×¢ÉäÓï¾ä¹¹Ô췽ʽ£¬Ï£Íû±¾ÎĶÔÄãÓеã°ïÖú¡£
¡¡¡¡ÉùÃ÷£ºÎÄÕÂËùÓÐÌáµ½µÄ"©¶´"£¬¶¼Ã»Óо¹ý²âÊÔ£¬¿ÉÄܸù±¾²»´æÔÚ£¬ÆäʵÓÐûÓЩ¶´²¢²»ÖØÒª£¬ÖØÒªµÄÊÇ·ÖÎö˼·ºÍÓï¾ä¹¹Ôì¡£
¶þ."©¶´"·ÖÎö£º
1.admin/login.php×¢Éäµ¼ÖÂÈÆ¹ýÉí·ÝÑé֤©¶´£º
´úÂ룺
$conn=sql_connect($dbhost, $dbuser, $dbpswd, $dbname);
$password = md5($password);
$q = "select id,group_id from $user_table where username='$username' and password='$password'";
$res = sql_query($q,$conn);
$row = sql_fetch_row($res);
$q = "select id,group_id from $user_table where username='$username' and password='$password'"ÖÐ
$username ºÍ $password û¹ýÂË£¬ ºÜÈÝÒ×¾ÍÈÆ¹ý¡£
¶ÔÓÚselect * from $user_table where username='$username' and password='$password'ÕâÑùµÄÓï¾ä¸ÄÔìµÄ·½·¨ÓУº
¹¹Ôì1£¨ÀûÓÃÂß¼ÔËË㣩£º$username=' O ......
ºÚ¿ÍÈëÃż¼ÊõÖ®php+mysql×¢ÉäÓï¾ä¹¹Ô죺
Ò».ǰÑÔ£º
²âÊÔ°æ±¾ÐÅÏ¢£ºOkphp BBS v1.3 ¿ªÔ´°æ
ÓÉÓÚPHPºÍMYSQL±¾ÉíµÃÔÒò,PHP+MYSQLµÄ×¢ÉäÒª±ÈaspÀ§ÄÑ£¬ÓÈÆäÊÇ×¢ÉäʱÓï¾äµÄ¹¹Ôì·½Ãæ¸üÊǸöÄѵ㣬±¾ÎÄÖ÷ÒªÊǽè¶ÔOkphp BBS v1.3һЩÎļþµÃ¼òµ¥·ÖÎö£¬À´Ì¸Ì¸php+mysql×¢ÉäÓï¾ä¹¹Ô췽ʽ£¬Ï£Íû±¾ÎĶÔÄãÓеã°ïÖú¡£
¡¡¡¡ÉùÃ÷£ºÎÄÕÂËùÓÐÌáµ½µÄ"©¶´"£¬¶¼Ã»Óо¹ý²âÊÔ£¬¿ÉÄܸù±¾²»´æÔÚ£¬ÆäʵÓÐûÓЩ¶´²¢²»ÖØÒª£¬ÖØÒªµÄÊÇ·ÖÎö˼·ºÍÓï¾ä¹¹Ôì¡£
¶þ."©¶´"·ÖÎö£º
1.admin/login.php×¢Éäµ¼ÖÂÈÆ¹ýÉí·ÝÑé֤©¶´£º
´úÂ룺
$conn=sql_connect($dbhost, $dbuser, $dbpswd, $dbname);
$password = md5($password);
$q = "select id,group_id from $user_table where username='$username' and password='$password'";
$res = sql_query($q,$conn);
$row = sql_fetch_row($res);
$q = "select id,group_id from $user_table where username='$username' and password='$password'"ÖÐ
$username ºÍ $password û¹ýÂË£¬ ºÜÈÝÒ×¾ÍÈÆ¹ý¡£
¶ÔÓÚselect * from $user_table where username='$username' and password='$password'ÕâÑùµÄÓï¾ä¸ÄÔìµÄ·½·¨ÓУº
¹¹Ôì1£¨ÀûÓÃÂß¼ÔËË㣩£º$username=' O ......
ÿ¸öÈ˵Äѧϰ·½Ê½²»Í¬£¬Ð´ÕâÆªÎÄÕµÄÄ¿µÄÊÇ·ÖÏíÒ»ÏÂ×Ô¼ºµÄѧϰ¹ý³Ì£¬½ö¹©²Î¿¼£¬²»ÒªÒ»Î¶µÄÓñðÈ˵Äѧϰ·½·¨£¬ÕÒ¶Ô×Ô¼ºÓÐÓõÄѧϰ·½Ê½
¾³£ÔÚijЩÂÛ̳ºÍQQȺÀï¿´µ½Ò»Ð©ÅóÓÑ»áÎÊ“ÔõÑù²ÅÄÜѧºÃPHP£¬ÔõÑù²ÅÄÜѧºÃ***ÓïÑÔ ”£¬µ«±ðÈ˻شð×î¶àµÄÊÇ£º´Ó×òµ¥”µÄ¿ªÊ¼¡£
Õâ¸ö¼òµ¥Ò²ÐíÕæµÄ²»¼òµ¥£¬ºÇºÇ¡£ÏÂÃæÎÒÏë·ÖÏíÒ»ÏÂ×Ô¼ºÑ§Ï°µÄһЩ¹ý³Ì¡£ÏÈ˵Щ·Ñ»°£¬ÓïÑÔ×éÖ¯ÄÜÁ¦²î£¬ËµÁ˲»ÉÙ·Ñ»°£¬Ô¸Òâ¿´µÄ¾Í¿´£¬²»ÒªÂîÎÒ¾ÍÐÐ
ÆäʵѧϰһÃÅÐÂÓïÑÔ²¢²»ÊÇÌ«ÄÑ£¬ÖØÒªµÄÊÇÄãÓÐûÓÐ×¼±¸ºÃȥѧºÃËü£¬Ê±¼äµÄ³¤¶ÌºÍ¸öÈ˵ÄÄÜÁ¦ºÍ¾öÐÄÓйء£ºÚ¿Í½çÒ²Á÷ÐÐÒ»¾ä»°¾ÍÊǓûÓÐÈëÇÖ²»Á˵ļÆËã»ú”£¬Õâ¾ä»°´ó¸ÅµÄÒâ˼ÊÇ˵£ºÈç¹ûÄãµÄ¼¼Êõ±Èά»¤Õą̂¼ÆËã»úµÄ¹ÜÀíÔ±¸üʤһ³ï£¬ÄÇô¾ÍÄÜÄÃÏÂÕą̂¼ÆËã»úÉõÖÁÄÜÄÃÏÂÕâ¸ö¹ÜÀíÔ±¹ÜÀíµÄËùÓмÆËã»ú£¬Èç¹û¼¼²»ÈçÈË£¬Ö»ÄܼÌÐøÑ§Ï°³¬¹ý¶Ô·½¡£ÎÒ˵ÕâЩ»°µÄÒâ˼¾ÍÊÇÈÃ×¼±¸Ñ§Ï°Ä°ÉúÓïÑÔÅóÓÑÒ»¶¨ÒªÏ¾öÐÄȥѧϰ£¬Ö»ÒªÄãÏÂÁ˾öÐÄȥѧÁË£¬¾ÍÒ»¶¨ÄÜѧºÃ£¬Ç§Íò²»Òª°ë;¶ø·Ï¡££¨ÍËÒ»Íò²½À´Ëµ£¬¼´Ê¹ÊÇûѧºÃ£¬µ«Äã¶®µÄ±ØÈ»±È±ðÈ˶ࣩ
Á˽âʲôÊÇ×î¼òµ¥:
1¡¢ÍøÒ³µÄ»ù±¾¹¹³É¾ÍÊÇhtml´úÂë,ËùÒÔ±ØÐëÊìϤHTML/CSS/JSµÈ»ù±¾ÔªËØ
2¡¢ÊìϤPHPÓï·¨£¬Á˽âPHP ......
Ê×ÏȽéÉÜһϴ˺¯ÊýµÄÓ÷¨£º
¶¨ÒåºÍÓ÷¨£¨php5£©
microtime() º¯Êý·µ»Øµ±Ç° Unix ʱ¼ä´ÁºÍ΢ÃëÊý¡£·µ»ØµÄ×Ö·û´®µÄ¸ñʽ£ºmsec sec
Óï·¨
microtime(get_as_float)
²ÎÊý ÃèÊö
get_as_float Èç¹û¸ø³öÁË get_as_float ²ÎÊý²¢ÇÒÆäÖµµÈ¼ÛÓÚ TRUE£¬¸Ãº¯Êý½«·µ»ØÒ»¸ö¸¡µãÊý¡£
˵Ã÷
±¾º¯Êý½öÔÚÖ§³Ö gettimeofday() ϵͳµ÷ÓõIJÙ×÷ϵͳÏ¿ÉÓá£
Èç¹ûµ÷ÓÃʱ²»´ø¿ÉÑ¡²ÎÊý£¬±¾º¯ÊýÒÔ "msec sec" µÄ¸ñʽ·µ»ØÒ»¸ö×Ö·û´®£¬ÆäÖÐ sec ÊÇ×Ô Unix ¼ÍÔª£¨0:00:00 January 1, 1970 GMT£©Æðµ½ÏÖÔÚµÄÃëÊý£¬msec ÊÇ΢Ã벿·Ö¡£×Ö·û´®µÄÁ½²¿·Ö¶¼ÊÇÒÔÃëΪµ¥Î»·µ»ØµÄ¡£
´úÂ룺
<?php
echo microtime();echo '<br />';echo microtime(TRUE);
?>
ä¯ÀÀÆ÷ÏÔʾ½á¹û£º
0.45316500 12212282521221228252.45
ÎÒÃÇ¿´µ½microtime(TRUE),Ö»·µ»ØÁË2λµÄСÊý¡£Èç¹ûÒªÊä³ö¸ü¶àλµÄ΢Ã룬ÐèÒªº¯Êýnumber_format().¿´×îºó¸½1Õâ¸öº¯ÊýµÄÓ÷¨¡£
²¹³ä£ºÔÚPHP4ÏÂmicrotime()µÄÓ÷¨ ,ÓÉÓÚûÓвÎÊýTRUEµÄÓ÷¨£¬ËùÒÔÈç¹ûÒªµÃµ½¸¡µãÊý£¬ÐèÒªÅäºÏarray_num()º¯ÊýºÍexplode£¨£©º¯Êý¡£
±ÈÈ磺
ÔÚPHPÀïÃæ£¬ÒªÏëͳ¼ÆÒ»¸öaction»òÕßÒ»¸öº¯Êý»òÕßij¸ö¹ý³ÌµÄÖ´ÐÐËùÏûºÄµÄʱ¼äÍùÍù¶¼Ö»ÓÐÒ»¸ö°ì·¨£ºÔ ......
.Ò»¡¢×÷Óãº
PHPÖ»ÊÇÒÔHTTPÐÒ齫HTMLÎĵµµÄ±êÍ·Ë͵½ä¯ÀÀÆ÷£¬¸æËßä¯ÀÀÆ÷¾ßÌåÔõô´¦ÀíÕâ¸öÒ³Ãæ£¬ÖÁÓÚ´«Ë͵ÄÄÚÈÝÔòÐèÒªÊìϤһÏÂHTTPÐÒéÁË£¬ÓëPHPÎÞ¹ØÁË£¬¿É²ÎÕÕhttp://www.w3.org/Protocols/rfc2616/rfc2616¡£
´«Í³µÄ±êÍ·Ò»¶¨°üº¬ÏÂÃæÈýÖÖ±êÍ·Ö®Ò»£¬²¢Ö»ÄܳöÏÖÒ»´Î¡£
Location: xxxx:yyyy/zzzz
Content-Type: xxxx/yyyy
Status: nnn xxxxxx
¶þ¡¢ÏÈÀ´Á˽âÒ»ÏÂHTTPÐÒéµÄÔË×÷·½Ê½
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
HTTPÐÒéÊÇ»ùÓÚÇëÇó£¯ÏìÓ¦·¶Ê½µÄ¡£Ò»¸ö¿Í»§»úÓë·þÎñÆ÷½¨Á¢Á¬½Óºó£¬·¢ËÍÒ»¸öÇëÇó¸ø·þÎñÆ÷£¬ÇëÇó·½Ê½µÄ¸ñʽΪ£¬Í³Ò»×ÊÔ´±êʶ·û¡¢ÐÒé°æ±¾ºÅ£¬ºó±ßÊÇ MIMEÐÅÏ¢°üÀ¨ÇëÇóÐÞÊηû¡¢¿Í»§»úÐÅÏ¢ºÍ¿ÉÄܵÄÄ ......
»¥ÁªÍøµÄ½ñÌ죬AJAXÒѾ²»ÊÇʲôİÉúµÄ´Ê»ãÁË¡£ËµÆðAJAX£¬¿ÉÄÜ»áÁ¢¼´ÏëÆðÒòRSS¶øÐËÆðµÄXML¡£XMLµÄ½âÎö£¬¿ÖÅÂÒѾ²»ÊÇʲôÄÑÌâÁË£¬ÌرðÊÇPHP5£¬´óÁ¿µÄXML½âÎöÆ÷µÄÓ¿ÏÖ£¬Èç×îÇáÁ¿¼¶µÄSimpleXML¡£²»¹ý¶ÔÓÚAJAXÀ´Ëµ£¬XMLµÄ½âÎö¸üÇãÏòÓÚǰ̨JavascriptµÄÖ§³Ö¶È¡£ÎÒÏëËùÓнâÎö¹ýXMLµÄÈË£¬¶¼»áÒòÊ÷ºÍ½Úµã¶øÍ·´ó¡£²»¿É·ñÈÏ£¬XMLÊǺܲ»´íµÄÊý¾Ý´æ´¢·½Ê½£¬µ«ÊÇÆäÁé»îǡǡÔì³ÉÁËÆä½âÎöµÄÀ§ÄÑ¡£µ±È»£¬ÕâÀïËùÖ¸µÄÀ§ÄÑ£¬ÊÇÏà¶ÔÓÚ±¾ÎĵÄÖ÷½Ç££JSON¶øÑÔ¡£
JSONΪºÎÎÎҾͲ»Öظ´¸ÅÄîÁË¡£Í¨Ë×µÄ˵£¬ËüÊÇÒ»ÖÖÊý¾ÝµÄ´æ´¢¸ñʽ£¬¾ÍÏñPHPÐòÁл¯ºóµÄ×Ö·û´®Ò»Ñù¡£ËüÊÇÒ»ÖÖÊý¾ÝÃèÊö¡£±ÈÈçÎÒÃǽ«Ò»¸öÊý×éÐòÁл¯ºó´æ·Å£¬¾Í¿ÉÒÔºÜÈÝÒ׵ķ´ÐòÁл¯ºóÓ¦Óá£JSONÒ²ÊÇÈç´Ë£¬Ö»²»¹ýËû´î½¨µÄÊǿͻ§¶ËJavascriptºÍ·þÎñ¶ËPHPµÄ½»»¥ÇÅÁº¡£ÎÒÃÇÓÃPHPÉú³ÉJSONºóµÄ×Ö·û´®£¬È»ºó°ÑÕâ¸ö×Ö·û´®´«¸øÇ°Ì¨Javascript£¬Javascirpt¾Í¿ÉÒÔºÜÈÝÒ׵Ľ«Æä·´JSONÈ»ºóÓ¦Óá£ËµÍ¨Ë׵㣬ËüÕæµÄºÜÏñÊý×é¡£
ÑÔ¹éÕý´«£¬ÈçºÎʹÓÃJSON¡£PHP5.2¿ªÊ¼ÄÚÖÃÁËJSONµÄÖ§³Ö¡£µ±È»£¬Èç¹ûµÍÓÚÕâ¸ö°æ±¾µÄ»°£¬ÄÇôÊÐÃæÉÏÓкܶàPHP°æ±¾µÄʵÏÖ£¬Ëæ±ãÏÂÒ»¸öÓþÍOKÀ²¡£ÏÖÔÚÖ÷ÒªÊÇ˵˵PHPÄÚÖÃÖ§³ÖµÄJSON¡£ºÜ¼òµ¥£¬Á½¸öº¯Êý£ºjson_encodeºÍjson_decode£¨¸úÐ ......
<?php
//µ÷ÊÔÊä³öÐÅÏ¢
$pageCount=15;
for($i=1;$i<=$pageCount;$i++){
dump(GetPageRange($i,$pageCount),$i);
}
//$currentPage µ±Ç°Ò³Âë
//$pageCount ×ÜÒ³Êý
//$leftSize ×ó²àÒ³Â뷶Χ
//$rightSize ÓÒ²àÒ³Â뷶Χ
//·µ»ØÒ³ÂëÇø¼äÊý×é
function GetPageRange($currentPage,$pageCount,$leftSize=3,$rightSize=4)
{
if($pageCount<=0 || $leftSize<0 || $rightSize<0){
return array();
}else{
$startPage=$currentPage;
$endPage=$currentPage;
while($leftSize>0){
if($startPage<=1) break;
$startPage--;
$leftSize--;
}
while($rightSize>0){
if($endPage>=$pageCount) break;
$endPage++;
$rightSize--;
}
}
return range($startPage,$endPage);
}
//µ÷ÊÔÊä³öÐÅÏ¢
//$array Ò³ÂëÇø¼äÊý×é
//$currentPage µ±Ç°Ò³Âë
function dump($array,$currentPage=0){
echo "<div style='clear:both;height:30px;'>";
echo "<li style="float:left;" mce_style="float:left;">µ±Ç°Ò³ÊÇ£º<span style='width:30px;color:red;font-weight:bold;'>".$c ......