How to Populate HTML Dropdown List with Values from Database

How to populate HTML dropdown list with values from database

My guess is that you have a problem since you don't close your select-tag after the loop. Could that do the trick?

<select name="owner">
<?php 
$sql = mysqli_query($connection, "SELECT username FROM users");
while ($row = $sql->fetch_assoc()){
echo "<option value=\"owner1\">" . $row['username'] . "</option>";
}
?>
</select>

How to populate a html dropdown dynamically with values from a postgres database?

In the backend (flask) you can fetch all the values from the Postgres database using the query:

# code to connect to db
...
# code to fetch from database
list_of_regions = db.execute("select region_name from regions")

Then pass on those values to the front end page:

@app.route("/")
def index():
    return render_template("index.html", list_of_regions = list_of_regions)

On the front end you can loop through the values with Jinja and add the items to the dropdown:

<label for="regions">Choose a region:</label>

<select name="regions" id="regions">
  {% for region in list_of_regions %}
    <option value={{region.lower()}}>{{region}}</option>
  {% endfor %}
</select>

Just replace your case-specific code with the general code that is provided above and it should be good to go. I was not sure about how to connect to postgres database as I have worked mostly with MySQL, so I guess this package might help you out better for that.

how to populate html dropdown with sql data

Using a similar block of code like the one you use for the tables you can do something like this:

<select>
<?php foreach( $results as $row ){
    echo "<option value='" . $row['value column'] . "'>" . $row['text column'] . "</option>";
   }
 ?> 
</select>

if you don't have or need a pair of values then you can simply do this:

<select>
<?php foreach( $results as $row ){
    echo "<option>" . $row['text column'] . "</option>";
   }
 ?> 
</select>

Populate an HTML DropDown List with data from mysql database without PHP

The easy answer

plain html

<select name="clients">
    <option value="1">Thomas Carrier</option>
    <option value="2">Michel Carrier</option>
    ...
</select>

or with ruby (https://guides.rubyonrails.org/layouts_and_rendering.html)

<select name="clients">
    <% @clients.each do |client| %>
        <option value="<%= client.id %>"><%= client.firstName %> <%= client.lastName %></option>
    <% end %>
</select>

Also refer to Yaniv Iny's answer to for a better more correct way

How to populate Dropdown values from database in php

Try some thing like this:

$arr = array(1 => 'MP', 2 => 'UP');

echo '<select>';
foreach($arr as $key => $val)
{
    echo '<option value="'.$key.'">'.$val.'</option>';
}
echo '</select>';

It will generate html like:

<select>
  <option value="1">MP</option>
  <option value="2">UP</option>
</select>

In your case it is like:

<select id="" name="roleid">
  <?php echo System_parameter_dropdown_value();?>
</select>

Populate html dropdown list dynamically from other dropdown

I found finally a good solution with a proper code. This is the link to the tutorial if someone has been stacked on this case.

A good explained tutorial with demo

---

Related Topics