get selected value from a dropdown to use it in another dropdown: Laravel
$10-30 USD
Terminado
Publicado hace más de 5 años
$10-30 USD
Pagado a la entrega
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');
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 triggered and a function is called. Let us call this jquery function selectsubsector(). This function will make an API request to laravel by passing the selected sector from dropdown 1. The laravel function selectsubsector will return a json api instead of view to jquery function. Upon receiving json api from Laravel, the jquery function populates the second dropdown.
If you haven't already assigned the project someone, I would be more than happy to implement it.
Thanks
$30 USD en 2 días
5,0 (4 comentarios)
3,8
3,8
15 freelancers están ofertando un promedio de $35 USD por este trabajo
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
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.
Let me know when we can discuss in more details and start working on it asap.
Looking forward for your response.
Thanks.
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 this scope.
While we contract and work in our jobs, I will get paid once you have confirmed satisfied result.
If I do not deliver satisfied result, I will never get paid from you.
We can discuss more details to understand more easily if you have other infos.
Hope to work with you.
Thank you.
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 discuss more detail your project.
Best regards!
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 discussion....
Thanks..
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){.... };