Laravel Tutorial 3 - Laravel Dependent AJAX Dropdown Country State City from MySQL Database
[email protected] Chirags Laravel Tutorial https://www.chirags.in
*********************************************************************************************
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
#migrations/create_country_state_city_tables.php file and update the following code:
<?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
http://127.0.0.1:8000/laravel-dropdown
Note: Flow the Process shown in video.
😉Subscribe and like for more videos:
/ @chiragstutorial
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment
Tutorial Link:
https://www.chirags.in/tutorials/lara...
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
Watch video Laravel Tutorial 3 - Laravel Dependent AJAX Dropdown Country State City from MySQL Database online without registration, duration hours minute second in high quality. This video was added by user Chirags Tutorial 01 June 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 300 once and liked it 3 people.