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.
<?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());
}
?>
<!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>
Fetch data show in radio button