Delete function--------- whare yes or no

controller --

 public function delete_sponsorship($id)

    { 

    // echo $id;die();


$res=$this->db->set('delete_status','yes')->set('deleted_date',date("Y-m-d H:i:s"))->where('order_id',$id)->update('investment');

if($res){

$this->session->set_flashdata('message', 'Deleted successfully!');

}else{

$this->session->set_flashdata('exception', display('please_try_again'));

}


redirect('backend/user/user/all_sponsership'); 

    }

  • delete_status,deleted_date -db colums
  • investment---- table name
  • redirect('backend/user/user/all_sponsership'); - viwe url name

Model -

    public function getAllSponsership()
    {

        return $this->db->select('*')
            ->from('investment')
            ->where('delete_status','no')
            ->order_by('invest_date','desc')
            ->get()
            ->result();
    } 

- getAllSponsership - colums results showing code
- where('delete_status','no')  --  already seting in colums yes

Viwe page button

 <a href="<?php echo base_url()?>backend/user/user/delete_sponsorship/<?php echo $value->order_id;?>" onclick="return confirm('<?php echo display("are_you_sure") ?>')" class="btn btn-danger btn-sm" data-toggle="tooltip" data-placement="right" title="Delete "><i class="fa fa-trash-o" aria-hidden="true"></i></a>

- delete_sponsorship - function name