Laravel Dynamic Dependent Dropdown using Ajax

Learn How to Make Dynamic Dependent in Laravel using Ajax. How to use Laravel with Ajax for populate dropdown listbox with dynamic data. How to Create Dynamic Dropdown in Laravel. Dynamic Dependent Dropdown in Laravel using jQuery and Ajax.
Source Code - www.webslesson.info/2018/03/aj...

[@jhanhm]

Thanks Weblesson for sharing knowledge

[@SuperMakoto13]

Awesome video, thanks for the lesson!

[@tinkerbell6834]

Thanks for your time and efforts it helped me a lot

[@khoadoo5505]

thanks Webslesson, this help me alot.

[@animanoir]

Great stuff my friend, thank you.

[@kmsohelrana8246]

wow what a great job.thank you very much

[@uristmsk]

thx, it's very help me! cool code!

[@NanoRdz1976]

Hi, thanks for sharing this video, I want to see if you can help me, I have only two dropdowns for state and city. The values of the city dropdown are loaded correctly, but if there is some validation that is not fulfilled in the form, for example a field not captured, the city dropdown loses the elements that had been previously loaded.
Thank you in advance if you could guide me

[@bigcato5840]

i'm quite annoyed by the voice. but great stuff, thanks..

[@maliqnorman5539]

sir, just follow up question.. is this the best way to approach dynamic dependent dropdown? specially on country state city situation? how bout the relationship type like each has its own table.. table country, table state, table city and connect them using relationships.. please i need ur opinion on this since im a newbie..

[@olayemiolaribigbe3333]

thanks for the tutorial, please state data and city is not loading when the country option is selected from my end, it just remain blank, any help ?

[@nabeeltahir6013]

Thank you very much sir

[@bushramustofa2135]

Thanks team weblesson

[@nandalals9441]

Hi sir, Please make more video on laravel and ajax CRUD with full form elements includes input type file

[@icrmsoftware59]

Best tutorial

[@keyurvala2489]

is there any tutorial for getting selected dropdown value from the database using ajax in edit functionality?

[@nabeeltahir6013]

Please make more video on laravel and ajax

[@sarandatech4322]

how to use two tables using same method (dependent dropdown) country in one table and state in another table

[@MDFARUK-il8pw]

you are the web boss

[@osvaldobanze1845]

Obrigado!!

[@alinoori6931]

it's very very very help me! I love you !

[@fachrimrachman153]

did this work for you ???

[@sangeeth810]

great stuff

[@murleeyadav7800]

This video is awesome..
Can you please tell me what is the use of _token variable in this video

[@rogeriopicilli5545]

This is for protection. This prevent the CSRF attack

[@rahim3070]

This video is very good for one db table. But, if db table are multiple, then what can I do. Please reply me with a good suggestions.
Best Regards

[@braintricker_soft]

just use country id to query in state and state id to query in city table everything is same

[@Kahanikiduniya5]

what if we want to select multiple country then show their state together

[@smartowlgraphics4374]

I want to change dropdown list colour scheme to blue to green. Is any way? can you please guide me?

[@aashiqhasnat2]

sometimes you just need the concept ... I made that with Vue js. Thanks

[@m.abubakarkhan4451]

This code work well on single value , but not working on multiple select value plz guide me

[@rahulkrishna7810]

thanks for that code 😁 but the voice irritates more more 😪its not clear ...
once again thanks for code

[@heyyy4987]

I wanna see in vue.js. Nice. Tanks

[@MDFARUK-il8pw]

please make more tutorial we will be pleased

[@spreddy23]

groupby clause on Oracle having issues ORA-00979: not a GROUP BY expression.Did anyone have the same issue.Any help is much appreciated.

[@djohnoliver]

hey there , I am having the same problem have you fixed yours ????

[@ashwinishahapurkar7478]

How to submit this data from select boxes into new table of database??

[@AliRazaiamaliraza]

ruclips.net/video/yIs_Y5adAYU/видео.html
Watch this.

[@ferdyhananto6279]

I follow this code but it cannot show data on dropdown dependent,any one help?

[@livresonltc9754]

