Hi i am using dynamic drop down for state and city.., when i am selecting the state and city from drop-down after insertion state id is going into database I want insert state name instead of id . if i am removing id from in(option value=id) dyanamic drop down is not working.... please suggest me
This is My Blade Template:
<form method="POST" action="{{URL::to('test/insert')}}">
<input type="hidden" name="_token" value="{{csrf_token()}}"/>
<select name="state" id="state" class="form-control input-sm">
@foreach($states $state)
<option value="{{$state->id}}">{{$state->name}}</option>
@endforeach
</select>
<select id="city" class="form-control input-sm" name="city">
<option value=""></option>
</select>
<input type="submit" name="submit">
</form>
<script>
$('#state').on('change',function(e){
console.log(e);
var state_id = e.target.value;
$.get('city?state_id=' + state_id, function(data){
$('#city').empty();
$.each(data,function(index,subcatObj){
$('#city').append('<option value="'+subcatObj.name+'">'+subcatObj.name+'</option>');
});
});
});
This is My controller:
public function state()
{
$states=DB::table('states')->get();
return View::make('index')->with('states',$states);
}
public function city()
{
$state_id=Input::get('state_id');
$cities=DB::table('towns')->where('state_id','=', $state_id )->get();
return Response::json($cities);
}
This is my Insert states and city Controller:
public function insert()
{
$s_name=array('state' => Input::get('state'),
'city' => Input::get('city'));
DB::table('test')->insert( $s_name);
}
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire