Displaying data Mysql in datalist

Question

why kategori_nama didn't show in fatalist.

here my controller

function index(){
     $data['title']='Portal Database Buku';
     $data['dropdown']=$this->m->ambildataKategori('ref_kategori');
     $this->load->view('home', $data);
}

my models

function ambildataKategori(){
        return $this->db->get('ref_kategori');
    }

views

<input name="kategori_id">
                              <datalist>
                                <?php while($rows=mysql_fetch_assoc($dropdown)){ ?>
                                 <option value="<?php echo $rows["kategori_nama"];?>">
                                 <?php } ?>
                              </datalist>

Answer 1

Hope this will help you :

Note : make sure you have loaded database and model in controller or in autoload.php

Your model method ambildataKategori should be like this

public function ambildataKategori()
{
    $query = $this->db->get('ref_kategori');
    if ($query->num_rows() > 0 )
    {
       /*make sure your table has data
           print_r($query->result_array());
       */
       return $query->result_array();
    }
}

Your view should be like this :

<?php 
if ( ! empty($dropdown)){ ?>
    <datalist>
        <?php foreach($dropdown as $item) {?>
           <option value="<?php echo $item["kategori_nama"];?>">
        <?php }?>   
    </datalist>   
<?php }?>

for reference : https://www.codeigniter.com/user_guide/general/index.html