thinkphp的控制器传参

最新推荐文章于 2024-07-16 13:11:43 发布

xiesumin

最新推荐文章于 2024-07-16 13:11:43 发布

阅读量2.4k

点赞数

分类专栏： thinkphp 文章标签： function 控制器传参

本文链接：https://blog.csdn.net/xiesumin/article/details/44954821

版权

thinkphp 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

若一个function里面的内容大都一样，只是表不一样，可以使用传参方法写一个方法就行，模糊查询

publicfunction zaixiao_basic($n) {

$tab = M($n);

$name = I('Name');

$idcard=I('IDcard');

$coachname = I('Coachname');

$page = isset($_POST['page']) ?intval($_POST['page']) : 1;

$rows = isset($_POST['rows']) ?intval($_POST['rows']) : 10;

$offset = ($page - 1) * $rows;

$sql = " Name like '$name%' andIDcard like '$idcard%' and Lixiao like '否'and Schoolname like'$_SESSION[schoolname]'";

$rs=$tab->where($sql)->limit($offset, $rows)->select();

$this->ajaxReturn($rs);

}

如果有个表的条件不一样如（表examinfo），可以这样写（组合查询）

public function zaixiao($n){
$tab = M($n);
$idcard = I('IDcard');
$name = I('Name');
if ($n == 'examinfo') {
$coachname = I('Coachname');
}
$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
$offset = ($page - 1) * $rows;
$sql = "Lixiao like '否'and Schoolname like '$_SESSION[schoolname]'";
if ($name != '') {
$sql1 = Name . ' like "' . $name . '"';
$sql.="&&$sql1";
}
if ($idcard != '') {
$sql2 = IDcard . ' like "' . $idcard . '"';
$sql.="&&$sql2";
}
if ($coachname != '') {
$sql3 = Coachname . ' like "' . $coachname . '"';
$sql.="&&$sql3";
}
$rs = $tab->where($sql)->limit($offset, $rows)->select();
$this->ajaxReturn($rs);
}