自动转换静态表格(php+ mysql)

85 篇文章 6 订阅
<?php 
include("config.php");
if(empty($_SESSION['username'])){
	header("Location: index.php");
    exit;
}
$datausername=_REQUEST('datausername');
$title=_REQUEST('title');
$project=_REQUEST('project');
$starttime=_REQUEST('starttime');
$endtime=_REQUEST('endtime');
$so_tpye=_REQUEST('so_tpye');
$tid=_get('tid');
//$tid=$_GET['tid']; 
$pages=_get('page');
if($pages==""){
    $pages=1;
}else{
    $pages=$pages;	
}



require_once('page.class.php'); //分页类  
$showrow = 10; //一页显示的行数  
$curpage = empty($_GET['page']) ? 1 : $_GET['page']; //当前的页,还应该处理非数字的情况  
$url = "?page={page}"; //分页地址,如果有检索条件 ="?page={page}&q=".$_GET['q']  
//省略了链接mysql的代码,测试时自行添加  
//$sql = "SELECT * FROM data_type"; 


//$sk7=" and DATE_FORMAT(hr_position.time_up, '%Y-%m-%d %H:%M%S') >= '$starttime' and DATE_FORMAT(hr_position.time_up, '%Y-%m-%d %H:%M%S') <= '$endtime' ";
//$project="注册学籍";
if($project!="" || $title!="" || $time!="" || $starttime!="" || $endtime!=""){
   $w="WHERE";	
   $a4=" and ";//s4
}else{
		if (strpos($e_manage,"13")!=false || strpos($e_manage,"14")!=false){//没有限制
			  $w="";	
		}else{
              $w="WHERE";	
		}
   $a4="";
  // $w="";	
}


if($project!=""){
	$s1=" project='$project' ";
	$a1=" and ";
}else{
	$s1="";	
	$a1="";	
}
//$s1=" project='$project' ";
 
if($title!=""){
	if($so_tpye!=""){
	    $s2=$a1." $so_tpye like '%$title%'";
	}else{
	   echo("<script type='text/javascript'> alert('请选择一个字段!');history.back();</script>");
	   exit; 
	   $s2="";
	}
}else{
	$s2="";	
}


if($starttime!="" && $endtime!=""){
	if($title!="" || $project!="" || $so_tpye!=""){
		$a2=" and ";
	}else{
		$a2="";	
	}	
		
	$s3=$a2." time >= '$starttime' and time <= '$endtime' ";
}else{
	$s3="";	
}

if (strpos($e_manage,"13")!=false || strpos($e_manage,"14")!=false){//没有限制
     $s4="";
}else{
    $user_name=$_SESSION['username'];
	$s4=$a4."admin_name='$user_name'";
}
$datausername2=$e_datausername."data_guestbook";
$sql = "SELECT * FROM ".$datausername2." $w $s1 $s2 $s3 $s4 order by id desc";
//$sql = "SELECT * FROM data_guestbook $w $s1 $s2 $s3 order by id desc";

$total = mysqli_num_rows(mysqli_query($conn, $sql)); //记录总条数  
if (!empty($_GET['page']) && $total != 0 && $curpage > ceil($total / $showrow))  
    $curpage = ceil($total_rows / $showrow); //当前页数大于最后页数,取最后一页  
//获取数据  
$sql .= " LIMIT " . ($curpage - 1) * $showrow . ",$showrow;";  
$query = mysqli_query($conn, $sql);
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>留言管理</title>
<link rel="stylesheet" href="css/style.css" type="text/css"/>
<link rel="stylesheet" href="layui/css/layui.css" type="text/css"/>
<script type="text/javascript" src="http://libs.baidu.com/jquery/1.8.3/jquery.min.js"></script>
<script src="layui/layui.js"></script>
</head>

