DEDECMS用sql标签分页

天外飘仙

1. {dede:memberlist orderby='scores' row='30'}   
   
2.         <tr>  
   
3.           <td width="15" align="center" class="di">·</td>  
   
4.           <td height="22"  class="titleld">[field:uname/]</td>  
   
5.         </tr>  
   
6.          
   
7. {/dede:memberlist}  

复制代码

用js把dedecms的sql标签从数据库中读取的数据进行分页的方法

1. <table id="loop">   
   
2. {dede:sql sql="select * from leaveword order by lyid desc"}   
   
3. <tr class="looptr">   
   
4. <td class="loop-left-td" valign="top">   
   
5. <div class="loopdiv">姓名：[field:name/]</div>   
   
6. <div class="loopdiv">联系电话：[field:phone/]</div>   
   
7. <div class="loopdiv">Q Q：[field:qq/]</div>   
   
8. <div class="loopdiv">E-mail：[field:email/]</div>   
   
9. </td>   
   
10. <td class="loop-right-td" valign="top">   
    
11. <div class='lytitle'><strong>留言题目:[field:lytitle/]</strong><span><strong>留言时间:[field:lytime/]</strong></span></div>   
    
12. <div class='lycontent'><p><strong>留言内容:</strong></p>[field:lycontent/]</div>   
    
13. <div class='hfcontent'><p><strong>回复:</strong></p><span>[field:hfcontent/]</span></div>   
    
14. </td>   
    
15. </tr>   
    
16. {/dede:sql}   
    
17. <div id="changpage"></div>   
    
18. <script language="javascript">  
    
19. var obj,j;   
    
20. var page=0;   
    
21. var nowPage=0;//当前页   
    
22. var listNum=5;//每页显示<ul>数   
    
23. var PagesLen;//总页数   
    
24. var PageNum=4;//分页链接接数(5个)   
    
25. onload=function(){   
    
26. obj=document.getElementById("loop").getElementsByTagName("tr");   
    
27. j=obj.length   
    
28. PagesLen=Math.ceil(j/listNum);   
    
29. upPage(0)   
    
30. }   
    
31. function upPage(p){   
    
32. nowPage=p   
    
33. //内容变换 34  
    
34. for (var i=0;i<j;i++){   
    
35. obj.style.display="none"   
    
36. }   
    
37. for (var i=p*listNum;i<(p+1)*listNum;i++){   
    
38. if(obj)obj.style.display="block"   
    
39. }   
    
40. strS='<a href="###" onclick="upPage(0)">首页</a> '   
    
41. var PageNum_2=PageNum%2==0?Math.ceil(PageNum/2)+1:Math.ceil(PageNum/2)   
    
42. var PageNum_3=PageNum%2==0?Math.ceil(PageNum/2):Math.ceil(PageNum/2)+1   
    
43. var strC="",startPage,endPage;   
    
44. if (PageNum>=PagesLen) {startPage=0;endPage=PagesLen-1}   
    
45. else if (nowPage<PageNum_2){startPage=0;endPage=PagesLen-1>PageNum?PageNum:PagesLen-1}//首页   
    
46. else {startPage=nowPage+PageNum_3>=PagesLen?PagesLen-PageNum-1: nowPage-PageNum_2+1;var t=startPage+PageNum;endPage=t>PagesLen?PagesLen-1:t}   
    
47. for (var i=startPage;i<=endPage;i++){   
    
48. if (i==nowPage)strC+='<a href="###" style="color:red;font-weight:700;" onclick="upPage('+i+')">'+(i+1)+'</a> '   
    
49. else strC+='<a href="###" onclick="upPage('+i+')">'+(i+1)+'</a> '   
    
50. }   
    
51. strE=' <a href="###" onclick="upPage('+(PagesLen-1)+')">尾页</a> '   
    
52. strE2=nowPage+1+"/"+PagesLen+"页"+" 共"+j+"条"   
    
53. document  
    
54. getElementById("changpage").innerHTML=strS+strC+strE+strE2   
    
55. }   
    
56. </script>  
    
57. </table>  

复制代码