PHP program to populate dropdown (select) box with data from MySQL table

PROGRAM


<select name="owner">sdfsdf</option>
<?php
$connection=mysqli_connect('localhost','root','','experiment');
$query = ("select name from student");
$sql = mysqli_query($connection,$query);
while ($row = mysqli_fetch_array($sql)){
echo "<option value=\'owner1\'>" . $row['name'] . "</option>";
}
?>
</select>


OUTPUT



No comments:

Post a Comment