Level 13
@rohit i dont have any idea about javascript if you help me i glad you!
Feb 26, 2015
104
Level 13
@dinis have you get your problem solved? if still not can you show me your Route of your Form
Level 1
@vipin93 try this
CountriesController.php
public function getIndex($country_id=null) {
$countries = get_all_countries_from_your_model;
$states = array();
if($country_id != null) {
$states = get_all_states_from_your_model_using_country_id;
}
return View::make('index', [“countries” => $countries, ‘states’ => $states]);
}
Index view
<select id="countries-dd" name="countries-dd" class="form-control" onchange="loadStatesForCountryWithId(this.value);">
<option value="-1">Select country</option>
@foreach($countries as $country)
<option value="{{ $country->country_id }}">{{ $country->country_name }}</option>
@endforeach
</select>
@if(sizeof($states) != 0)
<select id=“states-dd" name=“states-dd" class="form-control">
<option value="-1">Select state</option>
@foreach($states as $state)
<option value="{{ $state->state_id }}">{{ $state->state_name }}</option>
@endforeach
</select>
@endif
<script type=“text/javascript”>
function loadStatesForCountryWithId(country_id) {
window.location.href = url_to_your_page/country_id
}
</script>
I've written this on the fly just at the top of my head. There may be some minor errors. But I hope you understand where I'm going with this.
Level 6
@vipin93 no not yet im still not getting any after selecting country
Level 13
@dinis can you show me your route(get) for get Form
Level 6
@vipin93 here is my script
` $('#country').on('change',function(e){ //state change console.log(e); var cat_id = e.target.value;
$.get('ajax-subcat?cat_id=' + cat_id, function(data){
$('#state').empty();
$.each(data, function(edit, subcatObj){
$('#state').append('<option value="'+subcatObj.id+'">'+subcatObj.name+'</option>');
});
});
});
here is my view `
<div class="form-group">
<lablel for="country_id">Select Country:</lablel>
<select name="country_id" id="country" class="form-control">
@foreach($countries as $country )
<option value="{{ $country->countryCODE }}">{{ $country->countryNAME }}</option>
@endforeach
</select>
</div>
<div class="form-group">
<lablel for="state">Select State:</lablel>
<select name="state" id="state" class="form-control">
<option value=""></option>
</select>
</div>
</form>
here is my route `Route::get('ajax-subcat', function(){
$cat_id = Input::get('cat_id');
$states = City::where('cityCOUNTRYCODE', '=', $cat_id)->get();
return Response::json($states);
});
Level 6
@vipin93 im working inside default register page with that one where i add country and city selection
Level 13
@dinis change your country_id to country in your view page
Level 6
@vipin93 still the same
Level 13
@dinis you have three mistake in javascript chnage id to countryCODE and name to countryNAME and one thing //state change delete it
Level 6
@vipin93 sorry where is that?
Level 13
$('#state').append('<option value="'+subcatObj.id+'">'+subcatObj.name+'</option>');
change only id and name not subcatObj.id subcatObj.name
Level 6
@vipin93 here is my script but still the same
`
$('#country').on('change',function(e){
console.log(e);
var cat_id = e.target.value;
$.get('ajax-subcat?cat_id=' + cat_id, function(data){
$('#state').empty();
$.each(data, function(edit, subcatObj){
$('#state').append('<option value="'+subcatObj.countryCODE+'">'+subcatObj.countryNAME+'</option>');
});
});
});
</script>
Level 13
@dinis where is your controller how you fetching country and what mean of countryCode is that same to id and where is you fetching city or state
Level 6
my controller is in my route
Level 13
@dinis plz show me
Level 6
here is my route
`Route::get('ajax-subcat', function(){
$cat_id = Input::get('cat_id');
$states = City::where('cityCOUNTRYCODE', '=', $cat_id)->get();
return Response::json($states);
});
Level 13
@dinis where you fetching Country
Level 6
from my database
Level 13
@dinis I mean in your controller or in route show me
Level 6
here is the code in my view @foreach($countries as $country ) countryCODE }}">{{ $country->countryNAME }} @endforeach
Level 13
@dinis did you see your country in your country option in view
Level 6
yes i can see the list of country in my first selection but when i select country no city is being shown
Level 13
Thats by i'm saying you show me your controller or route where your register form get
If you still not try it from start as in this link http://laravel.io/bin/yGYwo
Level 13
@rohit i'm geting error Uncaught ReferenceError: loadStatesForCountryWithId is not defined
Level 6
i have that i think already
here is my controller
` public function getRegister() { $genders = Gender::all(); $countries = Country::all(); $cities = City::all();
return view('auth.register',compact("genders","countries","cities"));
}
Level 13
public function getRegister()
{
$genders = Gender::all();
$countries = Country::all();
return view('auth.register',compact("genders","countries"));
}
Level 6
why should i remove cities??
here is what im getting after checking the browser console
`Object { originalEvent: change, type: "change", isDefaultPrevented: bb(), timeStamp: 1424970971903000, jQuery1112004522455806518644: true, which: undefined, view: undefined, target: <select#country.form-control>, shiftKey: undefined, relatedTarget: undefined, 10 more… }
Level 13
Bcz in route you already mentioned
`Route::get('ajax-subcat', function(){
$cat_id = Input::get('cat_id');
$states = City::where('cityCOUNTRYCODE', '=', $cat_id)->get();
return Response::json($states);
});
Did you using jquery or not
Level 14
If you want to still RESTful you can have a route like this
Route::get('countries/{id}/cities', function() {
// Do what you need to do.
});
I can't see where is your problem. You just need to send an AJAX request to a URL and use return values to create your new select.
Please or to participate in this conversation.