$condition = ' 1 = 1';
$params = array();
$condition .= ' AND T1.schoolName LIKE "%' . $schoolName . '%"';
}
$sql = 'SELECT COUNT(*) FROM {{schools}} AS T1 WHERE'.$condition;
$cmd = $this->getDbCommand($sql);
$recordTotal = $cmd->queryScalar($params);
$params[':schoolId']=$list[$i]['id'];
$sqlfindAll="SELECT COUNT(*) FROM {{members}} AS T2 WHERE T2.schoolId=:schoolId";
$cmd = $this->getDbCommand($sqlfindAll);
$total = $cmd->queryScalar($params);
yii1.x学习笔记(4)好用的数据库操作
最新推荐文章于 2021-04-12 04:07:11 发布