How to populate HTML dropdown list with values from database

Question

as part of a HTML form I am creating I would like to have a dropdown list which will list all the usernames in my database   I thought the following code would do the trick but the dropdown list is empty - could someone assist me in what i m doing wrong  Thanks    lt tr gt   lt td gt Owner lt  td gt   lt td gt   lt select name  owner  gt   lt  php    sql   mysqli query  connection   SELECT username FROM users     while   row    sql- gt fetch assoc        gt   lt option value  owner1  gt  lt  php echo  row  username      gt  lt  option gt    lt  php    close while loop      gt   lt  td gt   lt  tr gt

User · Answer

lt select name  owner  gt   lt  php   sql   mysql query  SELECT username FROM users    while   row   mysql fetch array  sql    echo   lt option value   owner1   gt      row  username       lt  option gt        gt   lt  select gt

User · Answer

lt  php   query    select username from users     res   mysqli query  connection   query        gt     lt form gt     lt select gt        lt  php        while   row    res- gt fetch assoc                       echo   lt option value      row  id       gt     row  name      lt  option gt                   gt     lt  select gt   lt  form gt

User · Answer

Below code is nice   It was given by somebody else named  aaronbd in this forum   lt  php   conn   new mysqli  localhost    username    password    database    or die   Cannot connect to db          result    conn- gt query  select id  name from table         echo   lt html gt        echo   lt body gt        echo   lt select name  id  gt         while   row    result- gt fetch assoc                         unset  id   name                      id    row  id                       name    row  name                       echo   lt option value     id    gt    name   lt  option gt            echo   lt  select gt        echo   lt  body gt        echo   lt  html gt      gt

User · Answer

Use OOP concept instead  Create a class with function  class MyClass         function getData  query         result   mysqli query  this- gt conn   query       while  row mysqli fetch assoc  result              resultset      row                   if  empty  resultset           return  resultset        and then use the class object to call function in your code   lt  php        obj   new MyClass         row    obj- gt getData  select city name from city       gt   lt select gt       lt  php foreach  row as  row     gt           lt option gt  lt  php echo  row  city name     gt  lt  option gt    lt  php      gt   lt  select gt    Full code and description can be found here

User · Answer

I d suggest following a few debugging steps     First run the query directly against the DB   Confirm it is bringing results back   Even with something as simple as this you can find you ve made a mistake  or the table is empty  or somesuch oddity   If the above is ok  then try looping and echoing out the contents of  row just directly into the HTML to see what you ve getting back in the mysql query - see if it matches what you got directly in the DB     If your data is output onto the page  then look at what s going wrong in your HTML formatting     However  if nothing is output from  row  then figure out why the mysql query isn t working e g  does the user have permission to query that DB  do you have an open DB connection  can the webserver connect to the DB etc  something on these lines can often be a gotcha   Changing your query slightly to    sql   mysql query  SELECT username FROM users   or die mysql error         may help to highlight any errors  php manual

User · Answer

My guess is that you have a problem since you don t close your select-tag after the loop  Could that do the trick    lt select name  owner  gt   lt  php   sql   mysqli query  connection   SELECT username FROM users    while   row    sql- gt fetch assoc     echo   lt option value   owner1   gt      row  username       lt  option gt        gt   lt  select gt

[php] How to populate HTML dropdown list with values from database

Examples related to php

Examples related to sql

Examples related to while-loop