add/edit/delete

CREATE TABLE `blogs` (
`blog_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`blog_title` VARCHAR( 255 ) NOT NULL ,
`blog_content` TEXT NOT NULL
) ENGINE = MYISAM ;

class Blog_model extends Model {
 
    function Blog_model(){
        parent::Model();
    }
	function get_all_blog() {
		$this->load->database();
		$query = $this->db->get('blogs');
    	return $query;
  	}
	function get_blog($id) {
		$this->load->database();
		$this->db->where('blog_id',$id);
		$query = $this->db->get('blogs');
    	return $query;
  	}
	function delete_blog($id) {
		$this->load->database();
		$this->db->delete('blogs', array('blog_id' => $id)); 
	}
}

class Blog extends Controller {
 
	function Blog(){
        parent::Controller();
    }
	function index(){
		$this->load->database();
		$this->load->model('blog_model');
 
		$data['results'] = $this->blog_model->get_all_blog();
 
		$this->load->view('showblog', $data);
	}
	function delete($id){
		$this->load->model('blog_model');
 
		$this->blog_model->delete_blog($id);
 
		redirect('blog','location'); //redirect setelahnya
	}
	function add(){
		$this->load->database();
		$this->load->library('form_validation');
 
		$this->form_validation->set_rules('title', 'Blog Title', 'required');
		$this->form_validation->set_rules('content', 'Blog Content', 'required');
 
		if ($this->form_validation->run() == FALSE ){
			$this->load->view('addblog');
		}
		else{	
			$data = array( 
				'blog_title' => $this->input->post('title'),
				'blog_content' => $this->input->post('content')
			);
			$this->db->insert('blogs', $data);  
 
			redirect('blog','location'); //redirect setelahnya
		}
	}
	function edit(){
		$id=$this->uri->segment(3);
		$this->load->database();
		$this->load->model('blog_model');
		$this->load->library('form_validation');
 
		$this->form_validation->set_rules('title', 'Blog Title', 'required');
		$this->form_validation->set_rules('content', 'Blog Content', 'required');
 
		if ($this->form_validation->run() == FALSE ){
			if(empty($id)) $id=$this->input->post('id');
			$data['result']=$this->blog_model->get_blog($id);		
			$data['id']=$id;
			$this->load->view('editblog', $data);
		}
		else{	
			$id=$this->input->post('id');
 
			$data = array( 
				'blog_title' => $this->input->post('title'),
				'blog_content' => $this->input->post('content')
			);
			$this->db->where('blog_id', $id);
			$this->db->update('blogs', $data); 
 
			redirect('blog','location'); //redirect setelahnya
		}
	}
}

                if ($results->num_rows() > 0){
                   foreach ($results->result() as $row){  
                      echo 'Judul : $row->blog_title'.
							anchor('blog/edit/'.$row->blog_id,'edit').
							anchor('blog/delete/'.$row->blog_id,'delete');
                   }
                }else {
                    echo 'Empty Blog';
                }
 

			echo form_open_multipart('blog/add', '').
				  form_label('Title', 'title').
				  form_input('title',set_value('title')).form_error('title').'<br>'.
				  form_label('Content', 'content').'<br>'.
				  form_textarea('content',set_value('content')).form_error('content').'<br>'.
				  form_submit('submit', 'Submit');
 

			$fetch=$result->row();
			echo form_open_multipart('blog/edit', '').
				  form_hidden('id',$id).
				  form_input('title',$fetch->blog_title).form_error('title').'<br>'.
				  form_label('Content', 'content').'<br>'.
				  form_textarea('content',$fetch->blog_content).form_error('content').'<br>'.
				  form_submit('submit', 'Submit');