我使用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;">&nbsp;</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;
?>

解决方案 »

  1.   

    数据库连接cd.php
     <?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();?>
      

  2.   

    sql2000才存在这个BUG,访问时不能显示,但是换成MYSQL没问题 访问时就显示,请帮忙修改下!?