Monday, May 20, 2024
 Popular · Latest · Hot · Upcoming
69
rated 0 times [  74] [ 5]  / answers: 1 / hits: 5585  / 10 Years ago, thu, april 10, 2014, 12:00:00

I am using laravel and i need to populate multiple select according to what user choose from a database.
I have 2 select box, one choose category, then once i choose the category, the second select box is populated with product.
Once the second select is populate with product i need to fetch from database all the description of that product and show in a form so it can be modified.



I did a Route:



 Route::get('api/dropdown', function(){
$input =Input::get('option');

$prodotti= DB::table('prod')
->join('cat','cat.id_prod','=','prod.id')
->where('cat.id','=',$input)
->select('prod.id as idprod','prod.nome as nomeprod')
->lists('nomeprod','idprod');


return Response::json($prodotti);
});


This should send a response



{{ Form::open(array('url' => 'admin/create/mod', 'files'=> true)) }}
<span>
{{ Form::select('categorie', $categorie,'default', array('id'=> 'a')) }}
<br/>

{{ Form::select('a',array('a'=> 'scegli'),'default', array('id'=> 'b')) }}

Scegli il nome del prodotto

{{Form::text('nome')}}
<br/>
{{Form::label('*Descrizione in Italiano')}}
<br/>
{{Form::textarea('descrizioneit','',array('id'=>'descrizioneit'))}}
{{Form::textarea('descrizioneit','',array('id'=>'previewit', 'readonly'=>'readonly', 'onfocus'=>'this.blur();'))}}
<br/>
{{Form::label('*Descrizione in Inglese')}}
<br/>
{{Form::textarea('descrizioneen','',array('id'=>'descrizioneen'))}}
{{Form::textarea('descrizioneen','',array('id'=>'previewen', 'readonly'=>'readonly', 'onfocus'=>'this.blur();'))}}
<br/>

{{Form::close()}}


This is my javascript



jQuery(document).ready(function($){
$('#a').change(function(){
$.get({{ URL::to('api/dropdown')}},
{ option: $(this).val() },
function(data) {
var model = $('#b');
model.empty();

$.each(data, function(element) {
model.html(element);
});
});
});
});


Then i should do another api to populate the textbox with the product description i have chosen?



I would follow this idea but even the firt part of this doesn't work.
It seems that my javascript code is ignored.


More From » php

 Answers
4

The problem lies in how you are filling out your select.



jQuery(document).ready(function($){
$('#a').change(function(){
$.get({{ URL::to('api/dropdown')}},
{ option: $(this).val() },
function(data) {
var model = $('#b');
model.empty();

$.each(data, function(index, value) {
model.append($(<option />).val(index).text(value)); });
});
});
});
});

[#46140] Wednesday, April 9, 2014, 10 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
krystadesiraeo

Total Points: 493
Total Questions: 93
Total Answers: 100

Location: San Marino
Member since Thu, Jun 30, 2022
2 Years ago
;