jQuery EasyUI使用教程之在树网格中动态加载

最新推荐文章于 2020-07-24 19:54:21 发布

界面开发小八哥

最新推荐文章于 2020-07-24 19:54:21 发布

阅读量1.2k

点赞数

动态加载树网格有助于从服务器上加载部分的行数据，避免加载大型数据的长时间等待。本教程将向您展示如何创建具有动态加载特性的树网格。

jQuery EasyUI最新试用版下载请猛戳>>

点击查看示例

创建树网格

 
   
        < 
        table 
         title 
        = 
        "Products" 
         class 
        = 
        "easyui-treegrid" 
         style 
        = 
        "width:700px;height:300px" 
         url 
        = 
        "treegrid3_getdata.php" 
         rownumbers 
        = 
        "true" 
         idfield 
        = 
        "id" 
         treefield 
        = 
        "name" 
        > 
       
 
        < 
        thead 
        > 
       
 
        < 
        tr 
        > 
       
 
        < 
        th 
         field 
        = 
        "name" 
         width 
        = 
        "250" 
        >Name</ 
        th 
        > 
       
 
        < 
        th 
         field 
        = 
        "quantity" 
         width 
        = 
        "100" 
         align 
        = 
        "right" 
        >Quantity</ 
        th 
        > 
       
 
        < 
        th 
         field 
        = 
        "price" 
         width 
        = 
        "150" 
         align 
        = 
        "right" 
         formatter 
        = 
        "formatDollar" 
        >Price</ 
        th 
        > 
       
 
        < 
        th 
         field 
        = 
        "total" 
         width 
        = 
        "150" 
         align 
        = 
        "right" 
         formatter 
        = 
        "formatDollar" 
        >Total</ 
        th 
        > 
       
 
        </ 
        tr 
        > 
       
 
        </ 
        thead 
        > 
       
 
        </ 
        table 
        > 
       
 
 

服务器代码

treegrid3_getdata.php

 
        $id = isset($_POST[ 
        'id' 
        ]) ? intval($_POST[ 
        'id' 
        ]) : 0; 
       
        include  
        'conn.php' 
        ; 
       
        $result = array(); 
       
        $rs = mysql_query( 
        "select * from products where parentId=$id" 
        ); 
       
        while 
        ($row = mysql_fetch_array($rs)){ 
       
        $row[ 
        'state' 
        ] = has_child($row[ 
        'id' 
        ]) ?  
        'closed' 
         :  
        'open' 
        ; 
       
        $row[ 
        'total' 
        ] = $row[ 
        'price' 
        ]*$row[ 
        'quantity' 
        ]; 
       
        array_push($result, $row); 
       
        } 
       
        echo json_encode($result); 
       
        function 
         has_child($id){ 
       
        $rs = mysql_query( 
        "select count(*) from products where parentId=$id" 
        ); 
       
        $row = mysql_fetch_array($rs); 
       
        return 
         $row[0] > 0 ?  
        true 
         :  
        false 
        ; 
       
        }