Theme images by Storman. Powered by Blogger.

07 July 2016

How to get data from database to edit with dropdown select with php - codeigniter?



In Controller

public function edit_service(){
if($this->session->userdata('username')){
$data['title'] = "Edit Service";
$data['get_service'] = $this->ezefiber_model->edit_service();
$this->load->view("setting/pop_setting/edit_service",$data);

}else{
redirect('login', 'refresh');
}

}

In Model 

 function edit_service(){
      $this->db->where('type_id',$this->uri->segment(3));
      $query = $this->db->get('tblservice_pop');
      return $query->result();
   }
 
 In View

   <?php
$service = array(
'0' => "--Select--",
'example' => "example",
'Test' => "test"
);
?>

<?php foreach($get_service as $service) { ?>
 <select class="form-control" name="contract">
<?php foreach($contract as $select => $serviceview) {   ?>        
<option value="<?php echo $select ?>"
<?php if($select == $service->contract) { echo ' selected="selected"'; } ?>><?php echo $serviceview; ?></option>;
<?php }?>
</select>

<?php }?>





1 on: "How to get data from database to edit with dropdown select with php - codeigniter?"