{"id":541,"date":"2007-10-14T00:01:00","date_gmt":"2007-10-13T16:01:00","guid":{"rendered":"http:\/\/note.systw.net\/note\/?p=541"},"modified":"2023-11-04T00:02:49","modified_gmt":"2023-11-03T16:02:49","slug":"php05%e7%b0%a1%e5%96%ae%e5%88%86%e9%a0%81%e6%a6%82%e5%bf%b5%e8%88%87%e5%81%9a%e6%b3%95","status":"publish","type":"post","link":"https:\/\/systw.net\/note\/archives\/541","title":{"rendered":"PHP05\u7c21\u55ae\u5206\u9801\u6982\u5ff5\u8207\u505a\u6cd5"},"content":{"rendered":"\n

<\u6982\u5ff5\u8aaa\u660e><\/strong><\/h2>\n\n\n\n

\u7b2c\u4e00\u90e8\u4efd\uff1a\u505a\u51fa\u5206\u9801\u9023\u7d50<\/strong>
\u9996\u5148\u8981\u5148\u77e5\u9053\u7e3d\u5171\u6709\u5e7e\u7b46\u8cc7\u6599
\u5047\u8a2d$result\u662f\u5df1\u7d93\u7528mysql_query\u67e5\u597d\u7684\u7d50\u679c
$datacount = mysql_num_rows($result);
\u6240\u4ee5\u5982\u679c\u8cc7\u6599\u8868\u670923\u7b46\u8cc7\u6599
\u90a3$datacount\u7684\u503c\u5c31\u6703\u662f23;
\u63a5\u8457\u770b\u4f60\u4e00\u9801\u8981\u5217\u51fa\u5e7e\u7b46\u8cc7\u6599\uff0c\u5047\u8a2d\u4e00\u9801\u5341\u7b46
\u90a3\u5c31\u8981\u5c07\u7e3d\u8cc7\u7b46\u6578\u9664\u4ee5\uff11\uff10\u7b46\uff0c\u6709\u9918\u6578\u8981\u7121\u689d\u4ef6\u9032\u4f4d
\u9019\u6a23\u624d\u80fd\u505a\u51fa\u5b8c\u6574\u7684\u5206\u9801\uff0c\u4f8b\u5982\u4ee5\u4e0b\u9019\u6a23
$pagecount = ceil($datacount\/10);
\u6240\u4ee5$pagecount\u7684\u503c\u662f3\uff0c\u662f\u7e3d\u5171\u8981\u5206\u7684\u9801\u6578
\u63a5\u8457\u662f\u8981\u505a\u9023\u7d50\u81f3\u5404\u5206\u9801\u7684\u6309\u9215
for($i=0;$i<$pagecount;$i++){
echo ‘<a href=”‘.$PHP_SELF.’?pagenode=’.$i.'”> ‘.$i.’ <\/a>’;
}
$PHP_SELF\u662f\u8981\u9023\u7d50\u5230\u81ea\u5df1
\u56e0\u70ba$pagecount\u662f3\u6240\u4ee5\u5728html\u4e0a\u6703\u5217\u51fa\u4ee5\u4e0b\u9019\u6a23\uff08\u5047\u8a2d\u672c\u9801\u662fxx.php\uff09
<a href=”xx.php?pagenode=0″>0<\/a>
<a href=”xx.php?pagenode=1″>1<\/a>;
<a href=”xx.php?pagenode=2″>2<\/a>;
\u4e5f\u5c31\u662f\u6703\u67093\u500b\u6309\u9215<\/p>\n\n\n\n

\u7b2c\u4e8c\u90e8\u4efd\uff1a\u8655\u7406\u5206\u9801<\/strong>
\u63a5\u4e0b\u4f86
\u662f\u8981\u5beb\u7576\u9020\u8a2a\u8005\u6309\u4e0b\u4e86\u5176\u4e2d\u4e00\u500b\u6309\u9215\u7684\u8655\u7406\u904e\u7a0b
\u6211\u5011\u8981\u7528get\u4f86\u53d6\u5f97pegenode\u7684\u8b8a\u6578
\u53e6\u5916\u9084\u8981\u7d66\u4e8c\u500b\u7bc4\u570d\u7684\u8b8a\u6578\uff0c\u4f8b\u59821~10,11~20
\u6240\u4ee5\u5beb\u6cd5\u5c31\u6703\u50cf\u4ee5\u4e0b\u9019\u6a23
$above = $_GET[“pagenode”]*10+1;
$under = $above+9;
\u6240\u4ee5\u5047\u8a2d$pagenode\u662f\uff11\uff0c\u90a3$above\u5c31\u662f11\uff0cunder\u5c31\u662f20
\u78ba\u5b9a\u597d\u7bc4\u570d\u5f8c
\u5c31\u8981\u6839\u64da\u7bc4\u570d\u5217\u51fa\u8cc7\u6599\uff0c\u4f8b\u5982
while($data= mysql_fetch_row($result)){
$j++;
if($j>$above && $j<=$under){
echo “
“.$j;
print_r($data);
}
}<\/p>\n\n\n\n

<\u5be6\u969b\u5beb\u6cd5><\/strong><\/h2>\n\n\n\n

\u505a\u6cd5\uff11<\/strong>
\u4e86\u89e3\u4ee5\u4e0a\u7684\u6982\u5ff5\u8aaa\u660e\u5f8c\uff0c\u5168\u90e8\u5beb\u5728\u4e00\u8d77\u6703\u50cf\u4ee5\u4e0b\u9019\u6a23
$datacount = mysql_num_rows($result);
$pagecount = ceil($datacount\/10);<\/strong><\/p>\n\n\n\n

for($i=0;$i<$pagecount;$i++){
echo ‘<a href=”‘.$PHP_SELF.’?pagenode=’.$i.'”> ‘.$i.'<\/a> ‘;
}<\/strong><\/p>\n\n\n\n

$above = $_GET[“pagenode”]*10+1;
$under = $above+9;
while($data= mysql_fetch_row($result)){
$j++;
if($j>=$above && $j<=$under){
echo “
“.$j;
}
}<\/strong><\/p>\n\n\n\n

\u505a\u6cd5\uff12<\/strong>
\u53e6\u5916\u4e00\u7a2e\u505a\u6cd5\uff0c\u662f\u7528mysql\u7684\u8a9e\u6cd5\u76f4\u63a5\u5217\u51fa\u60f3\u8981\u5217\u51fa\u7684\u7bc4\u570d\uff0c\u5982\u4e0b
$datacount = mysql_num_rows($result);
$pagecount = ceil($datacount\/10);
for($i=0;$i<$pagecount;$i++){
echo ‘<a href=”‘.$PHP_SELF.’?pagenode=’.$i.'”> ‘.$i.'<\/a> ‘;
}<\/strong><\/p>\n\n\n\n

$above = $_GET[“pagenode”]*10;
$result = mysql_query(“select*from tablename LIMIT “.$above.” , 10″);<\/strong>
\/\/$above\u9019\u88e1\u662f\u958b\u59cb\u5217\u51fa\u7684\u4f4d\u6578\uff0c10\u662f\u8981\u5217\u51fa\u7684\u6578\u91cf
while($data= mysql_fetch_row($result)){
print_r($data);
}<\/strong>\u505a\u6cd5\uff13<\/strong>
\u82e5\u61f6\u5f97\u770b\u4e0a\u9762\u7684\u8aaa\u660e\uff0c\u53ef\u76f4\u63a5\u5957\u7528\u4ee5\u4e0b\u6539\u826f\u904e\u7684\u7a0b\u5f0f\u78bc\uff0c
ps:\u5496\u5561\u8272\u5b57\u8868\u793a\u5fc5\u9808\u8981\u7531\u4f7f\u7528\u8005\u8ca0\u8cac
ps:\u4ee5\u4e0b\u662f\u4ee5\u6293\u53d6newb\u8cc7\u6599\u8868\u4e14\u800c\u4e14\u6709id\u9019\u500b\u6b04\u4f4d\u70ba\u4f8b
mysql_connect(“localhost”,”\u5e33\u865f”,”\u5bc6\u78bc”); \/\/\u5e33\u5bc6\u8a18\u5f97\u8981\u52a0
mysql_select_db(“\u8cc7\u6599\u5eab\u540d\u7a31”); \/\/\u8cc7\u6599\u540d\u7a31\u4e5f\u8981\u8a18\u5f97\u52a0<\/p>\n\n\n\n

\/\/part 1 \u5206\u9801\u4e3b\u7a0b\u5f0f
\/\/\u8a2d\u5b9a\u4e00\u9801\u8981\u5e7e\u7b46\u8cc7\u6599
$inc[“inpnum”]=10;<\/strong>
\/\/\u8a08\u7b97newb\u8cc7\u6599\u8868\u7684\u8cc7\u6599\u6709\u5e7e\u7b46
list($datacount) = mysql_fetch_row(mysql_query(“Select count(id) as counter from newb”));<\/strong>
\/\/\u8a08\u7b97\u8981\u7528\u5230\u5e7e\u9801
$pagecount = ceil($datacount\/$inc[“inpnum”]);<\/strong>
\/\/\u505a\u51fa\u5206\u9801\u7528\u9023\u7d50
$pagenum = $_GET[“pagenum”];
if($pagenum==””) $pagenum=1;
if($pagenum > 1) $pagenumlink.= ‘<a href=”‘.$PHP_SELF.’?pagenum=’.($pagenum-1).'”>\u4e0a\u4e00\u9801<\/a>\u3000\u2018;
for($i=1;$i<=$pagecount;$i++){
$pagenumlink.='<a href=”‘.$PHP_SELF.’?pagenum=’.$i.'”>’.$i.'<\/a>\u3000’;
}
if($pagenum < $pagecount) $pagenumlink.= ‘<a href=”‘.$PHP_SELF.’?pagenum=’.($pagenum+1).'”>\u4e0b\u4e00\u9801<\/a>’;<\/strong>
\/\/\u7d66mysql\u6307\u4ee4\u7528\u4f86\u9650\u5236\u8cc7\u6599\u7b46\u6578\u7528\u7684
$sqlstartread = ($pagenum-1)*$inc[“inpnum”];<\/strong>
\/\/\u5c07$addlimit\u653e\u5728sql\u6307\u4ee4\u7684\u5f8c\u9762
$addlimit = “limit “.$sqlstartread.”,”.$inc[“inpnum”];<\/strong>
\/\/part 1 \u7d50\u675f

\/\/\u5c07newb\u7684\u8cc7\u6599\u5217\u51fa\u4f86,\u4f46\u662f\u53ea\u6293\u53d6\u90e8\u4efd\u8cc7\u6599
$result = mysql_query(“select * from newb “.$addlimit);<\/strong>
\/*
\u5df1\u7d93\u5f9emysql\u5f97\u5230\u7684$result\uff0c\u53ea\u8981\u5728\u8655\u7406$result\u5373\u53ef\uff0c\u9019\u500b\u5730\u65b9\u8981\u81ea\u5df1\u6c7a\u5b9a
*\/<\/p>\n\n\n\n

\/\/part 2 \u627e\u500b\u5730\u65b9\u653e\u5206\u9801\u6309\u9215
echo $pagenumlink ;<\/strong>
\/\/part 2\u7d50\u675f<\/p>\n","protected":false},"excerpt":{"rendered":"

<\u6982\u5ff5\u8aaa\u660e> \u7b2c\u4e00\u90e8\u4efd\uff1a\u505a\u51fa\u5206\u9801\u9023\u7d50\u9996\u5148\u8981\u5148\u77e5\u9053\u7e3d\u5171\u6709 …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[14],"tags":[],"class_list":["post-541","post","type-post","status-publish","format-standard","hentry","category-develop"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts\/541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/comments?post=541"}],"version-history":[{"count":0,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/posts\/541\/revisions"}],"wp:attachment":[{"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/media?parent=541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/categories?post=541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/systw.net\/note\/wp-json\/wp\/v2\/tags?post=541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}