jqgrid主从表查询+添加grid按钮+查询框的“X”取消+查询框去掉

最新推荐文章于 2021-06-11 16:29:29 发布

咯西咯栗个嘞

最新推荐文章于 2021-06-11 16:29:29 发布

阅读量1.8k

点赞数

本文链接：https://blog.csdn.net/u014187551/article/details/22301609

版权

这篇博客介绍了如何使用jqGrid在PHP中实现主从表查询，包括查询框的清除功能和去除查询框。展示了maingrid()和subgrid()两个函数，分别用于主表格和子表格的数据加载，并提供了重置密码和充值的操作按钮。

摘要由CSDN通过智能技术生成

public function maingrid(){
// jqgrid查询
Vendor('jqSuite.jqGrid');
Vendor('jqSuite.jqGridPdo');
$conn = new PDO(C('GRIDB.DSN'),C('GRIDB.USER'),C('GRIDB.PWD'));
$conn->query("SET NAMES utf8");
$grid = new jqGridRender($conn);
// Write the SQL Query
$sqlx = "SELECT a.org_id,a.org_no as user_name,a.org_name,a.phone,a.email,a.address,a.consume_money,a.balance";
$sqlx .= " FROM ".C('DB_PREFIX')."tenants AS a ";
// $sqlx .= " WHERE a.user_id = ".$this->user_id." AND a.org_id = ".$this->org_id;
$grid->SelectCommand = $sqlx;
// Set the table to where you update the data
$grid->table = C('DB_PREFIX').'tenants';
// Set output format to json
$grid->dataType = 'json';
// Let the grid create the model
$grid->setColModel();
// Set the url from where we obtain the data
$grid->setUrl('index.php?m=Member&a=maingrid');
// Set some grid options
$grid->setGridOptions(array(
"rowNum"=>15,
"height"=>450,
"gridview"=>false,