In this tutorial, You will learn to display data from the database in select options using PHP & MySQL with some simple steps. These steps are very easy to understand and implement in web applications.
Here, I have shared source code to display data in a single dropdown select option. Once you learn it, you will easily customize it according to your project requirement.
How to Fetch Data From Database in PHP and Display in Select Option
Before getting started it’s coding, you should create the following folder structure –
codingstatus/
|__database.php
|__ fetch-data.php
|__ display-data.php
|
Learn Also –
Delete Multiple Records with checkboxes in PHP & MySQL
Preview Images before uploading using PHP
1. Insert Select Option Value
To display data from the database in a select option value, First of all, You will have to insert the select option value into the database. So, Make sure, you have already done it.
2. Connect Database to display data
To insert a select option value in the database, you must connect PHP to MySQL database with the help of the following query.
Where –
- $hostName – It must contain hostname.
- $userName – It must contain username of the database.
- $password – It must contain password of the database
- $database – It must contain database name.
File Name – database.php
<?php
$hostName = "localhost";
$userName = "root";
$password = "";
$databaseName = "codingstatus";
$conn = new mysqli($hostName, $userName, $password, $databaseName);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
3. Fetch Data From Database
To fetch data from database, you will have to implement the following steps –
Step-1: Write SQL query to select from the “course”
Step-2: store option data in the $options by fetching from the database
File Name – fetch-data.php
<?php
$query ="SELECT courseName FROM courses";
$result = $conn->query($query);
if($result->num_rows> 0){
$options= mysqli_fetch_all($result, MYSQLI_ASSOC);
}
?>
4. Display Data in Select Option
To display data in select option, you will have to follow the following steps –
Step-1: First of all, Include database.php and then also include the fetch-data.php
Step-2: Apply foreach loop to the $option and print the option value within select option input field.
File Name – display-data.php
<?php
include("database.php");
include("fetch-data.php);
?>
<select name="courseName">
<option>Select Course</option>
<?php
foreach ($options as $option) {
?>
<option><?php echo $option['courseName']; ?> </option>
<?php
}
?>
</select>