62,244
社区成员




<div style="padding-left:2px;padding-right:2px;height:100%;">
<table id="dg" title="服务列表"></table>
</div>
var queryData = {
name: $.trim($("#firstname").datebox("getValue"))
};
$('#dg').datagrid({ //定位到Table标签,Table标签的ID是grid
url: '/AppService/GetAppServiceList', //指向后台的Action来获取当前菜单的信息的Json格式的数据
title: '服务列表',
iconCls: 'icon-view',
fit: true,
fitColumns: true,
nowrap: true,
autoRowHeight: false,
striped: true,
collapsible: true,
pagination: true,
pageSize: 15,
pageList: [15, 30, 45, 60],
rownumbers: true,
sortOrder: 'asc',
remoteSort: false,
singleSelect: true, //选中行唯一
method: 'post',
idField: 'ServId',
queryParams: queryData, //异步查询的参数
columns: [[
{ title: "id", field: "id", width: 95, hidden: true },
{ title: "姓", field: "firstname", width: 95, sortable: true },
{ title: "名", field: "lastname", width: 95, sortable: true },
{ title: "电话", field: "phone", width: 95},
{ title: "邮箱", field: "email", width: 95,}
]],
onClickCell: function (index, row) {
},
onLoadSuccess: function (row, data) {
}
})
};
url="get_users.php"
的代码,那么为什么不把那几行 php 源代码也贴出来、看看它是如何写 sql 语句的呢?