模型

模型使用方法

$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)