Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : php

php+mysql×¢ÉäÓï¾ä¹¹Ôì¼¼Êõ

ºÚ¿ÍÈëÃż¼ÊõÖ®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×¢ÉäÓï¾ä¹¹Ôì¼¼Êõ

ºÚ¿ÍÈëÃż¼ÊõÖ®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ÈëÃÅÖ¸µ¼£ºÈçºÎѧϰPHP£¿

ÿ¸öÈ˵Äѧϰ·½Ê½²»Í¬£¬Ð´ÕâÆªÎÄÕµÄÄ¿µÄÊÇ·ÖÏíÒ»ÏÂ×Ô¼ºµÄѧϰ¹ý³Ì£¬½ö¹©²Î¿¼£¬²»ÒªÒ»Î¶µÄÓñðÈ˵Äѧϰ·½·¨£¬ÕÒ¶Ô×Ô¼ºÓÐÓõÄѧϰ·½Ê½
¾­³£ÔÚijЩÂÛ̳ºÍQQȺÀï¿´µ½Ò»Ð©ÅóÓÑ»áÎÊ“ÔõÑù²ÅÄÜѧºÃPHP£¬ÔõÑù²ÅÄÜѧºÃ***ÓïÑÔ ”£¬µ«±ðÈ˻شð×î¶àµÄÊÇ£º´Ó×òµ¥”µÄ¿ªÊ¼¡£
Õâ¸ö¼òµ¥Ò²ÐíÕæµÄ²»¼òµ¥£¬ºÇºÇ¡£ÏÂÃæÎÒÏë·ÖÏíÒ»ÏÂ×Ô¼ºÑ§Ï°µÄһЩ¹ý³Ì¡£ÏÈ˵Щ·Ñ»°£¬ÓïÑÔ×éÖ¯ÄÜÁ¦²î£¬ËµÁ˲»ÉÙ·Ñ»°£¬Ô¸Òâ¿´µÄ¾Í¿´£¬²»ÒªÂîÎÒ¾ÍÐÐ
ÆäʵѧϰһÃÅÐÂÓïÑÔ²¢²»ÊÇÌ«ÄÑ£¬ÖØÒªµÄÊÇÄãÓÐûÓÐ×¼±¸ºÃȥѧºÃËü£¬Ê±¼äµÄ³¤¶ÌºÍ¸öÈ˵ÄÄÜÁ¦ºÍ¾öÐÄÓйء£ºÚ¿Í½çÒ²Á÷ÐÐÒ»¾ä»°¾ÍÊǓûÓÐÈëÇÖ²»Á˵ļÆËã»ú”£¬Õâ¾ä»°´ó¸ÅµÄÒâ˼ÊÇ˵£ºÈç¹ûÄãµÄ¼¼Êõ±Èά»¤Õą̂¼ÆËã»úµÄ¹ÜÀíÔ±¸üʤһ³ï£¬ÄÇô¾ÍÄÜÄÃÏÂÕą̂¼ÆËã»úÉõÖÁÄÜÄÃÏÂÕâ¸ö¹ÜÀíÔ±¹ÜÀíµÄËùÓмÆËã»ú£¬Èç¹û¼¼²»ÈçÈË£¬Ö»ÄܼÌÐøÑ§Ï°³¬¹ý¶Ô·½¡£ÎÒ˵ÕâЩ»°µÄÒâ˼¾ÍÊÇÈÃ×¼±¸Ñ§Ï°Ä°ÉúÓïÑÔÅóÓÑÒ»¶¨ÒªÏ¾öÐÄȥѧϰ£¬Ö»ÒªÄãÏÂÁ˾öÐÄȥѧÁË£¬¾ÍÒ»¶¨ÄÜѧºÃ£¬Ç§Íò²»Òª°ë;¶ø·Ï¡££¨ÍËÒ»Íò²½À´Ëµ£¬¼´Ê¹ÊÇûѧºÃ£¬µ«Äã¶®µÄ±ØÈ»±È±ðÈ˶ࣩ
Á˽âʲôÊÇ×î¼òµ¥:
1¡¢ÍøÒ³µÄ»ù±¾¹¹³É¾ÍÊÇhtml´úÂë,ËùÒÔ±ØÐëÊìϤHTML/CSS/JSµÈ»ù±¾ÔªËØ
2¡¢ÊìϤPHPÓï·¨£¬Á˽âPHP ......

PHPÖÐmicrotime()º¯Êý ÄÏÈý·½

Ê×ÏȽéÉÜһϴ˺¯ÊýµÄÓ÷¨£º
¶¨ÒåºÍÓ÷¨£¨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 header() º¯ÊýÏê½â ÄÏÈý·½

.Ò»¡¢×÷Ó㺠 
         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ÐÅÏ¢°üÀ¨ÇëÇóÐÞÊηû¡¢¿Í»§»úÐÅÏ¢ºÍ¿ÉÄܵÄÄ ......

PHPÖÐJSONµÄÓ¦Óà ÄÏÈý·½

»¥ÁªÍøµÄ½ñÌ죬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·ÖÒ³´úÂë

<?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 ......
×ܼǼÊý:2174; ×ÜÒ³Êý:363; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [153] [154] [155] [156] 157 [158] [159] [160] [161] [162]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