如何在选择框中显示城市列表，城市列表将来自cakephp中的数据库

Question

I have a cities table in my database that contain the list of city and each city has their own id(Unique).

Now I want to show the list of city in a select box in my view page so that user can select the city from them.

I am using the below code in my controller:

$sql = mysql_query("select * from cities ORDER BY city_name");
if(mysql_num_rows($sql)>0){

    while($row=mysql_fetch_array($sql))
    {
        echo '<option value="'.$row['city_name'].'">'.$row['city_name'].'</option>';
    }
}
else
{
    echo '<option selected="selected">No data</option>';
}

What code should I use in view to show the list if city in the select box?

Answer 1

Why not use a City model?

Than you can use the find('list') option in your controller:

$this->set('cities', $this->City->find('list',array('fields' => array('id','city_name'))));

Then in your view use this:

echo $this->Form->input('City');

More on the find list option: http://book.cakephp.org/2.0/en/models/retrieving-your-data.html

More on the form helper: http://book.cakephp.org/2.0/en/core-libraries/helpers/form.html