Eto po codes ng index.php ko
<?php
include_once "connection.php";
?>
<!DOCTYPE html>
<html>
<head>
<title>Hello</title>
</head>
<style type="text/css">
.Buildings {
margin:20px;
text-align:center;
}
</style>
<body>
<div class="Buildings">
<label>Select Buildings</label>
<select name="Buildings">
<option value="">--Select Building--</option>
<?php
$query= "SELECT * FROM buildings";
$results= mysqli_query($con,$query);
foreach($results as $buildings){
?>
<option value="<?php echo $buildings["buildings"];?></option>
<?php
}
?>
</select>
</div>
</body>
</html>
Eto naman sa connection.php
<?php
$con= mysqli_connect("localhost","root","", "dropdownlist");
if(mysqli_connect_errno())
{
echo"Failed to connect:".mysqli_connect_errno();
}
?>
Bale ang mangyayare po jan is nakadropdownlist sya tapos yung pagpipilian nya ay nakabase sa database ko. Xampp po gamit ko at naka mysqlClick image for larger version. Name: Untitled.png Views: 0 Size: 78.3 KB ID: 1104381
View attachment 1104382