DataGrid (data table) component [2]

This lesson focuses on how the DataGrid (data table) component is used in Easyui, which relies on
Panel, resizeable (resizing), LinkButton (button), pageination (pagination) components.

A sorting function

Paging and sorting
$ (' #box '). DataGrid ({
URL: ' user.php ',
WIDTH:500,
Title: ' User List ',
Iconcls: ' Icon-search ',
Columns: [[
{
Field: ' User ',
Title: ' Account Number ',
Sortable:true,

},
{
field: ' Email ',
title: ' Mail ',
Sortable:true,
Sorter:function (A, b) {
Console.log (A + ' | ' + b);
},
},
{
field: ' Date ',
Title: ' Registration Time ',
Sortable:true,
},
]],
Fit:false,
Fitcolumns : True,
Pagination:true,
IDfield: ' id ',
pagesize:10,
PageList: [Ten, +, +],
Sortname: ' Date ', sortorder: ' DESC ',
Method: ' Post ',
//multisort:true,
Remotesort:false,
});
Server-side code
<?php
require ' config.php ';
$page = $_post[' page '];
$pageSize = $_post[' rows '];
$first = $pageSize * ($page-1);
er = $_post[' order '];
$sort = $_post[' sort '];
$query = mysql_query ("Select User,email,date from Think_user ORDER
by $sort er LIMIT $first, $pageSize ') or Die ( ' SQL Error! ');

$json = ";
while (!! $row = Mysql_fetch_array ($query, Mysql_assoc)) {
$json. = Json_encode ($row). ', ';
}
$total = mysql_num_rows (mysql_query ("Select User,email,date from
Think_user "));
$json = substr ($json, 0,-1);
Echo ' {"Total": '. $total. ', "Rows": ['. $json. ']} ';
Mysql_close ();
?>

DataGrid (data table) component [2]