模型

模型使用方法

$this->model->table("mnh_user_address")
->where(['openid' => $this->openid])
->orderBy("id desc")
->findAll();
$date1 = '2017-04-25 16:00:25';
$date2 = '2017-05-25 16:00:25';
// 使用 ? 匹配替换变量
$this->model->table("mnh_orders")->where("deleted_at is null and created_at > ? and created_at <= ?", [$date1, $date2])
->findAll();
// 最后执行的SQL
echo $this->model->sql;

模型方法

  • table($table_name)

  • dbconfig($db_config_name)

  • cache($expire)

  • select($field)

  • field($field)

  • limit($offset, $limit = 0)

  • set($data, $replacement = array())

  • data($data, $replacement = array())

  • where($where, $replacement = array())

  • leftjoin($join_string)

  • rightjoin($join_string)

  • orderby(string $orderby)

  • groupby(string $groupby)

  • having(string $having)

  • int affected_rows()

  • int insert_id()

  • query($sql, $replacement = array())

  • mixed find()

  • mixed findAll()

  • mixed findObj()

  • mixed findObjs()

  • array findPage() // 返回:array('data'=>[], 'data_count'=>0)

  • int count()

  • bool delete(bool $f)

  • int update(bool $f)

  • int insert()

  • int insert_update($update_string = '')

  • int insert_replace()

  • trans_start()

  • trans_commit()

  • trans_rollback()

  • escape_string($str)