Laravel – Dynamic Dependant Select Box using JQuery Ajax Example – Part 1

1)countries

2)states

We perform, when we select country from country dropdown, at that moment state dropdown box value will be change like if i select “US” from country select box then in state select box value will be only “US” state.

So, let’s follow bellow few step to do it.

Step 1 : Install Laravel Application

we are going from scratch, So we require to get fresh Laravel application using bellow command, So open your terminal OR command prompt and run bellow command:

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

Step 2 : Database Configuration

In this step, we require to make database configuration, you have to add following details on your .env file.

1.Database Username

2.Database Password

3.Database Name

In .env file also available host and port details, you can configure all details as in your system, So you can put like as bellow:

.env

DB_HOST=localhost
DB_DATABASE=homestead
DB_USERNAME=homestead
DB_PASSWORD=secret

Step 3: Create countries and states Tables

In this step we have to create migration for countries and states table using Laravel 5.3 php artisan command, so first fire bellow command:

php artisan make:migration create_country_state_table

After this command you will find one file in following path database/migrations and you have to put bellow code in your migration file for create categories table.

<?php

use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;

class CreateCountryStateTable 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('id_country')->unsigned();
            $table->foreign('id_country')->references('id')->on('countries')->onDelete('cascade');
            $table->timestamps();
        });
    }

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

Now we require to run migration be bellow command:

php artisan migrate

After create “countries” and “states” tables, we should have some dummy data for testing, So make sure that.

Step 4: Create Route

In this is step we need to create route for form layout file and another one for ajax post request. so open your routes/web.php file and add following route.

routes/web.php

Route::get('myform', 'AjaxDemoController@myform');
Route::post('select-ajax', ['as'=>'select-ajax','uses'=>'AjaxDemoController@selectAjax']);

Ok Now we will see last two step in next page, so click on bellow button.