{"id":584,"date":"2010-06-20T03:27:07","date_gmt":"2010-06-19T19:27:07","guid":{"rendered":""},"modified":"2014-03-11T22:31:15","modified_gmt":"2014-03-11T14:31:15","slug":"%e9%9a%8f%e6%9c%ba%e5%87%bd%e6%95%b0%e6%8e%92%e5%ba%8f%e5%90%8e%e5%88%86%e9%a1%b5%e5%8e%9f%e5%88%9b","status":"publish","type":"post","link":"http:\/\/www.xiaoyebailong.com\/index.php\/2010\/06\/20\/584.htm","title":{"rendered":"\u968f\u673a\u51fd\u6570\u6392\u5e8f\u540e\u5206\u9875(\u539f\u521b)"},"content":{"rendered":"

\u5728\u641c\u7d22\u7684\u65f6\u5019\u8981\u6c42\u968f\u673a\u6392\u5e8f\uff0c\u6bcf\u6b21\u6392\u5e8f\u90fd\u4e0d\u4e00\u6837<\/p>\n

\u6bd4\u5982\u4e00\u53e5sql<\/p>\n

Randomize<\/p>\n

sql=“Select * from news where lm2=’19’ order by rnd(-(id+" & rnd() & ")) desc"
\n <\/p>\n

\u8fd9\u6837\u5c31\u505a\u5230\u4e86\u968f\u673a\u6392\u5e8f\uff01\u4f46\u662f\u5728\u5206\u9875\u4e2d\u7531\u4e8e\u6bcf\u6b21\u63d0\u4ea4\u4e2d\u542b\u5206\u7c7blm2=’19’<\/p>\n

\u6bcf\u5237\u65b0\u4e00\u6b21\u90a3\u4e48rnd ()\u90fd\u4f1a\u53d8<\/p>\n

\u5206\u9875\u7684\u4e0b\u4e00\u9875\u6570\u636e\u4f1a\u548c\u4e0a\u4e00\u9762\u6709\u91cd\u590d\u7684\u6570\u636e\u5b58\u5728<\/p>\n

*\u601d\u8def\u8ba9\u968f\u673a\u51fd\u6570\u56fa\u5b9a\u5c31\u884c\u4e86<\/p>\n

\u5728\u63d0\u4ea4\u9875\u9762\u4e0a\u5199\u4e0a<\/p>\n

<%
\nRandomize
\nrn=rnd()
\n%><\/p>\n

<input name="rn" type="hidden" value="<%=rn%>" size="20"\/>
\n\u56e0\u4e3a\u641c\u7d22\u6846\u9875\u9762\u6240\u4ee5\u5199\u4e2a\u9690\u85cf\u7684\u51fd\u6570\u63d0\u4ea4<\/p>\n

\u7136\u540e\u6570\u636e\u663e\u793a\u9875\u9762sql\u8bed\u53e5\u4e2d\u5199<\/p>\n

\u5f53\u7136\u5199\u4e0a\u63a5\u6536\u51fd\u6570rn=request("rn")<\/p>\n

sql=“Select * from news where lm2=’19’ order by rnd(-(id+" & rn & ")) desc"<\/p>\n

\u5206\u9875\u5904\u5199?page=<%=page%>&rn=<%=rn%><\/p>\n

\u8fd9\u6837\u6bcf\u5206\u9875\u7684\u65f6\u5019\u90fd\u6709\u8fd9\u4e2a\u51fd\u6570\uff0c\u56fa\u5b9a\u51fd\u6570\u6765\u5206\u9875\u5c31\u884c\u4e86\uff01<\/p>\n

\u5728\u5237\u65b0\u641c\u7d22\u9875\u9762\u7684\u65f6\u5019\u968f\u673a\u51fd\u6570\u662f\u53d8\u5316\u7684\uff01\u4e5f\u5c31\u662f\u8bf4\uff0c\u6bcf\u6b21\u6253\u5f00\u641c\u7d22\u9875\u9762\uff0c\u7136\u540e\u5728\u63d0\u4ea4\u7684\u51fd\u6570\u4e0d\u4e00\u6837\uff0c\u663e\u793a\u6570\u636e\u7684\u9875\u9762\u5c31\u8ddf\u7740\u53d8\u5316\u3002<\/p>\n

\u6211\u627e\u4e86\u5f88\u4e45\u7f51\u7edc\u4e0a\u90fd\u6ca1\u6709\u4e2a\u89e3\u6cd5\uff0c\u6240\u4ee5\u81ea\u5df1\u6309\u81ea\u5df1\u7684\u601d\u8def\u5199\u4e86\uff0c\u4e0d\u77e5\u9053\u4ee5\u524d\u6709\u6ca1\u6709\u4eba\u5199\u8fc7\uff0c\u53cd\u6b63\u6211\u662f\u81ea\u5df1\u60f3\u51fa\u6765\u7684\uff01\u7b80\u5355\u5feb\u901f\u7684\u65b9\u6cd5\u968f\u673a\u6392\u5e8f\u5206\u9875\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u5728\u641c\u7d22\u7684\u65f6\u5019\u8981\u6c42\u968f\u673a\u6392\u5e8f\uff0c\u6bcf\u6b21\u6392\u5e8f\u90fd\u4e0d\u4e00\u6837 \u6bd4\u5982\u4e00\u53e5sql Randomize sql=“Select * from news where lm2=’19’ order by rnd(-(id+…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"topic":[],"class_list":["post-584","post","type-post","status-publish","format-standard","hentry","category-technology"],"_links":{"self":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/comments?post=584"}],"version-history":[{"count":1,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/584\/revisions"}],"predecessor-version":[{"id":66426,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/584\/revisions\/66426"}],"wp:attachment":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media?parent=584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/categories?post=584"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/tags?post=584"},{"taxonomy":"topic","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/topic?post=584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}