What is the best way to display elements from a MySQL table in a dropdown list using PHP?

To display elements from a MySQL table in a dropdown list using PHP, you can first fetch the data from the table using a MySQL query. Then, loop through the results and create HTML <option> tags for each element to populate the dropdown list. 

&lt;?php
// Connect to MySQL database
$servername = &quot;localhost&quot;;
$username = &quot;username&quot;;
$password = &quot;password&quot;;
$dbname = &quot;database&quot;;

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn-&gt;connect_error) {
    die(&quot;Connection failed: &quot; . $conn-&gt;connect_error);
}

// Fetch data from MySQL table
$sql = &quot;SELECT * FROM table_name&quot;;
$result = $conn-&gt;query($sql);

// Create dropdown list
echo &#039;&lt;select&gt;&#039;;
while($row = $result-&gt;fetch_assoc()) {
    echo &#039;&lt;option value=&quot;&#039; . $row[&#039;id&#039;] . &#039;&quot;&gt;&#039; . $row[&#039;name&#039;] . &#039;&lt;/option&gt;&#039;;
}
echo &#039;&lt;/select&gt;&#039;;

// Close MySQL connection
$conn-&gt;close();
?&gt;

Keywords

PHP MySQL dropdown list display elements table.

Related Questions