Hi Thanks for the tut. But for some reason, I can get it work. I'm getting error in the console: POST 127.0.0.1:8000/dynamic_dependent/fetch 500 (Internal Server Error) jquery.min.js:4. Any idea? I tried multiple projects with different machines with same result. I'm using WAMP Server.

[@trapkick5570]

have exactly the same issue. exept for: jquery.min.js:2
Did You solve this?

[@mysteriousmsn]

public function dynamicDropdown() {
$countrylist = DB::table('dynamicdropdown')->select('Country')->groupBy('Country')->get();
return view('dynamicdropdown')->with('countrylist', $countrylist);
}


function fetch(Request $request)
{
$select = $request->get('select');
$value = $request->get('value');
$dependent = $request->get('dependent');
$data = DB::table('dynamicdropdown')
->where($select, $value)
->select($dependent)
->groupBy($dependent)
->get();
$output = 'Select '.ucfirst($dependent).'';
foreach($data as $row)
{
$output .= ''.$row->$dependent.'';
}
echo $output;
}
Change like this and it will work, you have to use select method, i was getting this error today and fixed and killed my 2 hrs.

[@tinkerbell6834]

@@mysteriousmsn You are a life saver thanks so much

[@mysteriousmsn]

@@tinkerbell6834 You are Welcome.

[@luisfernandogonzaleztostad1294]

Hello groupBy('country') method is throwing this error "SQLSTATE[42000]: Syntax error or access violation: 1055 'testing.country_state_city.id' isn't in GROUP BY (SQL: select * from `country_state_city` group by `country`)" Any idea?

[@infiappsolution]

yes

[@nabeeltahir6013]

Make video on laravel ajax filter using checkbox and start rating .
Laravel ajax comment system

[@cocoiron4475]

i like this

[@237camerpreneur8]

very nice

[@devenderkumar2761]

Hello Sir, Nice Video. lease Insert All These Dropdown Values In database Using Laravel . Make A Video Otherwise Add This With register Page.

[@mdnazimuddin5211]

thanks

[@codewithqdkhan]

Sir please make Dependent Drop Down in laravel 8 using Ajax and jQuery.........Love From India UP

[@samoilenko_roman]

good! But all in one table...

[@belongersgaming8046]

pdate config/database.php
set:
'mysql' => [
'strict' => false,
],
instead of:
'mysql' => [
'strict' => true,
],
after doing this, the error will disappeared

[@napchannel2703]

mantab slurrrr

[@armanhossain9936]

this source code link can't work can you help me pls

[@bushramustofa2135]

Arman i think the source code is correct check that
1. He didn't create controller as usual but it is only DynamicDependent.php
2. Be sure you write correctly in web.php Don't forget first one is GET method and second one is POST

[@bennyuntung3706]

source code can't download
please repair link

[@mysteriousmsn]

WHOEVER IS GETTING SERVER ERROR TRY TO IMPLEMENT LIKE BELOW, ALL YOU HAVE TO DO IS TO USE "SELECT" METHOD IN THE QUERY BUILDER FUNCTIONS
public function dynamicDropdown() {
$countrylist = DB::table('dynamicdropdown')->select('Country')->groupBy('Country')->get();
return view('dynamicdropdown')->with('countrylist', $countrylist);
}


function fetch(Request $request)
{
$select = $request->get('select');
$value = $request->get('value');
$dependent = $request->get('dependent');
$data = DB::table('dynamicdropdown')
->where($select, $value)
->select($dependent)
->groupBy($dependent)
->get();
$output = 'Select '.ucfirst($dependent).'';
foreach($data as $row)
{
$output .= ''.$row->$dependent.'';
}
echo $output;
}

[@seekeralert9267]

the database structure isn't good not normalize and can cause a problem for the future use

[@rahulkrishna7810]

next try to put with a original voice ..

[@LOMBOist]

Why that voice ?

[@jessierhanculubong6242]

Nothing happened 🤤😢😥😭

[@k3logics925]

You forgot to make ajax more secure in controller's action

[@k3logics925]

if($request->ajax()){ //ajax code }

[@infiappsolution]

hiiiiiiii

[@carlahdiesto2481]

mali ang froeach

[@farahzainodin7593]

i hate the voice but great job

[@IphoneUser27]

I wasted my time on something that doesn't work -.-

[@infiappsolution]