model

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Addcats extends CI_Model {

	public $id,
	 $parent_id,
	 $name,
	 $sort,
	 $level;


	 public function get(){
		$res = $this->db->get('cats');
		$cats = $res->custom_result_object('addcats');
		return $cats;
	}

	public function create(){
		$data = array(
			'parent_id' => $this->parent_id,
			'name' => $this->name,
			'sort' => $this->sort,
			'level' => $this->level
			);

	$this->db->insert('cats', $data);
	}
	public function update(){
		$data = array(
			'parent_id'	=> $this->parent_id,
			'name' => $this->name,
			'sort'	=> $this->sort,
			'level' => $this->level
			);

	$this->db->where('id', $this->id);
	$this->db->update('cats', $data);
	}

	public function getUserById($cat_id) {
		$this->db->where('id', $cat_id);
		$res = $this->db->get('cats');
		if($res->num_rows() == 1){
			$cats = $res->custom_result_object('addcats');
			return $cats[0];
		}
		return false;
	}

	public function delete(){
		$this->db->where('id', $this->id);
		$this->db->delete('cats');
	}

}