Welcome Guest, Not a member yet? Register   Sign In
(beginner) database query in dropdownlist in form
#1

[eluser]rijobo[/eluser]
Hello,

I would like to create a dropdown list from my database, but i get the error:

A PHP Error was encountered
Severity: Notice

Message: Undefined variable: soort

Filename: views/product_toevoegen.php

Line Number: 54

What do I do wrong?

This is what I do:

In my controller:

Code:
$soort = $this->Productupload->SelectieSoort();
$this->load->view('product_toevoegen', $soort);

My model:

Code:
function SelectieSoort(){
    $this->db->select('soort');
    $soort = $this->db->get('soort');
    return $soort;
}

My view (form):

Code:
<h5>Soortlijst</h5>
&lt;?php echo form_dropdown('soort', $soort, ''); ?&gt;
#2

[eluser]Kyle Wiebers[/eluser]
In your controller try this -
Code:
$data['soort]' = $this->Productupload->SelectieSoort();
$this->load->view('product_toevoegen', $soort);

Ensure that you also load all the proper CodeIgniter resources in either the autoload.php file or in your Controller.
#3

[eluser]rijobo[/eluser]
I've tried this, but I've still got the same error unfortunately.
#4

[eluser]bgreene[/eluser]
$data['soort]' = $this->Productupload->SelectieSoort();
$this->load->view('product_toevoegen', $data);
#5

[eluser]rijobo[/eluser]
Now I don't get the error anymore, but I do get some unexpected results.
Is my model and view still ok?
#6

[eluser]bgreene[/eluser]
mea culpa
$data[‘soort’] = $this->Productupload->SelectieSoort();
$this->load->view(‘product_toevoegen’, $data);




Theme © iAndrew 2016 - Forum software by © MyBB