<body>
<div class="layui-form" style="padding-left:30px;">
<blockquote class="layui-elem-quote">
     <form class="layui-form" action="">
            <input type="hidden" id="tid" name="tid" value="<?php echo $tid?>">
              <div class="layui-form-item" >
                <div class="layui-inline">
                  <!--<label class="layui-form-label">当前页数:</label>-->
                  <div class="layui-input-inline2">
                    <button id="pages" name="pages" class="layui-btn layui-btn-primary layui-btn-sm">当前页数:<?php echo $pages?></button>
                  </div>
                </div>
                <div class="layui-inline">
                  <!--<label class="layui-form-label">分组标题:</label>-->
                    <div class="layui-input-inline">
                        <select name="project" lay-verify="">
                               <option value="">选择一个项目</option>
                              <option value="注册学籍">注册学籍</option>
                        </select>  
                    </div>
                    <div class="layui-input-inline">
                        <select name="so_tpye" lay-verify="">
                          <option value="" <?php if($so_tpye==""){?>selected<?php }?>>选择一个字段</option>
                          <option value="ad" <?php if($so_tpye=="ad"){?>selected<?php }?>>推广渠道</option>
                          <option value="phone" <?php if($so_tpye=="phone"){?>selected<?php }?>>电话</option>
                          <option value="title" <?php if($so_tpye=="title"){?>selected<?php }?>>标题</option>
                          
                          <option value="content" <?php if($so_tpye=="content"){?>selected<?php }?>>备注</option>
                          <option value="username" <?php if($so_tpye=="username"){?>selected<?php }?>>学员名称</option>
                          <option value="qq" <?php if($so_tpye=="qq"){?>selected<?php }?>>QQ</option>
                          <option value="wx" <?php if($so_tpye=="wx"){?>selected<?php }?>>微信号</option>
                          
                          <option value="email" <?php if($so_tpye=="email"){?>selected<?php }?>>Email</option>
                          <option value="url" <?php if($so_tpye=="url"){?>selected<?php }?>>网址</option>
                          <option value="admin_name" <?php if($so_tpye=="admin_name"){?>selected<?php }?>>负责人</option>
                          <option value="type1" <?php if($so_tpye=="type1"){?>selected<?php }?>>分类1</option>
                          
                          <option value="type2" <?php if($so_tpye=="type2"){?>selected<?php }?>>分类2</option>
                          <option value="type3" <?php if($so_tpye=="type3"){?>selected<?php }?>>分类3</option>

                        </select>  
                    </div>
                  <div class="layui-input-inline">
                    <input type="text" name="title" id="title" placeholder="请输入查询内容" autocomplete="off" class="layui-input" value="<?php echo $title?>">   
                  </div>
                  <div class="layui-input-inline">
                    <input name="starttime" id="starttime" class="layui-input" placeholder="开始时间"  value="<?php echo $starttime?>">   
                  </div>
                  <div class="layui-input-inline">
                    <input name="endtime" id="endtime" class="layui-input" placeholder="结束时间"  value="<?php echo $endtime?>">   
                  </div>
                </div>
                <div class="layui-inline">

                  <div class="layui-input-inline">
                    <button class="layui-btn">立即查询</button>
                  </div>
                </div>
              </div>
      </form>
</blockquote>
</div>
<div class="layui-form" style="padding-left:30px;" >
  <table class="layui-table" lay-filter="parse-table-demo" lay-data="{id:'idTest'}">
    <colgroup>
      <col width="10">
      <col width="100">
      <col width="90">
      <col width="100">
      
      <col width="200">
      <col width="300">
      <col width="100">
      <col width="100">
      
      <col width="100">
      <col width="100">
      <col width="100">
      <col width="100">
      <col width="100">
      <col width="100">

      <col width="100">
      <col width="100">
      <col width="100">
      <col width="100">
      <col width="100">
      <col width="100">
      
      <col width="100">
      <col width="100">      
      <col width="100">
      <col width="100">
      <col>
    </colgroup>
    <thead>
      <tr>
        <th lay-data="{field:'id',type:'checkbox'}"></th>
        <th lay-data="{field:'project'}">项目</th>
        <th lay-data="{field:'phone'}">电话</th>
        <th lay-data="{field:'username'}">学员名称</th>
         
        <th lay-data="{field:'checkbox1'}">出生日期</th>
        <th lay-data="{field:'type1'}">性别</th>
        <th lay-data="{field:'type2'}">证件类型</th>
        <th lay-data="{field:'checkbox2'}">证件号码</th>
        
        <th lay-data="{field:'qq'}">QQ</th>
        <th lay-data="{field:'email'}">Email</th>
        <th lay-data="{field:'checkbox3'}">户籍/省市</th>
        <th lay-data="{field:'checkbox4'}">紧急联系人</th>
        <th lay-data="{field:'checkbox5'}">联系电话</th>
        <th lay-data="{field:'type3'}">最高学历</th>
        
        <th lay-data="{field:'ad'}">毕业时间</th>
        <th lay-data="{field:'type4'}">学历形式</th>
        <th lay-data="{field:'title'}">毕业院校</th>
        <th lay-data="{field:'content'}">所学专业</th>
        <th lay-data="{field:'type5'}">海外学历</th>
        <th lay-data="{field:'c1'}">户口</th>
        
        <th lay-data="{field:'url'}">网址</th>
        <th lay-data="{field:'ip'}">客户IP</th>
        <th lay-data="{field:'admin_name'}">负责人</th>
        <th lay-data="{field:'time'}">留言日期</th>
        
        <th lay-data="{fixed: 'right', width:178, align:'center', toolbar: '#barDemo'}"></th>
      </tr> 
    </thead>
    <tbody>
