Populate a Drop down box from a mySQL table in PHP

Question

I am trying to populate a Drop down box from results of a mySQL Query  in Php  I ve looked up examples online and I ve tried them on my webpage  but for some reason they just don t populate my drop down box at all  I ve tried to debug the code  but on the websites I looked at it wasn t really explained  and I couldn t figure out what each line of code  Any help would be great      Here s my Query  Select PcID from PC

User · Answer

At the top first set up database connection as follow:

<?php
$mysqli = new mysqli("localhost", "username", "password", "database") or die($this->mysqli->error);
$query= $mysqli->query("SELECT PcID from PC");
?>

Then include the following code in HTML inside form

<select name="selected_pcid" id='selected_pcid'>

            <?php 

             while ($rows = $query->fetch_array(MYSQLI_ASSOC)) {
                        $value= $rows['id'];
                ?>
                 <option value="<?= $value?>"><?= $value?></option>
                <?php } ?>
             </select>

However, if you are using materialize css or any other out of the box css, make sure that select field is not hidden or disabled.

User · Answer

What if you want to use both id and name in the dropdown  Here is the code for that    mysqli   new mysqli  servername   username   password   dbname    sqlSelect    SELECT BrandID  BrandName FROM BrandMaster    result    mysqli - gt  query   sqlSelect    echo   lt select id  brandId  name  brandName  gt     while   row   mysqli fetch array  result        unset  id   name       id    row  BrandID        name    row  BrandName        echo   lt option value     id    gt    name   lt  option gt        echo   lt  select gt

User · Answer

No need to do this    while   row   mysqli fetch array  result          rows      row      You can directly do this   while   row   mysqli fetch array  result             echo   lt option value       row  value        gt      row  value       lt  option gt

User · Answer

Below is the code for drop down using MySql and PHP    lt    sql  Select PcID from PC   q mysql query  sql  echo   lt select name   pcid   gt     echo   lt option size  30  gt  lt  option gt    while  row   mysql fetch array  q              echo   lt option value     row  PcID      gt    row  PcID     lt  option gt       echo   lt  select gt      gt

User · Answer

After a while of research and disappointments    I was able to make this up        lt  php  conn   new mysqli  hostname    username    password   dbname   or die   Cannot connect to db    result    conn- gt query  select   from table     gt     insert the below code in the body        lt table id  myTable  gt   lt tr class  header  gt   lt th style  width 20    gt Name lt  th gt       lt th style  width 20    gt Email lt  th gt          lt th style  width 10    gt City  Region lt  th gt           lt th style  width 30    gt Details lt  th gt     lt  tr gt     lt  php    while   row   mysqli fetch array  result                     echo   lt tr gt                   echo   lt td gt    row  username     lt  td gt                   echo   lt td gt    row  city     lt  td gt                    echo   lt td gt    row  details     lt  td gt                   echo   lt  tr gt                         gt   lt  table gt    Trust me it works

User · Answer

Since mysql connect has been deprecated  connect and query instead with mysqli    mysqli   new mysqli  hostname   username   password   database name     sqlSelect  SELECT your fieldname FROM your table    result    mysqli - gt  query   sqlSelect     And then  if you have more than one option list with the same values on the same page  put the values in an array   while   row   mysqli fetch array  result          rows      row      And then you can loop the array multiple times on the same page   foreach   rows as  row        print   lt option value       row  your fieldname        gt      row  your fieldname       lt  option gt

User · Answer

You will need to make sure that if you re using a test environment like WAMP set your username as root  Here is an example which connects to a MySQL database  issues your query  and outputs  lt option gt  tags for a  lt select gt  box from each row in the table    lt  php  mysql connect  hostname    username    password    mysql select db  database-name      sql    SELECT PcID FROM PC    result   mysql query  sql    echo   lt select name  PcID  gt    while   row   mysql fetch array  result         echo   lt option value       row  PcID        gt      row  PcID       lt  option gt      echo   lt  select gt       gt

[php] Populate a Drop down box from a mySQL table in PHP

Examples related to php

Examples related to mysql