DropDownlist - no data loading

DropDownlist - no data loading - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: DropDownlist - no data loading (/showthread.php?tid=37599)

DropDownlist - no data loading - El Forum - 01-14-2011

[eluser]penta997[/eluser]
helo. I have a problem with drop down list. When I running a page, data don't displaying in web browser.
This is model code:

Code:
function get_Country() 

      {

           $query = $this->db->query('Select * from country');

           return $query;

       }

Controller function:

Code:
function register()

       {

            $widok['left'] = $this->get_category(); 

            $widok['right'] = $this->load->view('Ksiegarnia/right', '', true);

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

             $data['data'] = $this->Users_model->get_Country();

            $widok['center'] = $this->load->view('Ksiegarnia/register_view', $data, true);

            $this->load->view('Ksiegarnia/index', $widok);

       }

register_view View:

Code:
<div class="form">

<h1>Registration<h1>

&lt;?php echo form_open('ksiegarnia/validation');?&gt;

&lt;!-- user --&gt;

<p>Login: &lt;?php echo form_input('username', '');?&gt;</p>

<p>Password: &lt;?php echo form_password('pass', '');?&gt;</p>

<p>Confirm password: &lt;?php echo form_password('pass2', '');?&gt;</p>

&lt;?php

echo '<select name="country">';

foreach($data->result() as $item)

{

    echo '<option value = "'.$item->COUNTRY_Id.'">'.$item->COUNTRY_Name.'</option>';

}

echo '</select>';

?&gt;

&lt;?php echo form_submit('wyslij', 'Wyślij');?&gt;

&lt;?php echo anchor('ksiegarnia/register', 'Zarejestruj');?&gt;

&lt;?php echo form_close(); ?&gt;

 </div>

DropDownlist - no data loading - El Forum - 01-14-2011

[eluser]Cristian Gilè[/eluser]
Try to comment out the call to the model and check if it works.
Is country the right name for the table? Not Country or COUNTRY?

Cristian Gilè

DropDownlist - no data loading - El Forum - 01-14-2011

[eluser]penta997[/eluser]
I've changed controller:

Code:
function register()

       {

            $widok['left'] = $this->get_category();

            $widok['right'] = $this->load->view('Ksiegarnia/right', '', true);

             //$this->load->model('Users_model');

             //$data['data'] = $this->Users_model->get_Country();

            $widok['center'] = $this->load->view('Ksiegarnia/register_view', '', true);

            $this->load->view('Ksiegarnia/index', $widok);

       }

and view:

Code:
&lt;?php

$option = array('one' => 'item1', 'two'=>'item2');

echo "<select name='country'>";

foreach($option as $item):

    echo "<option value = '$item'>".$item."</option>";

endforeach;

echo "</select>";

?&gt;

And it works.

The name COUNTRY_Name is correct.

DropDownlist - no data loading - El Forum - 01-14-2011

[eluser]penta997[/eluser]
I was fixed it. It works.