displaying data from database using select options codeigniter PHP

Question

my controller function

public function add_books() {

  $this->load->model('User');

  $data['books'] = $this->User->getAuthor();

  $this->load->view('vadd_books',$data);

}

my user_model model

function getAuthor() {

  $this->db->select('author_firstname, author_lastname');

  $this->db->from('authors');

  $query = $this->db->get();

  return $query->result();

}

if your result is more than one you need to use foreach loop and display it in the html table. — Adhan Timothy Younes
– Adhan Timothy Younes, Commented Mar 18, 2017 at 6:24
I already used foreach in my view. Should I post my view here? — Robert Capistrano
– Robert Capistrano, Commented Mar 18, 2017 at 6:26
could you please check did you got proper data from your model? — user4094161
– user4094161, Commented Mar 18, 2017 at 6:28
I got a proper data from my model. My problem is just displaying/using my foreach. — Robert Capistrano
– Robert Capistrano, Commented Mar 18, 2017 at 6:29

Aman Kumar · Accepted Answer · 2017-03-18 06:26:42Z

0

Change in controller Modelname

public function add_books() {

  $this->load->model('user_model');

  $data['books'] = $this->user_model->getAuthor();

  $this->load->view('vadd_books',$data);

}

Use $this->db->last_query() to print query in model to debug MySQL Query

answered Mar 18, 2017 at 6:26

Aman Kumar

4,5573 gold badges21 silver badges40 bronze badges

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

2 Comments

Aman Kumar Over a year ago

But @RobertCapistrano Which answer is correct if any then please mark correct as correct answer ...:)

user4094161 Over a year ago

yes @RobertCapistrano which answer works for you please mark that as correct answer that will also help to other :)

user4094161 · Accepted Answer · 2017-03-18 06:30:17Z

0

You can try with below code

<select class="form-control">
            <?php 

            foreach($books as $row)
            { 
              echo '<option value="'.$row->author_firstname.'">'.$row->author_firstname.'</option>';
            }
            ?>
            </select>

For more reference refer url : http://stackoverflow.com/questions/19922143/display-data-from-database-to-dropdown-codeigniter

answered Mar 18, 2017 at 6:30

user4094161

Comments

Ankur Radadiya · Accepted Answer · 2017-03-18 07:40:17Z

0

Try this one code. i try to explain step by step.

Model

public function getAuthor() {

   $this->db->select('author_firstname, author_lastname');
   $this->db->from('authors');
   $query = $this->db->get();
   return $query->result();
}

Controller

public function add_books() {

  $this->load->model('User');
  $data['books'] = $this->User->getAuthor();
  $this->load->view('vadd_books',$data);
}

View

  <select class="form-control my-class">
        <?php 

        foreach($books as $row)
        { 
          echo '<option value="'.$row->author_firstname.'">'.$row->author_firstname.'</option>';
        }
        ?>
        </select>

answered Mar 18, 2017 at 7:40

Ankur Radadiya

2353 silver badges11 bronze badges

Collectives™ on Stack Overflow

displaying data from database using select options codeigniter PHP

3 Answers 3

Change in controller Modelname

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Change in controller Modelname

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related