{"id":254,"date":"2019-07-09T12:02:26","date_gmt":"2019-07-09T04:02:26","guid":{"rendered":"http:\/\/www.leohe.net.cn\/?p=254"},"modified":"2019-10-18T23:35:01","modified_gmt":"2019-10-18T15:35:01","slug":"%e4%b8%8a%e7%a7%bb%e4%b8%8b%e7%a7%bb%e6%8e%92%e5%ba%8f%e5%a4%84%e7%90%86","status":"publish","type":"post","link":"https:\/\/china-abc.leohe.net.cn\/?p=254","title":{"rendered":"\u4e0a\u79fb\u4e0b\u79fb\u6392\u5e8f\u5904\u7406"},"content":{"rendered":"\n<p>SELECT<br>     * <br> FROM<br>     web_ad <br> WHERE<br>     1 = 1 <br>     AND ad_banner_pages = 7 <br>     AND ( find_in_set( 7, sub_channel ) OR find_in_set( 8, sub_channel ) ) <br> ORDER BY<br>     STATUS DESC,<br>     sort DESC <br>     LIMIT $start,<br>     2<\/p>\n\n\n\n<p style=\"text-align:left\">$start \u8868\u793a\u5f53\u524d\u8981\u79fb\u52a8\u8bb0\u5f55\u5f53\u524d\u987a\u5e8f\u7684\u7b2cN\u6761\u8bb0\u5f55,\u79fb\u52a8\u65f6\u53c2\u6570\u903b\u8f91 <\/p>\n\n\n\n<p> if ($move_type == 2) {            $start = $start - 1;        }   <br>move_type 1\u8868\u793a\u4e0b\u79fb, 2\u8868\u793a\u4e0a\u79fb<\/p>\n\n\n\n<p>\u66f4\u65b0\u903b\u8f91 :<\/p>\n\n\n\n<p> foreach ($list as $key => $unit_sort) {            $tmp_key = 0;            if ($key == 0) {                $tmp_key = 1;            }            $sort = $list[$tmp_key]['sort'];            $id = $unit_sort['id'];            $sql = \"UPDATE web_ad SET sort = \" . $sort . \" WHERE id = {$id}\";            $ret = $db->query($sql);        } <\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT * FROM web_ad WHERE 1 = 1 AND ad_banner_pages =  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[5,1],"tags":[],"_links":{"self":[{"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/posts\/254"}],"collection":[{"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=254"}],"version-history":[{"count":3,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/posts\/254\/revisions"}],"predecessor-version":[{"id":257,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=\/wp\/v2\/posts\/254\/revisions\/257"}],"wp:attachment":[{"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/china-abc.leohe.net.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}