CodeIgnite:model_activeRecords1

model_activeRecords1

class Site_model extends CI_Model {
	//Select all
	function get_records(){
		$query=$this->db->get('data');
		return $query->result();
	}
	//Add Record
	function add_record(){
		$data=array(
	   		'title'=>$this->input->post('title'),
	   		'contents'=>$this->input->post('contents')
   		);
		$this->db->insert('data',$data);
		return;
	}
	//Update
	function update_record(){
		$data = array(
			'title'=>'This is new title2',
			'contents'=>'This is new Content2'
			);
		$this->db->where('id',4);
		$this->db->update('data',$data);
	}
	//Delete row
	function delete_row(){
		$this->db->where('id',$this->uri->segment(3));
		$this->db->delete('data');
	}
}