How to show fetch data in select box using PHP


In this topic i am going to show you how to fetch data and show in a select box.

Here we using two file for fetch data.

  1. database.php(For connect to database)
  2. index.php(Fetch data from database)

database.php

<?php
$servername='localhost';
$username='root';
$password='';
$dbname = "crud";
$conn=mysqli_connect($servername,$username,$password,"$dbname");
if(!$conn){
die('Could not Connect My Sql:' .mysql_error());
}
?>

index.php

<!DOCTYPE html>
<html>
<head>
<title> Retrive data</title>
</head>
<body>
<h2>City name</h2>
<select>
<?php
$i=0;
while($DB_ROW = mysqli_fetch_array($result)) {
?>
<option>
<?php echo $DB_ROW["city_name"]; ?></option>
<?php
$i++;
}
?>
</select>
</body>
</html>

Related Topic

Fetch data show in select box

Fetch data show in checkbox

Fetch data show in radio button

Fetch data show in text box