Laravel Tutorial 3 - Laravel Dependent AJAX Dropdown Country State City from MySQL Database

*********************************************************************************************
Laravel Dependent AJAX Dropdown Country State City from MySQL Database
***********************************************************************************************
#Create Project in Laravel
composer create-project --prefer-dist laravel/laravel Laravel-Dependent-AJAX-Dropdown-CountryStateCity

#Add Database Details in .env file
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laraveldropdowncountrystatecity
DB_USERNAME=root
DB_PASSWORD=

#Create Model and Run Migration
php artisan make:model Country
php artisan make:model State
php artisan make:model City
php artisan make:migration create_country_state_city_tables

<?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('country_id');
$table➡string('country_name');
$table➡timestamps();
});
Schema::create('states', function (Blueprint $table) {
$table➡increments('state_id');
$table➡string('state_name');
$table➡integer('country_id');
$table➡timestamps();
});
Schema::create('cities', function (Blueprint $table) {
$table➡increments('city_id');
$table➡string('city_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 artisan migrate

#Prepare Controller

php artisan make:controller DropdownController

<?php
namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\{Country, State, City};
class DropdownController extends Controller
{
public function index()
{
$data['countries'] = Country::get(["country_id","country_name"]);
return view('index', $data);
}
public function getStates(Request $request)
{
$data['states'] = State::where("country_id",$request➡country_id)➡get(["state_id","state_name"]);
return response()➡json($data);
}
public function getCities(Request $request)
{
$data['cities'] = City::where("state_id",$request➡state_id)➡get(["city_id","city_name"]);
return response()➡json($data);
}
}

#Run below command for Test Laravel Dependent AJAX Dropdown
php artisan serve

#access in Browser

Note: Flow the Process shown in video.
😉Subscribe and like for more videos:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link:

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_____________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.
#chirags
#chiragstutorial
#chiragslaraveltutorial
#chiragslaraveltutorials
#laraveltutorial
#laravel10
#laravelcourse
#installlaravel
#laravel_tutorial
#laravelphp