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

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

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

Project ID: #18263679

About the project

15 proposals Remote project Active 5 years ago

Awarded to:

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 More

$30 USD in 2 days
(4 Reviews)
3.8

15 freelancers are bidding on average $35 for this job

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 in 0 days
(987 Reviews)
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

$30 USD in 1 day
(226 Reviews)
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 More

$40 USD in 1 day
(179 Reviews)
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 More

$55 USD in 3 days
(186 Reviews)
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

$20 USD in 1 day
(155 Reviews)
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

$25 USD in 1 day
(24 Reviews)
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 More

$20 USD in 1 day
(12 Reviews)
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 More

$25 USD in 1 day
(5 Reviews)
1.8
ZubairIbrahim

Professional in Laravel and JS

$25 USD in 1 day
(0 Reviews)
0.0
zafar777777

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

$15 USD in 1 day
(0 Reviews)
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 in 2 days
(0 Reviews)
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){.... };

$20 USD in 1 day
(0 Reviews)
0.0