Codeigniter fetch records from table undefined variable error

Question

I am trying to fetch data from a table, I created a controller, model and view but when I try to open view, I am getting two errors one is Message: Undefined variable: u_list and another one is Message: Invalid argument supplied for foreach() I am using CodeIgniter 3.1.9

Controller

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class UserFetch extends CI_Controller {

    public function __construct(){
        parent::__construct();
        $this->load->database();
        $this->load->model('userinsert');
    }

    public function index() {  
     $data['u_list']=$this->userinsert->select();
     $this->load->view('dashboard', $data);
    }
}
?>

Model

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class UserInsert extends CI_Model {
    function __construct() {
        parent::__construct();
    }

    function user_insert($data) {
        $this->db->insert('users', $data);
    }

    public function select() {  
        $query = $this->db->get('users');
        return $query; 
    } 
}
?>

View

<tbody>
    <?php
        foreach ($u_list as $row) {  
    ?>
    <tr>  
    <td><?php echo $row->first_name;?></td>
    <td><?php echo $row->last_name;?></td>
    </tr>  
    <?php }
    ?>
</tbody>

Help me with this guys

go in you view and dump like this var_dump($this->_ci_cached_vars); tell me what are you getting there — Syed Arif Iqbal
– Syed Arif Iqbal, Commented Sep 7, 2018 at 12:51
try something like this if this works $this->load->view('dashboard', ['u_list' => $this->userinsert->select()]); — Syed Arif Iqbal
– Syed Arif Iqbal, Commented Sep 7, 2018 at 12:56

Krishna Joshi · Accepted Answer · 2018-09-07 13:09:43Z

2

Replace your function select with below code

public function select() {  
    $query = $this->db->get('users');
    return $query->result(); 
}

Hope this helps

answered Sep 7, 2018 at 13:09

Krishna Joshi

3151 silver badge7 bronze badges

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

1 Comment

Krishna Joshi Over a year ago

Try to debug by print_r($data['u_list']); exit; in your controller

Devsi Odedra · Accepted Answer · 2018-09-07 12:40:30Z

1

You forgot result in MODEL

 public function select() {  
        $query = $this->db->get('users')->result();
        return $query; 
    }

answered Sep 7, 2018 at 12:40

Devsi Odedra

5,3421 gold badge25 silver badges38 bronze badges

6 Comments

Devsi Odedra Over a year ago

just print $query and tell em what you getting?

Jason Over a year ago

Where? in view part?

Devsi Odedra Over a year ago

check in model part

Jason Over a year ago

Checked the model part nothing printed by $query

Devsi Odedra Over a year ago

So now just echo $this->db->last_query(); die; before return. and use that printed query in your mysql DB.

|

cool_benn · Accepted Answer · 2018-09-07 13:18:59Z

1

// use this function in your module 
public function select() {  
        $query = $this->db->get('users');
      $query = mysqli_fetch_all($query );
        return $query; 
    }    

 <tbody>
        <?php
            foreach ($data['u_list'] as $row) {  
        ?>
        <tr>  
        <td><?php echo $row['first_name'];?></td>
        <td><?php echo $row['last_name'];?></td>
        </tr>  
        <?php }
        ?>
    </tbody>

edited Sep 7, 2018 at 13:18

answered Sep 7, 2018 at 13:04

cool_benn

568 bronze badges

2 Comments

Jason Over a year ago

Same error Message: Undefined variable: data and Message: Invalid argument supplied for foreach()

cool_benn Over a year ago

public function select() { $query = $this->db->get('users'); $query = mysqli_fetch_all($query ); return $query; }

Akbar Soft · Accepted Answer · 2018-09-07 13:12:57Z

0

in your model ...

public function select() {  
      $this->db->select("*"); 
      $this->db->from('users');
      $query = $this->db->get();
      return $query->result();
}

answered Sep 7, 2018 at 13:12

Akbar Soft

1,06610 silver badges19 bronze badges

1 Comment

Akbar Soft Over a year ago

public function select() { $this->db->select("*"); $this->db->from('users'); $query = $this->db->get(); if ($query->num_rows() >0 ) { return $query->result(); } }

Collectives™ on Stack Overflow

Codeigniter fetch records from table undefined variable error

4 Answers 4

1 Comment

6 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

6 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related