我使用PHP+SQL2000+FELXGRID JQUERY下面程序可用 但是访问时只会显示页码区域正常,数据信息表格中空白
只有用鼠标点表头 【ID等表头说明文字】刷新后才正常显示,这个BUG怎么修改?
HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
<title></title>
<link rel="stylesheet" type="text/css" href="../mydemo/grid/css/flexigrid/flexigrid.css"/>
<link rel="stylesheet" type="text/css" href="../mydemo/css/niceforms-default.css"/>
<script type="text/javascript" src="../jqueyui/js/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="../mydemo/grid/flexigrid.js"></script>
<script type="text/javascript" src="../mydemo/jquery.blockUI.js"></script>
<script type="text/javascript" src="../mydemo/js/nicejforms.js"></script>
<style>
a {
text-decoration: none;
font: 12px Arial, Helvetica, sans-serif, "宋体";
color: #FF6600;
}
a:hover {
color: #FFCC00;
}
.warpbox{display:none;}
#innerbox{margin:20px 40px;}
.inputdiv {
background-color: #f7f7f7;
border: 1px solid #CCCCCC;
}
.bborderx {
width: 700px;
margin: 80px auto;
}
.showMsg{
padding:20px;
}
#innerbox {
text-align:left;
}
.flexigrid div.fbutton .look {
background: url(../mydemo/css/images/look.png) no-repeat center left;
}
.flexigrid div.fbutton .add {
background: url(../mydemo/grid/css/images/add.png) no-repeat center left;
}
.flexigrid div.fbutton .mod {
background: url(../mydemo/grid/css/images/mod.gif) no-repeat center left;
}
.flexigrid div.fbutton .delete {
background: url(../mydemo/grid/css/images/close.png) no-repeat center left;
}
</style>
</head>
<div class="bborderx">
<table id="flex1" style="display:none">
</table>
<br />
<p style="text-align:center;"> </p>
</div>
<script type="text/javascript">
$.NiceJForms.build()
$("#flex1").flexigrid({
url: 'post2.php',
dataType: 'json',
colModel: [{
display: '大类编号',
name: 'id',
width: 60,
sortable: true,
align: 'center'
}, {
display: '大类名称',
name: 'name',
width: 120,
sortable: true,
align: 'left'
}, {
display: '类别类型',
name: 'about',
width: 120,
sortable: true,
align: 'left'
}],
buttons: [{
name: '增加',
bclass: 'add',
onpress: test
},
{ name: '修改',
bclass: 'mod',
onpress: test
}, {
name: '删除',
bclass: 'delete',
onpress: test
},{
separator: true
}],
sortname: "bid",
sortorder: "desc",
usepager: true,
title: '大类管理',
useRp: true,
rp: 10,
showTableToggleBtn: true,
width: 700,
height: 250
});
function test(com, grid){
if (com == '修改') {
if ($(".trSelected").length== 1) {
if (confirm('是否修改 ' + $('.trSelected', grid).length + ' 条记录吗?')) {
$.blockUI({ message: '<div class="showMsg">请稍等....<img src="loading.gif" /></div>' });
setTimeout($.blockUI, 2000);
location.href="mod.php?id="+$('.trSelected', grid).find(".sorted").eq(0).text();
}
}
else {
$(document).ready(function() {
$.blockUI({ message: '<div class="showMsg">请选择某行修改!<img src="../mydemo/loading.gif" /></div>' });
setTimeout($.unblockUI, 2000); });
}
}
else
if (com == '增加') {
$(document).ready(function() {
$.blockUI({ message: '<div class="showMsg">页面跳转中!<img src="../mydemo/loading.gif" /></div>' });
setTimeout($.unblockUI, 2000); });
location.href="add.php"
}
else
if (com == '删除') {
if ($(".trSelected").length > 0) {
if (confirm('是否删除 ' + $('.trSelected', grid).length + ' 条记录吗?')) {
var id = "";
for (var i = 0; i < $('.trSelected', grid).length; i++) {
id += "id=" + $('.trSelected', grid).find(".sorted").eq(i).text() + "&";
}
$.blockUI({ message: '<div class="showMsg">请稍等....<img src="../mydemo/loading.gif" /></div>' });
$.get("del.php?time=" + Math.random() + "&" + id, function(data, status, Request){
$(".showMsg").html(data);
//alert(status);
//alert(Request);
})
}
}
else {
$(document).ready(function() {
$.blockUI({ message: '<div class="showMsg">请选择某行修改!<img src="../mydemo/loading.gif" /></div>' });
setTimeout($.unblockUI, 2000); });
}
}
}
$(".closeAdd").click(function(){
$.unblockUI();
})
$(".return").click(function(){
$(".pReload").trigger("click");
return false;
})
</script>
PHP代码<?php$tname="bigclass";
$fname="id";
$s="1,2";@require_once('../Connections/cd.php');//数据库连接sql2000 $page = $_POST['page'];
$pagsize = $_POST['rp'];
$sortname = $_POST['sortname'];
$sortorder = $_POST['sortorder'];if (!$sortname) $sortname = 'id';
if (!$sortorder) $sortorder = 'desc';$sort = "ORDER BY $sortname $sortorder";if (!$page) $page = 1;
if (!$pagsize) $pagsize = 5;
$top2=$pagsize*($page-1);//$sql="select top $pagsize * from $tname where id not in( SELECT TOP $top2 id from $tname order by id desc)$sort";//z这个也可用效果还是一样出现BUG
$sql="SELECT TOP $pagsize *
FROM $tname
WHERE id >
(
SELECT ISNULL(MAX(id),0)
FROM
(
SELECT TOP $top2 id FROM $tname ORDER BY id
) A
)
$sort";$result =@mssql_query($sql);$total = countRec($fname,$tname);@header("Expires: Mon, 26 Jul 1997 05:00:00 GMT" );
@header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );
@header("Cache-Control: no-cache, must-revalidate" );
@header("Pragma: no-cache" );
@header("Content-type: text/x-json");
$json = "";
$json .= "{\n";
$json .= "page: $page,\n";
$json .= "total: $total,\n";
$json .= "rows: [";
$rc = false;
while ($row = @mssql_fetch_row($result)) {
if ($rc) $json .= ",";
$json .= "\n{";
$json .= "id:'".$row['id']."',";
$json .= "cell:['".$row[0]."'";
$ata= explode(",",$s); //分离数组
foreach($ata as $v_ata)
{
$json .= ",'".addslashes($row[$v_ata])."'";
}
$json .= "]";
$json .= "}";
$rc = true;
}
$json .= "]\n";
$json .= "}";
//$json=iconv("GB2312","UTF-8",$json);echo $json;
?>
只有用鼠标点表头 【ID等表头说明文字】刷新后才正常显示,这个BUG怎么修改?
HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
<title></title>
<link rel="stylesheet" type="text/css" href="../mydemo/grid/css/flexigrid/flexigrid.css"/>
<link rel="stylesheet" type="text/css" href="../mydemo/css/niceforms-default.css"/>
<script type="text/javascript" src="../jqueyui/js/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="../mydemo/grid/flexigrid.js"></script>
<script type="text/javascript" src="../mydemo/jquery.blockUI.js"></script>
<script type="text/javascript" src="../mydemo/js/nicejforms.js"></script>
<style>
a {
text-decoration: none;
font: 12px Arial, Helvetica, sans-serif, "宋体";
color: #FF6600;
}
a:hover {
color: #FFCC00;
}
.warpbox{display:none;}
#innerbox{margin:20px 40px;}
.inputdiv {
background-color: #f7f7f7;
border: 1px solid #CCCCCC;
}
.bborderx {
width: 700px;
margin: 80px auto;
}
.showMsg{
padding:20px;
}
#innerbox {
text-align:left;
}
.flexigrid div.fbutton .look {
background: url(../mydemo/css/images/look.png) no-repeat center left;
}
.flexigrid div.fbutton .add {
background: url(../mydemo/grid/css/images/add.png) no-repeat center left;
}
.flexigrid div.fbutton .mod {
background: url(../mydemo/grid/css/images/mod.gif) no-repeat center left;
}
.flexigrid div.fbutton .delete {
background: url(../mydemo/grid/css/images/close.png) no-repeat center left;
}
</style>
</head>
<div class="bborderx">
<table id="flex1" style="display:none">
</table>
<br />
<p style="text-align:center;"> </p>
</div>
<script type="text/javascript">
$.NiceJForms.build()
$("#flex1").flexigrid({
url: 'post2.php',
dataType: 'json',
colModel: [{
display: '大类编号',
name: 'id',
width: 60,
sortable: true,
align: 'center'
}, {
display: '大类名称',
name: 'name',
width: 120,
sortable: true,
align: 'left'
}, {
display: '类别类型',
name: 'about',
width: 120,
sortable: true,
align: 'left'
}],
buttons: [{
name: '增加',
bclass: 'add',
onpress: test
},
{ name: '修改',
bclass: 'mod',
onpress: test
}, {
name: '删除',
bclass: 'delete',
onpress: test
},{
separator: true
}],
sortname: "bid",
sortorder: "desc",
usepager: true,
title: '大类管理',
useRp: true,
rp: 10,
showTableToggleBtn: true,
width: 700,
height: 250
});
function test(com, grid){
if (com == '修改') {
if ($(".trSelected").length== 1) {
if (confirm('是否修改 ' + $('.trSelected', grid).length + ' 条记录吗?')) {
$.blockUI({ message: '<div class="showMsg">请稍等....<img src="loading.gif" /></div>' });
setTimeout($.blockUI, 2000);
location.href="mod.php?id="+$('.trSelected', grid).find(".sorted").eq(0).text();
}
}
else {
$(document).ready(function() {
$.blockUI({ message: '<div class="showMsg">请选择某行修改!<img src="../mydemo/loading.gif" /></div>' });
setTimeout($.unblockUI, 2000); });
}
}
else
if (com == '增加') {
$(document).ready(function() {
$.blockUI({ message: '<div class="showMsg">页面跳转中!<img src="../mydemo/loading.gif" /></div>' });
setTimeout($.unblockUI, 2000); });
location.href="add.php"
}
else
if (com == '删除') {
if ($(".trSelected").length > 0) {
if (confirm('是否删除 ' + $('.trSelected', grid).length + ' 条记录吗?')) {
var id = "";
for (var i = 0; i < $('.trSelected', grid).length; i++) {
id += "id=" + $('.trSelected', grid).find(".sorted").eq(i).text() + "&";
}
$.blockUI({ message: '<div class="showMsg">请稍等....<img src="../mydemo/loading.gif" /></div>' });
$.get("del.php?time=" + Math.random() + "&" + id, function(data, status, Request){
$(".showMsg").html(data);
//alert(status);
//alert(Request);
})
}
}
else {
$(document).ready(function() {
$.blockUI({ message: '<div class="showMsg">请选择某行修改!<img src="../mydemo/loading.gif" /></div>' });
setTimeout($.unblockUI, 2000); });
}
}
}
$(".closeAdd").click(function(){
$.unblockUI();
})
$(".return").click(function(){
$(".pReload").trigger("click");
return false;
})
</script>
PHP代码<?php$tname="bigclass";
$fname="id";
$s="1,2";@require_once('../Connections/cd.php');//数据库连接sql2000 $page = $_POST['page'];
$pagsize = $_POST['rp'];
$sortname = $_POST['sortname'];
$sortorder = $_POST['sortorder'];if (!$sortname) $sortname = 'id';
if (!$sortorder) $sortorder = 'desc';$sort = "ORDER BY $sortname $sortorder";if (!$page) $page = 1;
if (!$pagsize) $pagsize = 5;
$top2=$pagsize*($page-1);//$sql="select top $pagsize * from $tname where id not in( SELECT TOP $top2 id from $tname order by id desc)$sort";//z这个也可用效果还是一样出现BUG
$sql="SELECT TOP $pagsize *
FROM $tname
WHERE id >
(
SELECT ISNULL(MAX(id),0)
FROM
(
SELECT TOP $top2 id FROM $tname ORDER BY id
) A
)
$sort";$result =@mssql_query($sql);$total = countRec($fname,$tname);@header("Expires: Mon, 26 Jul 1997 05:00:00 GMT" );
@header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );
@header("Cache-Control: no-cache, must-revalidate" );
@header("Pragma: no-cache" );
@header("Content-type: text/x-json");
$json = "";
$json .= "{\n";
$json .= "page: $page,\n";
$json .= "total: $total,\n";
$json .= "rows: [";
$rc = false;
while ($row = @mssql_fetch_row($result)) {
if ($rc) $json .= ",";
$json .= "\n{";
$json .= "id:'".$row['id']."',";
$json .= "cell:['".$row[0]."'";
$ata= explode(",",$s); //分离数组
foreach($ata as $v_ata)
{
$json .= ",'".addslashes($row[$v_ata])."'";
}
$json .= "]";
$json .= "}";
$rc = true;
}
$json .= "]\n";
$json .= "}";
//$json=iconv("GB2312","UTF-8",$json);echo $json;
?>
<?php $server='epc';
$username='sa';
$password='';
$database='hope';
$conn=mssql_connect($server,$username,$password)
or die("Couldn't connect to SQL Server on $server");
$db=mssql_select_db($database) or die("Couldn't open database $database");
//@mssql_query("SET NAMES gb2312");
function countRec($fname,$tname) {
$sql = "SELECT count($fname) FROM $tname ";
$result = @mssql_query($sql);
while ($row = @mssql_fetch_row($result)) {
return $row[0];
}
}
@ob_start();
@session_start();?>