PHP自动填充<select>从数据库中标记表单数据

Question

I don't know if this is a duplicate question. But i just want to know how to auto fill my <option> tag with data form my database

CREATE TABLE `Users` (
    `ID` INT(11) NOT NULL AUTO_INCREMENT,
    `Names` VARCHAR(50) NOT NULL DEFAULT '0',
    `Suranme` VARCHAR(50) NOT NULL DEFAULT '0',
    `Age` VARCHAR(50) NOT NULL DEFAULT '0'
    PRIMARY KEY (`ID`)
)

My Database

<select name="Names">
    <option value="1">Jhon</option>
    <option value="2">Will</option>
    <option value="3">Jack</option>
    <option value="4">Adam</option>
  </select>

Question : How do I auto fill my <option> with the names form the database table Names

Answer 1

## I Am assuming here a sample database ##

<?php
 $servername = "localhost";
 $username = "root";
 $password = "";
 $dbname = "myDB";

// Create connection
 $conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT Names FROM Users";
$result = $conn->query($sql);
echo "<select name="Names">";
if ($result->num_rows > 0) {
// output data of each row
$i=1;
while($row = $result->fetch_assoc()) {
    echo "<option value=$i>".$row["Names"]."</option>";
$i++;
}
echo "</select>";
} 
$conn->close();
?> 

This is one approach you can do as you want you can create a separate function for this.