<?php while($row = mysqli_fetch_assoc($query)) { ?>  
      <tr>
        <td><?php echo $row["id"]?></td>
        <td><?php echo $row["project"]?></td>
        <td><?php echo $row["phone"]?></td>
        <td><?php echo $row["username"]?></td>
        
        <td><?php echo $row["checkbox1"]?></td>
        <td><?php echo $row["type1"]?></td>
        <td><?php echo $row["type2"]?></td>
        <td><?php echo $row["checkbox2"]?></td>

        <td><?php echo $row["qq"]?></td>
        <td><?php echo $row["email"]?></td>
        <td><?php echo $row["checkbox3"]?></td>
        <td><?php echo $row["checkbox4"]?></td>
        <td><?php echo $row["checkbox5"]?></td>
        <td><?php echo $row["type3"]?></td>
        
        <td><?php echo $row["ad"]?></td>
        <td><?php echo $row["type4"]?></td>
        <td><?php echo $row["title"]?></td>
        <td><?php echo $row["content"]?></td>
        <td><?php echo $row["type5"]?></td>
        <td><?php echo $row["c1"]?></td>

        <td><?php echo $row["url"]?></td>
        <td><?php echo $row["ip"]?></td>
        <td><?php echo $row["admin_name"]?></td>
        <td><?php echo $row["time"]?></td>

      </tr>
<?php } ?>  
    </tbody>
  </table>
<script type="text/html" id="barDemo">
  <a class="layui-btn layui-btn-primary layui-btn-xs" lay-event="detail">查看</a>
  <a class="layui-btn layui-btn-xs" lay-event="edit">编辑</a>
  <a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>
</script>
</div>
<fieldset class="layui-elem-field layui-field-title" style="margin-top: 20px;">
  <legend>
    <div class="layui-btn-group demoTable">
      <a class="layui-btn" href="reg.php?tid=<?php echo $tid?>&title="><i class="layui-icon">ဂ</i>刷新</a>
      <button class="layui-btn layui-btn-warm" data-type="viweData" ><i class="layui-icon"></i>查看详情</button>
      <button class="layui-btn layui-btn-normal" data-type="exportData" ><i class="layui-icon"></i>导出</button>
      <button class="layui-btn layui-btn-danger" data-type="delData" ><i class="layui-icon"></i>删除</button>

    </div>
  <!--<a class="layui-btn" href="reg.php?tid=<?php echo $tid?>&title="><i class="layui-icon">ဂ</i>刷新</a><button id="guestbook_viwe_Ajax" class="layui-btn layui-btn-warm"><i class="layui-icon"></i>查看详情</button><button id="export_excel" class="layui-btn layui-btn-normal">导出</button><button  id="testAjax"  class="layui-btn layui-btn-danger"><i class="layui-icon"></i>删除</button><a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del">删除</a>-->
  </legend>
</fieldset>

