CRUD with Ci 1.7

[eluser]Colin Williams[/eluser]
Well, of course it works good. It literally just wraps a handful of database class functions.

Code:

/**
         * $table  database table name required.
         * $num optional using when pagination use
         * $offset optional using when pagination use.
         *
         */
        function getRecords($table,$num = '',$offset = ''){
        
            $query = $this->ci->db->get($table,$num,$offset);
            return $query->result();
        }

        /**
         * $table database table name required
         * $clause array of clauses is required
         */
    
        function getRecord($table,$clause=''){
        
            $query = $this->ci->db->get_where($table,$clause);
            return $query->row();
        }

        /**
         * $table database table name required
         * $data is array of data want to insert required
         */
    
        function setRecord($table,$data){
            $this->ci->db->insert($table,$data);
        }

        /**
         * $table database table name required
         * $data required to update recored
         * $clause array of clauses is required
         */
    
        function updateRecord($table,$data,$clause){
            return $this->ci->db->update($table,$data,$clause);
        }

        /**
         * $table database table name required
         * $clause array of clauses is required
         */
          
        function deleteRecord($table,$clause){
            $this->ci->db->delete($table,$clause);
        }

        /**
         * it will give you last inserted id.
         */
        
        function getLastID(){
            return $this->ci->db->insert_id();
        }

        /**
         * $table name is required to get row counts.
         */
    
        function getCount($table){
            return $this->ci->db->count_all($table);            
        }
        
    }