How to fetch data from database and display in html dropdown?

Question

I am creating a simple form with fields like First_name, Last_name, city etc.So for city field, I want to display dynamic data.Below is the code I am using it's in PHP CodeIgniter.

Controller Page:

public function city()
    {
        $this->load->model('dropdownM');
        $getcity=$this->dropdownM->get_city();
        $this->load->view('form1city',$getcity);
    }

Model Page:

<?php

class DropdownM extends CI_Model
{
    public function get_city()
    {


        $this->db->select('fname');
        $this->db->from('city');
        $query = $this->db->get();
        if($query->num_rows()>0)
            {
            return $query->result();

        }
    }
}

View page:

    <form action="<?php echo base_url(); ?>index.php/Rec/user" method="post">

    <select class="form-control" id="city" name="city">

    <option value="">Select </option>
        <?php if(count($getcity)):?>

            <?php foreach($getcity as $city):?>

                <option value=<?php echo $city->c_id;?>><?php echo $village1->C_name;?></option>

            <?php endforeach;?>

        <?php else:?>

       <?php endif;?>

    </select>
       <center>                                            
       <input type="submit" value="Submit" class="btn btn-bricky" id="subbtn" 
        name="submit1">
       </center>
<form>

It's not displaying anything in the drop-down.I am not able to find out what the issue.

Abdulla Nilam · Accepted Answer · 2018-01-10 14:48:01Z

3

pass data like this

$data['getcity']=$this->dropdownM->get_city();
$this->load->view('form1city',$data);

and in view

<?php if(count($getcity) > 0):?>
    <select class="form-control" id="city" name="city">
        <option value="">Select </option>
            <?php foreach($getcity as $city):?>

                <option value=<?php echo $city['c_id'];?>><?php echo $village1['C_name'];?></option>

            <?php endforeach;?>
    </select>
<?php else:?>
    <p>No Category Found</p>
<?php endif;?>

In model

$this->db->select('fname');
$this->db->from('city');
$query = $this->db->get();
return $query->result_array();

answered Jan 10, 2018 at 14:48

Abdulla Nilam

39.6k18 gold badges85 silver badges115 bronze badges

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

8 Comments

Nisha Over a year ago

I am getting below error:A PHP Error was encountered Severity: Notice Message: Undefined variable: getcity

Abdulla Nilam Over a year ago

at which line ?

Nisha Over a year ago

At this line:<?php if(count($getcity) > 0):?>

Abdulla Nilam Over a year ago

<?php if(!empty($getcity)):?> replace to this

Alex Over a year ago

This is completely correct and addresses all the issues I see. Use this code verbatim.

|

Collectives™ on Stack Overflow

How to fetch data from database and display in html dropdown?

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related