<div class="showPage" style="padding-left:30px;">  
<?php  
if ($total > $showrow) {//总记录数大于每页显示数,显示分页  
	$page = new page($total, $showrow, $curpage, $url, 2);  
	echo $page->myde_write();  
} 
mysqli_close($conn); 
?>  
</div>
<script>
layui.use(['layer', 'form','element','jquery','layer','table'], function(){
      var layer = layui.layer
      ,form = layui.form
      ,element = layui.element
      ,$= layui.$
      ,table=layui.table;
	  
      //转换静态表格
      table.init('parse-table-demo', {
        height: '400' //设置高度
        ,limit: 10 //注意:请务必确保 limit 参数(默认:10)是与你服务端限定的数据条数一致
        //支持所有基础参数
      });
	  
  //监听表格复选框选择
  table.on('checkbox(parse-table-demo)', function(obj){
    console.log(obj)
  });
  //监听工具条
  table.on('tool(parse-table-demo)', function(obj){
    var data = obj.data;
    if(obj.event === 'detail'){
      layer.msg('ID:'+ data.id + ' 的查看操作');
    } else if(obj.event === 'del'){
      layer.confirm('真的删除行么', function(index){
        obj.del();
        layer.close(index);
      });
    } else if(obj.event === 'edit'){
      layer.alert('编辑行:<br>'+ JSON.stringify(data))
    }
  });
  
//删除 
  var $ = layui.$, active = {
    delData: function(){ //删除
      var checkStatus = table.checkStatus('idTest')
	  var dataall='';
      data = checkStatus.data;
	  //循环把所有要删除的ID整成12,13,545
	  for(var i=0;i<checkStatus.data.length;i++){
			 dataall += data[i].id+",";
		}
		dataall=dataall.substring(0,dataall.length-1)
			  var pages =$("#pages").text();
			  var title =$("#title").val();
			  
            //Ajax调用处理
            var html = $.ajax({
               type: "POST",
               url: "type_save.php",
               data: "action=guestbook_dell&tid=<?php echo $tid?>&all_id="+dataall+"&pages="+pages+"&title="+title,//在php中data: "name=$tt&id=$id&content="+text,
               async: false


            }).responseText;
			   //成功后返回来的参数 弹出窗口
						     layer.ready(function(){ 
								    layer.msg(html);
									  setTimeout(function(){//两秒后跳转   
										 location.href = "reg.php?tid=<?php echo $tid?>&page=<?php echo $pages?>&title=<?php echo $title?>";//PC网页式跳转    
									  },2000); 
		                      });
		
      //layer.alert(JSON.stringify(data));
    }
	
//查看数据	
    ,viweData: function(){ 
      var checkStatus = table.checkStatus('idTest')
	  var id='';
      data = checkStatus.data;
	  //取得ID
			id += data[0].id;
			layer.ready(function(){ 
				  layer.open({
					type: 2,
					title: '查看详情',
					maxmin: true,
					area: ['800px', '680px'],
					content: 'guestbook_show.php?datausername=<?php echo $datausername?>&action=show&tid=<?php echo $tid?>&id='+id,

				  });
			});
     // layer.msg('选中了:'+ data.length + ' 个');
    }
	
//导出	
    ,exportData: function(){ 
      var checkStatus = table.checkStatus('idTest')
      data = checkStatus.data;
	  //循环把所有要删除的ID整成12,13,545
			layer.ready(function(){ 
				  layer.open({
					type: 2,
					title: '导出数据',
					maxmin: true,
					area: ['600px', '300px'],
					content: 'export_excel.php?action=export_excel&tid=<?php echo $tid?>&title=<?php echo $title?>&so_tpye=<?php echo $so_tpye?>&project=<?php echo $project?>&starttime=<?php echo $starttime?>&endtime=<?php echo $endtime?>',

				  });
			});
     // layer.msg('选中了:'+ data.length + ' 个');
    }
    ,getCheckLength: function(){ //获取选中数目
      var checkStatus = table.checkStatus('idTest')
      ,data = checkStatus.data;
      layer.msg('选中了:'+ data.length + ' 个');
    }
    ,isAll: function(){ //验证是否全选
      var checkStatus = table.checkStatus('idTest');
      layer.msg(checkStatus.isAll ? '全选': '未全选')
    }
  };
  
  $('.demoTable .layui-btn').on('click', function(){
    var type = $(this).data('type');
    active[type] ? active[type].call(this) : '';
  });
});
</script>

<!--<script type="text/javascript">
$(function(){
  
        //查看详情
      $("#guestbook_viwe_Ajax").click(function(){
            //取得选中的多项值
            var id="";
            $("input[name='checkbox']:checkbox").each(function(){ 
                if($(this).attr("checked")){
                    id = $(this).val()
                }
            })
			  
			//var id =$("input[name='checkbox']:checkbox").val();
			layer.ready(function(){ 
				  layer.open({
					type: 2,
					title: '查看详情',
					maxmin: true,
					area: ['800px', '680px'],
					content: 'guestbook_show.php?datausername=<?php echo $datausername?>&action=show&tid=<?php echo $tid?>&id='+id,

				  });
			});
      });
        //删除
      $("#testAjax").click(function(){
            //取得选中的多项值
            var str="";
            $("input[name='checkbox']:checkbox").each(function(){ 
                if($(this).attr("checked")){
                    str += $(this).val()+","
                }
            })
			  
			  var pages =$("#pages").text();
			  var title =$("#title").val();
			  
            //Ajax调用处理
            var html = $.ajax({
               type: "POST",
               url: "type_save.php",
               data: "action=guestbook_dell&tid=<?php echo $tid?>&all_id="+str+"&pages="+pages+"&title="+title,//在php中data: "name=$tt&id=$id&content="+text,
               async: false


            }).responseText;
			   //成功后返回来的参数 弹出窗口
                    //$("#myDiv").html('<h2>'+html+'</h2>');
						     layer.ready(function(){ 
								    layer.msg(html);
									  setTimeout(function(){//两秒后跳转   
										 location.href = "reg.php?tid=<?php echo $tid?>&page=<?php echo $pages?>&title=<?php echo $title?>";//PC网页式跳转    
									  },2000); 
		                      });
      }); 
	  
		//导出
		$('#export_excel').on('click', function(){
			layer.ready(function(){ 
				  layer.open({
					type: 2,
					title: '导出数据',
					maxmin: true,
					area: ['600px', '300px'],
					content: 'export_excel.php?action=export_excel&tid=<?php echo $tid?>&title=<?php echo $title?>&so_tpye=<?php echo $so_tpye?>&project=<?php echo $project?>&starttime=<?php echo $starttime?>&endtime=<?php echo $endtime?>',

				  });
			});
		});
		
 });
</script> -->
</body>
</html>



纯HTML案例:

http://blog.csdn.net/haibo0668/article/details/78653750


  • 1
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值