$has_where = FALSE;
$where = '';
if (!empty($param['nickname'])) {
$has_where = $this->append_where($where, $has_where);
$where .= " u.nickname like " . "'%" . $param['nickname'] . "%'";
}
if (!empty($param['type'])) {
if ($param['type'] != 100) {
$has_where = $this->append_where($where, $has_where);
$where .= " c.ftype = " . $param['type'];
}
}
这个是接受参数并且凭借参数
public function append_where(&$sql, $has_where) {
$sql .= $has_where ? ' AND ' : ' WHERE ';
return $sql;
}
使用& 取地址符 来关联sql 语句 拼接好的条件语句 在进行拼接 注意不在需要添加 where