{"id":99,"date":"2023-01-11T08:26:49","date_gmt":"2023-01-11T00:26:49","guid":{"rendered":"https:\/\/mianka.xyz\/?p=98"},"modified":"2023-01-11T10:30:56","modified_gmt":"2023-01-11T02:30:56","slug":"thinkphp6-layui","status":"publish","type":"post","link":"https:\/\/www.mianka.xyz\/?p=99","title":{"rendered":"thinkphp6 \u5927\u6570\u636e\u5206\u9875\uff0c\u8ba1\u7b97\u5206\u9875\u603b\u91cf\uff0clayui\u5206\u9875"},"content":{"rendered":"

\u5b98\u65b9\u6587\u6863\u7ed9\u7684\u89e3\u51b3\u65b9\u6cd5\uff1a<\/p>\n

$list = Db::name('user')->where('status',1)->paginateX(50);<\/pre>\n
\u4f46\u8fd9\u4e2a\u65b9\u6cd5\u80fd\u5206\u9875\uff0c\u4e0d\u80fd\u7ed9\u51fa\u603b\u6570\u6765\uff0c\u6240\u4ee5\u603b\u6570\u9700\u8981\u81ea\u5df1\u7b97\u4e00\u4e0b\u3002<\/p>\n
$page = intval(Db::query("SELECT COUNT(*) FROM user")[0]['COUNT(*)']\/50);<\/pre>\n
\u5b8c\u6574\u4ee3\u7801\u5b9e\u4f8b\uff1a<\/p>\n
public function czl()\n{\n    $list = Db::name('user')->order('update_time', 'desc')->where('state',1)->paginateX(50);\n    \/\/\u8ba1\u7b97\u603b\u91cf\n    $page = intval(Db::query("SELECT COUNT(*) FROM user")[0]['COUNT(*)']\/50);\n    \/\/\u6e32\u67d3\u6a21\u677f\u8f93\u51fa\n    return view('show', ['list' => $list, 'page' => $page]);\n}<\/pre>\n
\u524d\u7aeflayui\u4ee3\u7801\uff1a<\/p>\n
<div id="pager"><\/div>\n<script src="\/static\/layui.js"><\/script>\n<script>\n    layui.use('laypage', function(){\n      var laypage = layui.laypage;\n      \/\/\u6267\u884c\u4e00\u4e2alaypage\u5b9e\u4f8b\n      laypage.render({\n        elem: 'pager' \/\/\u6ce8\u610f\uff0c\u8fd9\u91cc\u7684 test1 \u662f ID\uff0c\u4e0d\u7528\u52a0 # \u53f7\n        ,count: {$page} \/\/\u6570\u636e\u603b\u6570\uff0c\u4ece\u670d\u52a1\u7aef\u5f97\u5230\n        ,limit:50\n        ,jump: function(obj, first){\n            if(!first){\n                \/\/ layer.msg('\u7b2c'+ obj.curr +'\u9875');\n                window.location.href="\/show?page="+obj.curr;\/\/\u5411URL\u4e2d\u4f20\u9012\u9875\u6570\u5e76\u663e\u793a\n            }}\n        });\n    });\n<\/script><\/pre>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5b98\u65b9\u6587\u6863\u7ed9\u7684\u89e3\u51b3\u65b9\u6cd5\uff1a$list=Db::name('user')-&gt…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[9,24],"class_list":["post-99","post","type-post","status-publish","format-standard","hentry","category-phpbiji","tag-php","tag-thinkphp"],"_links":{"self":[{"href":"https:\/\/www.mianka.xyz\/index.php?rest_route=\/wp\/v2\/posts\/99","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mianka.xyz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mianka.xyz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mianka.xyz\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mianka.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=99"}],"version-history":[{"count":0,"href":"https:\/\/www.mianka.xyz\/index.php?rest_route=\/wp\/v2\/posts\/99\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.mianka.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=99"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mianka.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=99"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mianka.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}