How to display an array of database column values ​​under a tag?

Question

PHP

There is a code

<em>Single Select with Groups</em>

<select data-placeholder="Your Favorite Football Team" style="width:350px;" class="chosen-select" tabindex="5">

<option value=""></option>

<option>Denver Broncos</option>

<option>Kansas City Chiefs</option>

<option>Oakland Raiders</option>

<option>San Diego Chargers</option>

</select>

This is the code that is needed to find and select the desired element and pin it to the tables. I need to make it so that instead of commands you can select one of the values ​​​​from the database table, but I don’t know how!
Those. instead of Denver Broncos, Kansas City Chiefs, there should be only one in which, in theory, there should be an array of table column values, and when entering the first letters of a word, a person could choose what he needs from the list offered!
Thank you in advance!

Answer 1

I understand that you need to autocomplete .. There are many examples on the net, here are a couple:
https://daveismyname.com/autocomplete-with-php-mys...
ruseller.com/lessons.php?rub=37&id=1336
or in google - goo.gl/3daeFa