dependent dropdown in php using ajax is the most popular feature of Web development. jQuery AJAX request parse the JSON response and convert it into an array.
dependent dropdown in php
HTML form with dependent dropdown select box is used to auto-populate the dependent data in the dropdown list.
Step 1: Create Tables and Dummy Data
CREATE TABLE `example_category` ( `id` int(11) NOT NULL, `name` varchar(155) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
example_sub_cat table:
CREATE TABLE `example_sub_cat` ( `id` int(11) NOT NULL, `category_id` int(12) NOT NULL, `name` varchar(155) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Now, in your database, you will have two tables “example_category” and “example_sub_cat”. Now we require to add some dummy data in both table like as bellow image.
Step 2: Create index.php file
<!DOCTYPE html>
<html>
<head>
<title>PHP - How to make dependent dropdown list using jquery Ajax? - www.pakainfo.com</title>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.1.1/jquery.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<link rel="stylesheet" href="plugin/bootstrap-3.min.css">
</head>
<body>
<div class="container">
<div class="panel panel-default">
<div class="panel-heading">Select category and get bellow Related sub_cat</div>
<div class="panel-body">
<div class="form-group">
<label for="title">Select category:</label>
<select name="category" class="form-control">
<option value="">--- Select category ---</option>
<?php
require('connect_db.php');
$sql = "SELECT * FROM example_category";
$result = $mysqli->query($sql);
while($dataResult = $result->fetch_assoc()){
echo "<option value='".$dataResult['id']."'>".$dataResult['name']."</option>";
}
?>
</select>
</div>
<div class="form-group">
<label for="title">Select sub_cat:</label>
<select name="sub_cat" class="form-control" style="width:350px">
</select>
</div>
</div>
</div>
</div>
<script>
$( "select[name='category']" ).change(function () {
var categoryID = $(this).val();
if(categoryID) {
$.ajax({
url: "do_process.php",
dataType: 'Json',
data: {'id':categoryID},
success: function(data) {
$('select[name="sub_cat"]').empty();
$.each(data, function(key, value) {
$('select[name="sub_cat"]').append('<option value="'+ key +'">'+ value +'</option>');
});
}
});
}else{
$('select[name="sub_cat"]').empty();
}
});
</script>
</body>
</html>
Step 3: Add DB Configuration File
connect_db.php
<?php define (DB_USER, "root"); define (DB_PASSWORD, "SD@#$iutjmnth"); define (DB_DATABASE, "mainexample"); define (DB_HOST, "localhost"); $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE); ?>
Don’t Miss : Dependent Dropdown Example In PHP MySQL
Step 4: Add Ajax File
do_process.php
<?php
require('connect_db.php');
$sql = "SELECT * FROM example_sub_cat
WHERE category_id LIKE '%".$_GET['id']."%'";
$result = $mysqli->query($sql);
$json = [];
while($dataResult = $result->fetch_assoc()){
$json[$dataResult['id']] = $dataResult['name'];
}
echo json_encode($json);
?>
Example 2 : dynamic dependent select box using jquery and ajax
Creating a dynamic dependent select box using jQuery and Ajax involves the following steps:
HTML: Create an HTML form with two select boxes – one for the parent category and one for the child category. For example:
<form>
<label for="parent_category">Parent Category:</label>
<select id="parent_category" name="parent_category">
<option value="">Select a category</option>
<option value="1">Category 1</option>
<option value="2">Category 2</option>
<option value="3">Category 3</option>
</select>
<br>
<label for="child_category">Child Category:</label>
<select id="child_category" name="child_category">
<option value="">Select a subcategory</option>
</select>
</form>
JavaScript: Use jQuery to handle the change event of the parent category select box, and send an Ajax request to fetch the child categories from the server. For example:
$(document).ready(function() {
$('#parent_category').on('change', function() {
var parent_id = $(this).val();
if (parent_id) {
$.ajax({
url: 'get_child_categories.php',
type: 'POST',
data: { parent_id: parent_id },
success: function(data) {
$('#child_category').html(data);
}
});
} else {
$('#child_category').html('<option value="">Select a subcategory</option>');
}
});
});
In the above code, we use jQuery to handle the change event of the parent category select box. When the user selects a parent category, we get its value and send an Ajax request to a PHP script called get_child_categories.php. The data parameter of the Ajax request contains the parent_id value.
The PHP script retrieves the child categories from the database, based on the parent_id, and returns an HTML string containing the option elements for the child category select box.
When the Ajax request is successful, we replace the contents of the child category select box with the HTML string containing the child categories.
If the user selects the default option of the parent category select box (i.e., no parent category selected), we reset the child category select box to its default value.
I hope you get an idea about dependent dropdown in php.
I would like to have feedback on my infinityknow.com.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.