Laravel 8 Dynamic Dependent Dropdown using Jquery Ajax

Hello Friends, today we are going on how to create a dynamic dependent dropdown in laravel 8 using jquery ajax(Laravel 8 Dynamic Dependent Dropdown using Jquery Ajax). so here we will give information about the ajax country state city dropdown.

when the user changes the dropdown value that time we are using the jquery change event then after we are sending requests using ajax. we are using different ajax request call in this example. like as get for state and city.

The dynamic dependent dropdown is commonly used in country-state-city and category-subcategory selection. Loading dynamic data into selection boxes without refreshing the page makes the web application easy to use.

Overview

Step 1: Install Laravel
Step 2: Setting Database Configuration
Step 3: Create a Table using migration
Step 4: Create Route
Step 5: Create a Model and Controller
Step 6: Create Blade Files
Step 7: Run The Application

Step 1: Install Laravel
We are going to install laravel 8, so first open the command prompt or terminal and go to xampp htdocs folder directory using the command prompt. after then run the below command.

composer create-project --prefer-dist laravel/laravel laravel8_dynamic_dependent_dropdown

1	composer create-project --prefer-dist laravel/laravel laravel8_dynamic_dependent_dropdown

Step 2: Setting Database Configuration

After the complete installation of laravel. we have to database configuration. now we will open the .env file and change the database name, username, password in the .env file. See below changes in a .env file.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Enter_Your_Database_Name(laravel8_dynamic_dependent_dropdown)
DB_USERNAME=Enter_Your_Database_Username(root)
DB_PASSWORD=Enter_Your_Database_Password(root)

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=Enter_Your_Database_Name(laravel8_dynamic_dependent_dropdown)

DB_USERNAME=Enter_Your_Database_Username(root)

DB_PASSWORD=Enter_Your_Database_Password(root)

Step 3: Create a Table using migration

Now, We need to create a migration. so we will below command using create the images table migration.

php artisan make:migration create_country_state_city_tables

1	php artisan make:migration create_country_state_city_tables

After complete migration. we need the below changes in the database/migrations/create_country_state_city_tablesfile.

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCountryStateCityTables extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
       Schema::create('countries', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->timestamps();
        });
        Schema::create('states', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->integer('country_id');            
            $table->timestamps();
        });
        Schema::create('cities', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->integer('state_id');            
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('countries');
        Schema::drop('states');
        Schema::drop('cities');
    }
}

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreateCountryStateCityTables extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

Schema::create('countries', function (Blueprint $table) {

$table->increments('id');

$table->string('name');

$table->timestamps();

});

Schema::create('states', function (Blueprint $table) {

$table->increments('id');

$table->string('name');

$table->integer('country_id');

$table->timestamps();

});

