Why isn't this model returning any values?

Question

I'm trying to build VERY basic model->controller->view structure with CodeIgniter. I'd rather use models (and model functions, more importantly) and controllers than executing queries within each view.

First off, here's the model:

class Leads extends Model {

    function Leads()
    {
        parent::Model();
    }

    function fetch_leads()
    {
        $query = $this->db->get('leads', 10);
        return $query->result();
    }

}

Here's the controller, only relevant function being the one in question:

function view()
{

    $this->load->model('Leads', '', TRUE);

    $data['query'] = $this->Leads->fetch_leads();

$this->load->view('html_head');
$this->load->view('leads/view', $data);
$this->load->view('html_foot');
}

I think the problem is in this line, I may not be passing the data to the view correctly:

$data['query'] = $this->Leads->fetch_leads();

Now, the view:

print_r $data;

Did I mention basic? I'm just trying to get it to pull every field and print it from the database. Yes, the database is configured correctly, and yes, there is data in the database.

EDIT: The model wasn't auto-connecting to the database, so I added that parameter. The model still isn't returning values.

Any errors or warnings you can give?

roflwaffle
– roflwaffle

2010-01-27 00:11:55 +00:00
Commented Jan 27, 2010 at 0:11 — roflwaffle
– roflwaffle, Commented Jan 27, 2010 at 0:11
How do I turn on error logging?

dmanexe
– dmanexe

2010-01-27 17:42:09 +00:00
Commented Jan 27, 2010 at 17:42 — dmanexe
– dmanexe, Commented Jan 27, 2010 at 17:42

Michal M · Accepted Answer · 2010-01-27 00:15:35Z

2

it's not gonna work the way you do it.

return $query->result() does return an array of rows. In order to correctly pass this array to view you need to do it this way:

$view_data = array(
    'leads' => $leads,
);
$this->load->view('leads/view', $view_data);

What happens at the View is, all $view_data array elements are converted into local (for the view) variables. Therefore what in your controller is $view_data['leads'] becomes just $leads in your view.

answered Jan 27, 2010 at 0:15

Michal M

9,5218 gold badges51 silver badges64 bronze badges

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

1 Comment

Luca Matteis Over a year ago

Yes, +1 :) :) (using smiles to fill the required characters)

roflwaffle · Accepted Answer · 2010-01-27 00:14:26Z

0

It may be a problem with how you are passing the data to the view. Try to put the $leads in an array.

Ex. $data['leads'] = $this->Leads->fetch_leads();

answered Jan 27, 2010 at 0:14

roflwaffle

30.8k21 gold badges76 silver badges97 bronze badges

Comments

gmadd · Accepted Answer · 2012-01-11 13:19:37Z

0

You must pass an associative array to the $this->load->view() method.

Try this:

$leads = $this->Leads->fetch_leads();

$data["leads"] = $leads;

$this->load->view('html_head');

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

$this->load->view('html_foot');

edited Jan 11, 2012 at 13:19

gmadd

1,1529 silver badges18 bronze badges

answered Jan 27, 2010 at 0:14

Gabriel

1

Collectives™ on Stack Overflow

Why isn't this model returning any values?

3 Answers 3

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Related