Display data from database with Select Option Codeigniter [closed]

Question

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 5 months ago.

Improve this question

first I want to apologize because I just learned Codeigniter, I have problems to display data from the database by using the Select Option, there is no error but the data does not appear, for your information, i have joined 3 tables.

Here's my Controller

class Harga extends CI_Controller{

function __construct(){
parent::__construct();
  $this->load->model('m_harga');
  $this->load->helper('url');
  $this->load->database();
}

function index(){
  $this->load->helper('form');
  $data['tabel_harga'] = $this->m_harga->tampil_data();
  $this->load->view('v_harga',$data);
}

Here's my Model

class M_harga extends CI_Model{
 function tampil_data(){
    $this->db->order_by('id_harga','ASC');
    return $this->db->from('tabel_harga')
    ->join('tabel_vendor','tabel_vendor.id_vendor=tabel_harga.id_vendor')
    ->join('tabel_hari','tabel_hari.id_hari=tabel_harga.id_hari')
    ->get()
    ->result();
}

and Here's my Views

<select class="form-control">
    <option value="">All</option>
      <?php
       foreach($tabel_harga as $u)
       {
        echo '<option value="'.$u['id_vendor'].'">'.$u['nama_vendor'].'</option>';
       }
      ?>
</select>

I will be very grateful if you help me, thank you guys.

Topically relevant: How to use query result set data in CodeIgniter's form_dropdown() helper function — mickmackusa
– mickmackusa ♦, Commented Jul 9 at 9:42

sauhardnc · Accepted Answer · 2020-06-02 19:43:03Z

1

The data doesn't appear probably because you're using result() which returns object and you're getting data as array in your view.

Model

class M_harga extends CI_Model{

    function tampil_data(){

        $this->db->select('*');
        $this->db->from('tabel_harga'); 
        $this->db->join('tabel_vendor','tabel_vendor.id_vendor=tabel_harga.id_vendor', 'INNER');
        $this->db->join('tabel_hari','tabel_hari.id_hari=tabel_harga.id_hari', 'INNER');
        $this->db->order_by('id_harga','ASC'); 

        $query = $this->db->get()->result_array(); // use result_array() instead of result() as you're getting value as an array in your view.

        return $query;
    }
}

Also, make sure to check $tabel_harga for values in your view ie

<select class="form-control">
    <option value="">All</option>
      <?php
          if(!empty($tabel_harga)){
              foreach($tabel_harga as $u){
      ?>            
                  <option value="<?php echo $u['id_vendor']; ?>"><?php echo $u['nama_vendor']; ?></option>
      <?php 
              }
          }
      ?>
</select>

Hope this helps you.

edited Jun 2, 2020 at 19:43

answered Jun 2, 2020 at 17:28

sauhardnc

1,9612 gold badges8 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

18 Comments

Bram Wiratma Over a year ago

Hi man, thx before, i appreciate your help, but this still doesn't work.. the data doesn't appear.. :(

sauhardnc Over a year ago

It could probably mean that the query you're running doesn't generate any value. You can print the query by echo $this->db->last_query(); and then run the query in phpmyadmin. See if it returns any row.

Bram Wiratma Over a year ago

i got this message.... SELECT * FROM tabel_harga JOIN tabel_vendor ON tabel_vendor.id_vendor=tabel_harga.id_vendor JOIN tabel_hari ON tabel_hari.id_hari=tabel_harga.id_hari ORDER BY id_harga ASC

sauhardnc Over a year ago

Yes, now copy the query and run it in phpmyadmin, if it shows no result then it means that your query is not returning any value and your now changed code is correct.

Bram Wiratma Over a year ago

still same doesnt work :(, but thank you very much for sharing, really appreciete, success for you..

|

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

try this

view

<select class="form-control">
    <option value="">All</option>
      <?php
       foreach($tabel_harga as $u)
       {
        echo '<option value="'.$u->id_vendor.'">'.$u->nama_vendor.'</option>';
       }
      ?>
</select>

Models


class M_harga extends CI_Model{
 function tampil_data(){

     $this->db-join('tabel_vendor','tabel_vendor.id_vendor=tabel_harga.id_vendor')
     $this->db-join('tabel_hari','tabel_hari.id_hari=tabel_harga.id_hari')
     $this->db->order_by('id_harga','ASC');
     $sql = $this->db->get('tabel_harga');
    
     return $sql->result(); // returns an array of objects
}

controller

class Harga extends CI_Controller{

function __construct(){
parent::__construct();
  $this->load->model('M_harga');
  $this->load->helper(array('url','form'));
}

function index(){

  $data['tabel_harga'] = $this->M_harga->tampil_data();
  $this->load->view('v_harga',$data);
}

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jun 2, 2020 at 18:08

dmforaname

631 gold badge1 silver badge10 bronze badges

1 Comment

dmforaname Over a year ago

i have an update model and controllers, hope this help

T D Nguyen · Accepted Answer · 2022-10-04 20:07:55Z

0

db->select("name, value"); 
$this->db->from('settings'); 
$query = $this->db->get(); 
if ($query->num_rows()) 
{ 
  foreach ($query->result_array() as $row) 
  { // Your data is coming from multiple rows, so need to loop on it. 
      $siteData[$row['name']] = $row['value']; 
   } 
   } 
  return $siteData; 
}

edited Oct 4, 2022 at 20:07

T D Nguyen

7,7337 gold badges56 silver badges80 bronze badges

answered Sep 29, 2022 at 5:43

Venus Marks

1

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Display data from database with Select Option Codeigniter [closed]

3 Answers 3

18 Comments

view

Models

controller

1 Comment

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

18 Comments

view

Models

controller

1 Comment

1 Comment

Linked

Related