Schema::create('cities', function (Blueprint $table) {

$table->increments('id');

$table->string('name');

$table->integer('state_id');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::drop('countries');

Schema::drop('states');

Schema::drop('cities');

}

Run the below command. after the changes above file.

php artisan migrate

1	php artisan migrate

Step 4: Create Route

Add the following route code in the “routes/web.php” file.

<?php

use Illuminate\Support\Facades\Route;

/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/

Route::get('/', function () {
    return view('welcome');
});

use App\Http\Controllers\DropdownController;
 

Route::get('dropdown',[DropdownController::class, 'index']);
Route::get('getState',[DropdownController::class, 'getState'])->name('getState');
Route::get('getCity',[DropdownController::class, 'getCity'])->name('getCity');

<?php

use Illuminate\Support\Facades\Route;

|--------------------------------------------------------------------------

| Web Routes

|--------------------------------------------------------------------------

| Here is where you can register web routes for your application. These

| routes are loaded by the RouteServiceProvider within a group which

| contains the "web" middleware group. Now create something great!

Route::get('/', function () {

return view('welcome');

});

use App\Http\Controllers\DropdownController;

Route::get('dropdown',[DropdownController::class, 'index']);

Route::get('getState',[DropdownController::class, 'getState'])->name('getState');

Route::get('getCity',[DropdownController::class, 'getCity'])->name('getCity');

Step 5: Create a Controller

Here below command helps to create the controller.

php artisan make:controller DropdownController

1	php artisan make:controller DropdownController

DropdownController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use DB;
class DropdownController extends Controller
{
	public function index()
	{
		$countries = DB::table("countries")->pluck("name","id");
		return view('dropdown',compact('countries'));
	}

	public function getState(Request $request)
	{
		$states = DB::table("states")
		->where("country_id",$request->country_id)
		->pluck("name","id");
		return response()->json($states);
	}

	public function getCity(Request $request)
	{
		$cities = DB::table("cities")
		->where("state_id",$request->state_id)
		->pluck("name","id");
		return response()->json($cities);
	}
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use DB;

class DropdownController extends Controller

{

public function index()

{

$countries = DB::table("countries")->pluck("name","id");

return view('dropdown',compact('countries'));

}

public function getState(Request $request)

{

$states = DB::table("states")

->where("country_id",$request->country_id)

->pluck("name","id");

return response()->json($states);

}

public function getCity(Request $request)

{

$cities = DB::table("cities")

->where("state_id",$request->state_id)

->pluck("name","id");

return response()->json($cities);

}

Step 6: Create Blade Files

So finally, first we will create the dropdown.blade.php files in the “resources/views” directory.

dropdown.blade.php

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Laravel 8 Dynamic Dependent Dropdown using Jquery Ajax - XpertPhp</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
</head>
<body>

<div class="container">
  <h2>Laravel 8 Dynamic Dependent Dropdown using Jquery Ajax</h2>
    <div class="form-group">
      <label for="country">Country:</label>
	  <select id="country" name="category_id" class="form-control">
        <option value="" selected disabled>Select Country</option>
         @foreach($countries as $key => $country)
         <option value="{{$key}}"> {{$country}}</option>
         @endforeach
         </select>
    </div>
    <div class="form-group">
      <label for="state">State:</label>
      <select name="state" id="state" class="form-control"></select>
    </div>
	<div class="form-group">
      <label for="city">City:</label>
      <select name="city" id="city" class="form-control"></select>
    </div>
</div>
<script type=text/javascript>
  $('#country').change(function(){
  var countryID = $(this).val();  
  if(countryID){
    $.ajax({
      type:"GET",
      url:"{{url('getState')}}?country_id="+countryID,
      success:function(res){        
      if(res){
        $("#state").empty();
        $("#state").append('<option>Select State</option>');
        $.each(res,function(key,value){
          $("#state").append('<option value="'+key+'">'+value+'</option>');
        });
      
      }else{
        $("#state").empty();
      }
      }
    });
  }else{
    $("#state").empty();
    $("#city").empty();
  }   
  });
  $('#state').on('change',function(){
  var stateID = $(this).val();  
  if(stateID){
    $.ajax({
      type:"GET",
      url:"{{url('getCity')}}?state_id="+stateID,
      success:function(res){        
      if(res){
        $("#city").empty();
		$("#city").append('<option>Select City</option>');
        $.each(res,function(key,value){
          $("#city").append('<option value="'+key+'">'+value+'</option>');
        });
      
      }else{
        $("#city").empty();
      }
      }
    });
  }else{
    $("#city").empty();
  }
    
  });
</script>
</body>
</html>

<!DOCTYPE html>

<head>

<title>Laravel 8 Dynamic Dependent Dropdown using Jquery Ajax - XpertPhp</title>

</head>

<body>

<h2>Laravel 8 Dynamic Dependent Dropdown using Jquery Ajax</h2>

<label for="country">Country:</label>

<option value="" selected disabled>Select Country</option>

@foreach($countries as $key => $country)

<option value="{{$key}}"> {{$country}}</option>

@endforeach

</select>

</div>

<label for="state">State:</label>

</div>

</div>

$('#country').change(function(){

var countryID = $(this).val();

if(countryID){

$.ajax({

type:"GET",

url:"{{url('getState')}}?country_id="+countryID,

success:function(res){

if(res){

$("#state").empty();

$("#state").append('<option>Select State</option>');

$.each(res,function(key,value){

$("#state").append('<option value="'+key+'">'+value+'</option>');

});

}else{

$("#state").empty();

}

});

}else{

$("#state").empty();

$("#city").empty();

}

});

$('#state').on('change',function(){

var stateID = $(this).val();

if(stateID){

$.ajax({

type:"GET",

url:"{{url('getCity')}}?state_id="+stateID,

success:function(res){

if(res){

$("#city").empty();

$("#city").append('<option>Select City</option>');

$.each(res,function(key,value){

$("#city").append('<option value="'+key+'">'+value+'</option>');

});

}else{

$("#city").empty();

}

});

}else{

$("#city").empty();

}

});

</script>

</body>

</html>

Step 7: Run The Application

We can start the server and run this application using the below command.

php artisan serve

1	php artisan serve

Now we will run our example using the below Url in the browser.

http://127.0.0.1:8000/dropdown

1	http://127.0.0.1:8000/dropdown

Download