get selected value from a dropdown to use it in another dropdown: Laravel

Terminé Publié le il y a 5 ans Paiement à la livraison
Terminé Paiement à la livraison

This is an easy task for laravel programmers:

I'm using a dropdown to read a column from a database table. All i want is to get the selected value and use it to create a new query that will be populated in a new dropdown.

What i need is:

- To come out with the more efficient method and tell me why do you think that's the best way (ajax, or php only, or some laravel http request if possible)

- To edit my files to write the necessary code (will give you ftp access)

- To give me 15 minutes to answer my questions about your code.

Please only apply if you are ready to do it right now. Use codeword: "laravel09" at the beginning of your message.

Note: I'm using AdminLTE: [login to view URL]

Here is my controller:

public function selectsector() //this is the dropdown #1 that works fine

{

$sectors = DB::table('Sectors')->whereBetween('SectorID', [1, 10])->value('SectorID');

return view('besttradesview', ['sectors10' => $sectors]);

}

public function selectsubsector() //dropdown #2 not working

{

$subsectors = DB::table('Sectors')->where('parentid', $sectors)->get(); //this line is not working it does not recognize $sector variable

return view('besttradesview', ['subsectors42' => $subsectors]);

}

View:

<form method="GET">

<div class="selectsector">

<Select class="selectsector" name = "sector">

@foreach($sectors10 as $sector)

<option>{{ $sector->SectorName }}</option>

@endforeach

</select>

<div class="selectsubsector">

<Select class="selectsubsector" name = "subsector">

@foreach($subsectors42 as $subsector)

<option>{{ $subsector->SectorName }}</option>

@endforeach

</select>

</form>

Routes:

Route::get('kitysoftware/besttrades', 'SectorsController@selectsector');

Route::get('kitysoftware/besttrades', 'SectorsController@selectsubsector');

HTML JavaScript Laravel MySQL PHP

Nº du projet : #18263679

À propos du projet

15 propositions Projet à distance Actif il y a 5 ans

Décerné à:

asifnadaf

Hi, codeword: "laravel09" You can use either AJAX or preferably JQuery. The solution is simple. You need to create a jquery such that when user selects a sector from first dropdown, the jquery event is trig Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(4 Commentaires)
3.8

15 freelances font une offre moyenne de 35 $ pour ce travail

GetReal

laravel09, Hi let me do the needful for you, ready to start and look forward to hear from you and work with you...thanks!

$55 USD en 0 jours
(987 Commentaires)
8.4
asifchaudhry2015

Hi there, I am Senior Laravel developer. I will use axis or ajax to load data in another drop down while selecting drop down . Let's discuss with me more. Thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(226 Commentaires)
7.9
royalwebraisers

Dear Hiring Manager, We can help you in the project. To show once dropdown value into another after selection of value in one dropdown. I am good in: php, codeigniter, laravel, jquery, google map api, MySQL. L Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(179 Commentaires)
6.9
lightingdavid

Hey? How are you? I have reviewed "get selected value from a dropdown to use it in another dropdown: Laravel" .I have good skills for these (HTML, Javascript, Laravel, MySQL, PHP). I have been working for 7 yrs in t Plus

$55 USD en 3 jours
(186 Commentaires)
6.5
MohanKumar28

Hi I have gone through the requirements. Will do this select dropdown. I'm available to start now. Please share additional details. Regards, Mohan

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(155 Commentaires)
6.2
tainguyen1990

Hi sir, I'm readed your requirement, i can help you fix list bugs. I'm expert PHP, Wordpress, JQuery, Laravel, Codeigniter , Angularjs, Nodejs etc

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(24 Commentaires)
5.4
vietsmile

Dear you, I am Viet, I have 6 years in program and desgin website. My skill: PHP(Laravel), CMS: Wordpress and other skills: bootstrap, Html5, css3... I can do the job in 20 minutes Please send a message for me, we Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)
4.0
Ravbot

Hello Sir... Hope you doing well, I read your project description so please come for technical discussion and we understand the negotiate cost, timeline then we move proceed further, also i show my past work during Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)
1.8
ZubairIbrahim

Professional in Laravel and JS

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
zafar777777

Hello there,,, i have a ready made code for this type of dependent dropdown in laravel .feel free to contact

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
3.2
CodeForLaravel

If you want to do it as mvc pattern and orm then hire me Relevant Skills and Experience Laravel, php, rest API, query builder,

$30 USD en 2 jours
(0 Commentaires)
0.0
bassemsoua

laravel09 . Web application : Laravel 5, Jquery, Ajax, bootsrap. I have experience with same project (dropdown Chapitre ---> dropdown question) with simple request ajax on change $(get){.... };

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0