• 分页显视


      CSS 样式

    #fen{  position:absolute; float:left; margin-left:190px; bottom:7px;;}
    input{ margin:0px;}
    .list,.dangqian{ font-size:13px;  display:block; 35px; height:35px; text-align:center; vertical-align:middle; line-height:35px; float:left; border:1px solid #9DFFFF; margin:1px;}
    #prev,#next{   text-align:center; vertical-align:middle; line-height:35px; float:left;  margin:1px; font-size:18px;}
    .list:hover{ cursor:pointer}
    #prev:hover{ cursor:pointer}
    #next:hover{ cursor:pointer}
    .dangqian{ background-color:#bce8f1; color:#0C0;}
    #name{font-size:16px;}
    #hywz{ color:#46b8da; font-size:14px;}
    
         <table class="table table-striped">
                      <thead>
                        <tr>
                          <th style="text-align:center;">发件人</th>
                          <th style="text-align:center;">主题</th>
                          <th style="text-align:center;">时间</th>
                          <th style="text-align:center;">操作</th>
                        </tr>
                      </thead>
                      <tbody id="nlck">
                  
                      </tbody>
                    </table>
    				<div id="fen">
                    	<!--<ul class="pagination " id="fen">
    
    					</ul>-->
                    </div>
    

     <script>代码

    <script>
    //fenyexianshi
    var page = 1;
    var num = 11;
    
    shuju();
    
    FenYe();
    function shuju()
    {
    	$.ajax({
    		url:"fychuli.php",
    		data:{page:page,num:num},
    		type:"POST",
    		dataType:"JSON",
    		success: function(data){
    			var str = "";
    			/*var shan="<a href='Xxcksh_cl.php?id={"+data[k].id+"}'><button class='btn btn-danger' >删除</button></a>";*/
    		for(var k in data)
    			{
    		str = str + "<tr><td>"+data[k].fa+"</td><td>"+data[k].biaoti+"</td><td>"+data[k].time+"</td><td style='padding:0px;line-height:36px;'><button class='btn btn-success' data-toggle='modal' data-target='#myModal' onclick='chakan("+data[k].id+")'>查看</button><a href='Xxcksh_cl.php?id="+data[k].id+"'><button class='btn btn-danger' >删除</button></a></td></tr>";
    			}
    			$("#nlck").html(str);
    		}	
    	});
    }
    function FenYe()
    {
    	
    	var s = "";
    
    	s = "<span id='prev'><<</span>";
    
    	var zts = 0;
    	$.ajax({
    		async:false,
    		url:"ztshu.php",
    		dataType:"TEXT",
    		success: function(data){
    			zts = data;
    		}
    
    	});
    	
    	
    	var zys = Math.ceil(zts/num);
    	
    	page = parseInt(page);
    	for( var i=page-2;i<page+3;i++)
    	{
    		if(i>0 && i<=zys)
    		{
    			if(i==page)
    			{
    				s = s+"<span ys='"+i+"' class='dangqian'>"+i+"</span>";
    			}
    			else
    			{
    				s = s+"<span ys='"+i+"' class='list'>"+i+"</span>";
    			}
    			
    		}
    	}
    	
    	
    	s = s+"<span id='next'>>></span>";
    	
    	$("#fen").html(s);
    	
    	
    	$("#prev").click(function(){
    		page = parseInt(page);
    		if(page>1)
    		{page--;}
    		
    		shuju();
    		
    		FenYe();
    	})
    	
    	$("#next").click(function(){
    		page = parseInt(page);
    		if(page<zys)
    		{page++;}
    		
    		
    		shuju();
    		
    		FenYe();
    	})
    	
    	
    	$(".list").click(function(){
    		page = parseInt($(this).attr("ys"));
    	
    		shuju();
    		
    		FenYe();
    	})
    }
    
    </script>
    

     PHP处理页面

    <?php
    require "../class/XiangMu.class.php";
    $db = new xiangmu();
    $sql = "select count(*) from tongxin";// 查询总数据总条数
    echo $db->strquery($sql);
    
    <?php
    $page = $_POST["page"];
    $num = $_POST["num"];
    require "../class/XiangMu.class.php";
    $db = new xiangmu();
    $tguo = ($page-1)*$num;
    $sql = "select * from tongxin limit {$tguo},{$num}";
    echo $db->jsonquery($sql);
    
  • 相关阅读:
    idea设置tomcat虚拟路径的两种方法
    改变javahome但是java version并没有修改的解决方案
    1. 两数之和
    88. 合并两个有序数组
    53. 最大子数组和(欠分治法)
    【记录】orcle安装
    191. 位1的个数
    【记录】plsql安装
    IP2region离线解析IP地址
    flink 常用命令
  • 原文地址:https://www.cnblogs.com/yi11/p/7008779.html
Copyright © 2020-2023  润新知