crud operation in codeigniter

Download File

Controller:

function subitem(){
if($this->session->userdata('username')){
$id=$this->uri->segment(3);
if($this->input->post('Submit')){
$data=array(
'subitem_itemname'=>$this->input->post('miname'),

);//print_r($data);die();
  $this->Item_model->insert_subitem($data);
}elseif($this->input->post('Update')){
$data=array(
'subitem_id'=>$this->input->post('subitem_id'),
'subitem_itemname'=>$this->input->post('miname'),

);
//print_r($data);die();
$this->Item_model->update_subitem($data);
}elseif($id){
$data=array(
'subitem_id'=>$id,
'subitem_active'=>0
);
$this->Item_model->delete_subitem($data);
}
$data['view_item']=$this->Item_model->view_item();
$data['view_itemoption']=$this->Item_model->view_itemoption();
$data['view_subitem']=$this->Item_model->view_subitem();
$this->load->view('layout/head');
$this->load->view('subitem',$data);
$this->load->view('layout/footer');

}else{redirect('/Login/logins', 'refresh');}
}



Model:
function insert_itemoption($data){

$query=$this->db->insert('itemoption',$data);
if($query){
$this->session->set_flashdata('mainitem','Insert Item Option Successfully..');
redirect('Item/itemoption', 'refresh');
}
}
function update_itemoption($data){
$query=$this->db->where('itemoption_id',$data['itemoption_id'])->update('itemoption',$data);
if($query){
$this->session->set_flashdata('mainitem','Update Item Option Successfully..');
redirect('Item/itemoption', 'refresh');
}
}
function delete_itemoption($data){
$query=$this->db->where('itemoption_id',$data['itemoption_id'])->update('itemoption',$data);
if($query){
$this->session->set_flashdata('mainitem','Delete Item Option Successfully..');
redirect('Item/itemoption', 'refresh');
}
}
function view_itemoption(){
return $this->db->select('*')->from('itemoption')->where('`itemoption_active`=1')->get()->result_array();
}


view:
<div class="content-wrapper">
<section class="content">
<?php if($this->session->flashdata('mainitem')){echo "<div class='alert alert-success'><strong>Success!</strong> ".$this->session->flashdata('mainitem')."</div>";}elseif($this->session->flashdata('mainitem')){echo "<div class='alert alert-danger'><strong>Error!</strong> ".$this->session->flashdata('mainitem')."</div>";}?>
  <div class="modal fade" id="myModal" role="dialog">
    <div class="modal-dialog">
    <form action="<?php echo base_url(); ?>Item/itemoption" method="post">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">Add Item Option </h4>
        </div>
        <div class="modal-body">
          <div class="row">
        <div class="form-group col-md-12">
<label for="exampleInputEmail1">Item Option Name:</label>
<input type="text" class="form-control col-md-12" name="cname" >
</div>
        </div>
    </div>
        <div class="modal-footer">

          <input type="submit" name="Submit" class="btn btn-success" value="Submit">
          <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
        </div>
      </div>
      </form>
    </div>
  </div>
<button type="button" class="btn btn-info btn-lg pull-right" data-toggle="modal" data-target="#myModal"><i class="fa fa-plus" aria-hidden="true"></i></button>

<div class="box box-danger mt-60">
        <div class="box-header">
          <h3 class="box-title">View Item Options Details</h3>
        </div>
        <div class="box-body">
   <table class="table table-bordered" id="example">
    <thead>
      <tr>
        <th class="text-center">Item Option Name</th>
        <th class="text-center">Action</th>

       </tr>
    </thead>
    <tbody>
    <?php foreach($view_itemoption as $row){ ?>
    <tr>
    <td class="text-center"><?php echo $row['itemoption_name']; ?></td>
    <td class="text-center"><button type="button" class="btn btn-info btn-sm" data-toggle="modal" data-target="#edit<?php echo $row['itemoption_id']; ?>"><i class="fa fa-edit" aria-hidden="true"></i></button><a href="<?php echo base_url();?>Item/itemoption/<?php echo $row['itemoption_id']; ?>" class="btn btn-danger btn-sm"><i class="fa fa-trash" aria-hidden="true"></i></a></td>
    <div class="modal fade" id="edit<?php echo $row['itemoption_id']; ?>" role="dialog">
    <div class="modal-dialog">
    <form action="<?php echo base_url(); ?>Item/itemoption" method="post">
   
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">Update Item Option </h4>
        </div>
        <div class="modal-body">
        <input type="hidden" name="course_id" value="<?php echo $row['itemoption_id']; ?>">
          <div class="row">
        <div class="form-group col-md-12">
<label for="exampleInputEmail1">Item Option Name:</label>
<input type="text" class="form-control col-md-12" name="cname" value="<?php echo $row['itemoption_name']; ?>" >
</div>
        </div>
</div>
        <div class="modal-footer">

          <input type="submit" name="Update" class="btn btn-success" value="Submit">
          <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
        </div>
      </div>
      </form>
    </div>
  </div>
    </tr>
    <?php }?>
    </tbody>
  </table>
    </div>
    </div>
    </section>
</div>