select values from database and show in a dropdown menu? about core-php-admin-panel

[vlori2k]

Solved it!

I did this:

  <div class="form-group">
        <label for="the_equipment_used">Equipment used?:</label>
        <select class="form-control" id="the_equipment_used" name="the_equipment_used" placeholder="Equipment for this sensor"  class="form-control" id ="the_equipment_used">

            <?php

            $db = getDbInstance();

            $get_all_equipment_IDs_and_names =($db->query("select equipment_ID, equipment_name FROM equipments "));


            foreach ($get_all_equipment_IDs_and_names as $key => $value) {

                echo "<option value='".$value["equipment_ID"]."'>".ucfirst($value["equipment_name"])."</option>";


            }

            ?>"

        </select>

    </div>