Populating Drop Down List with PHP

How To Populate Drop Down List From Database Using PHP

by

How To Populate Drop Down List From Database Using PHP and MySQLi

In this tutorial, I will teach you how to Populate Drop Down List From Database Using PHP and MySQLi. This method has the ability to fill the data in a drop-down list form the MySQLi database.

This article can answer the question asked on another site.

Watch the video here before we proceed.

 

Follow the step by step procedure in Populating Drop Down List using PHP.

Populating Drop Down List with PHP
Populate Drop Down List From Database Using PHP and MySQLi

 

Lets Begin:

First, create a landing page and name it “index.php“.

Second, do the following code in the page that you have created.

<html>
<!-- Put you mysqli connection here ................ -->
<title>PHP SAMPLE SYSTEM</title>
<header>
<h1 align="center">Populate Drop Down List From Database Using PHP and MySQLi</h1>
</header>
<!-- Put your style layout here...... -->
<body>
<div id="box">
<div class="column"></div>
<div class="column">
<div class="clear"></div>
<label class="first-column ">Select a Book:</label><div class="clear"></div>
<div class="clear"></div>
</div>
<div class="column"></div>
</div>
</body>
</html>

 

Third, create a css style layout of the page.
#box{
width: 100%;
}
.column {
width: 33.33%;
display: inline-block;
}
.form{
padding: 2px;
width: 100%;
display: inline-block;
}
.first-column {
display: inline-block;
width: 100px;
height: 2px;
margin: 2px;
position: inherit;
}
.second-column{
display: inline-block;
width: 150px;
height: 2px;
margin: 2px;
position: inherit;
}
select {
width: 150px;
font-size: 12px;
height: 25px;
padding: 4px
}
.clear{
clear: left;
height: 15px;
}

 

Fourth, create a connection between MySQL Database and PHP Script.
<?php
$server="localhost";
$userid ="root";
$Password = "";
$myDB = "booksdb";$con = mysqli_connect($server,$userid,$Password,$myDB);if (mysqli_connect_errno()) {
# code...
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

?>

 

Finally, create a function for retrieving data from the database and fill it into the select box.
<?php

echo '<select>
<option>Select</option>';

$sqli = "SELECT * FROM tblbooks";
$result = mysqli_query($con, $sqli);
while ($row = mysqli_fetch_array($result)) {
echo '<option>'.$row['BookTitle'].'</option>';
}

echo '</select>';

?>

You can watch the video here about the PHP CREATE, READ, UPDATE AND, DELETE SOURCE CODE to get the full idea on how to create a simple PHP CRUD.

Another freebie from the author, watch and download the full source code of Leave Management System in PHP.

You can also visit here the PHP Projects with source code free download if you are looking for some complete PHP projects with source code.

Or if you want a crash course in PHP, you check here the PHP and MySQL Tutorial for beginners in 7 days.

Inquiries

If you have any questions or suggestions about PHP and MySQLi database tutorial, please feel free to contact us at our contact page or simply leave a comment below.

Download the complete source code here.

 

Leave a Comment