CI框架的常用的基础模型方法

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();
    }
}