CI框架的常用的基础模型方法
<?php
class MY_Model extends \CI_Model {
protected $table_name;
/**
* MY_Model constructor.
*/
public function __construct() {
parent::__construct();
}
/**
* @param array $data
* @return mixed
*/
public function add($data = array()) {
$this->db->insert($this->table_name, $data);
return $this->db->insert_id();
}
/**
* @param array $where
* @param array $data
* @return bool
*/
public function update($where = array(), $data = array()) {
return $this->db->update($this->table_name, $data, $where);
}
/**
* @param array $where
* @return bool
*/
public function del($where) {
return $this->db->delete($this->table_name, $where);
}
/**
* @param array $where
* @param string $field
* @return array
*/
public function getBy($where = array(), $field = '*') {
$this->db->select($field);
$query = $this->db->get_where($this->table_name, $where);
if (!$query) {
return array();
}
return $query->result_array();
}
/**
* @param array $where
* @param string $field
* @return mixed
*/
public function getRow($where = array(), $field = '*') {
return $this->db->select($field)->from($this->table_name)->where($where)->get()->row_array();
}
/**
* 开启事务处理
*
* @return unknown
*/
public function startTrans(){
return $this->db->trans_begin();
}
/**
* 提交事务处理
*
* @return unknown
*/
public function commit(){
return $this->db->trans_commit();
}
/**
* 回滚事务处理
*
* @return unknown
*/
public function rollback(){
return $this->db->trans_rollback();
}
}