<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8" />
<title>Flexigrid</title>
<link rel="stylesheet" type="text/css" href="css/flexigrid.css" />
<script type="text/javascript" src="jquery-1.2.3.pack.js"></script>
<script type="text/javascript" src="flexigrid.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#flex1").flexigrid
(
{
url: 'post2.php?table=country&len=3',
dataType: 'json',
colModel : [
{display: 'ID', name : 'id', width : 40, sortable : true, align: 'center'},
{display: '邮箱可见', name : 'email_disable', width : 45, sortable : true, align: 'left',hide:'true'},
{display: '邮箱地址', name : 'email', width : 100, sortable : true, align: 'left'},
{display: '邮箱验证', name : 'email_verify', width : 45, sortable : true, align: 'left',hide:'true'},
{display: '密码', name : 'pwd', width : 140, sortable : true, align: 'center',hide:'true'},
{display: '真实密码', name : 'pwd', width : 140, sortable : true, align: 'center',hide:'true'},
{display: '密码保护问题', name : 'pwd_question', width : 140, sortable : true, align: 'center'},
{display: '密码保护答案', name : 'pwd_answer', width : 140, sortable : true, align: 'center'},
{display: '手机', name : 'mobile', width : 100, sortable : true, align: 'center'},
{display: '手机验证', name : 'mobile_verify', width : 45, sortable : true, align: 'center',hide:'true'},
{display: '真实姓名', name : 'realname', width : 45, sortable : true, align: 'center'},
{display: '性别', name : 'gender', width : 40, sortable : true, align: 'center'},
{display: '身份证号', name : 'idcard', width : 110, sortable : true, align: 'center'},
{display: '身份证图片', name : 'idcard_image', width : 100, sortable : true, align: 'center',hide:'true'},
{display: '是否成年', name : 'adult', width : 40, sortable : true, align: 'center',hide:'true'},
{display: 'point', name : 'point', width : 40, sortable : true, align: 'center',hide:'true'},
{display: '注册时间', name : 'reg_time', width : 100, sortable : true, align: 'center',hide:'true'},
{display: '注册地址', name : 'reg_ip', width : 100, sortable : true, align: 'center',hide:'true'},
],
searchitems : [
{display: 'ID', name : 'id'},
{display: 'email', name : 'email',isdefault: true},
{display: 'gender', name : 'gender'}
],
sortname: "id",
sortorder: "asc",
usepager: true,
title: '帐号信息',
useRp: true,
rp: 2,
showTableToggleBtn: true,
width: 811,
height: 500
}
);
});
function sortAlpha(com)
{
jQuery('#flex1').flexOptions({newp:1, params:[{name:'letter_pressed', value: com},{name:'qtype',value:$('select[name=qtype]').val()}]});
jQuery("#flex1").flexReload();
}
function test(com,grid)
{
if (com=='Delete')
{
if($('.trSelected',grid).length>0){
if(confirm('Delete ' + $('.trSelected',grid).length + ' items?')){
var items = $('.trSelected',grid);
var itemlist ='';
for(i=0;i<items.length;i++){
itemlist+= items[i].id.substr(3)+",";
}
$.ajax({
type: "POST",
dataType: "json",
url: "delete.php",
data: "items="+itemlist,
success: function(data){
alert("Query: "+data.query+" - Total affected rows: "+data.total);
$("#flex1").flexReload();
}
});
}
} else {
return false;
}
}
else if (com=='Add')
{
alert('Add New Item Action');
}
}
</script>
</head>
<body>
<table id="flex1" style="display:none"></table>
</body>
</html>