console.log(data) shows null value please check my code. why it shows null value?

Level 11

Can you try to clean your route cache?

php artisan route:cache

Otherwise you can review in the cliente side the network bar, and check the request

Level 3

@jonhcr in network bar all request status is 200 means ok

Level 73

@kanchan186 and do you have a state for that region? You can check that in your database.

Check the network tab as well to see which state gives that result.

Null is different than an empty array.. for you it seems like there is no state in the database for that region.

add a dump($region); in your controller as a first line, and inspect in the network tab if the correct region_id is being used.

Level 3

@jonhcr i updated my code

i want to fetch values from region_areas table

in controller

 public function StateAjax($region_area)
    {
        $state = State::where("region_id",$region_area)
                    ->pluck('states.state_id','states.state_id')->all();
        return json_encode($state);
    }

in script

function getState(region_area)
                            {
                               if(region_area) {
                                        $.ajax({
                                            url: '{{url('/')}}/state/ajax/'+region_area,
                                            type: "GET",
                                            dataType: "json",
                                            success:function(data) {
                                        
                                             console.log(data);
                                                $('select[name="state_id"]').empty();
                                                $('select[name="state_id"]').prepend('<option value="">--Select State--</option>');
                                                $.each(data, function(key, value) {
                                                    $('select[name="state_id"]').append('<option value="'+ key +'">'+ value +'</option>');
                                                });

                                            }
                                        });
                                    } else{
                                         $('select[name="state_id"]').empty();
                                    }
                            }

in web.php

Route::get('state/ajax/{region_area}','AreaController@StateAjax');

please check my code

Level 3

@nakov first code is wrong i realize my mistake , i am trying to fetch data from region table where state_id is not present.

and i updated my code please check updated code actually i want to fetch data from region_areas table and i made changes for that

still it gets null value

Level 73

@kanchan186 but [] is not equal with null so you are actually getting an empty collection, which means that your controller code is running, but for the ID that you are checking there is no State. So please check the browser's network tab, and play around with dump() helper to print out which ID are you sending, and which ID is being used in the controller code.

public function StateAjax($region_area)
{
    dump($region_area);
    $state = State::where("rarea_id",$region_area)
                    ->pluck('states.state_id','states.state_id')->all();
    return json_encode($state);
}

And check the network tab for this request.

And you are using State model here, but you've shown code from region_areas table. Do you have protected $table = 'region_areas'; in your State model?

Level 3

@nakov in console

{1: "Zone 1", 3: "zone 2"}
{15: "South India"}
 []

gives output this type state value is null []

in network tab output

Level 3

@nakov Do you have protected $table = 'region_areas'; in your State model?

         no sir

Level 73

@kanchan186 in your Network tab you have JS selected, this is an XHR request, not JS.. as you can see all the .js files are listed.

And if you don't have then you are looking for results in the wrong table. You have shown above results from region_areas table, but you are looking for the record in your states table..

Will this one work:

DB::table('region_areas')
    ->where('rarea_id', $region_area)
    ->join('states', 'states. state_id', '=', 'region_areas.state_id')
    ->pluck('states.state_id','states.state_id')->all();

Change it accordingly if it does not work. You should look for results in the table where you expect them to exist..

Level 3

@nakov

using above code in network tab

and in console

{1: "Zone 1", 3: "zone 2"}
{15: "South India"}
[]

Level 73

@kanchan186 There is a Preview / Response tabs there in the Network, so checkout those as well.

And the response is [] because as you can see in your database there is no rarea_id=15...

Level 3

@nakov sir rarea_id is not required i think because i have to fetch states info on region_id

Level 73

@kanchan186, as I mentioned, you need to use the correct table and column names..

So this might work then

DB::table('region_areas')
    ->where('region_id', $region_area)
    ->join('states', 'states. state_id', '=', 'region_areas.state_id')
    ->pluck('states.state_id','states.state_id')->all();

Level 3

@nakov still it shows null... may be problem in my view please check my view for region and state

Level 3

             <div class="form-group">
                                        <h5>Region Name <span class="text-danger">*</span></h5>
                                        <div class="controls">
                                            
                                             <select class="form-control " name="region_id" onchange="getState(this.value)" required>
                                                <option>--Select Region--</option>
                                           
                                        </select>
                                    </div>
                                       
                                    </div>
                                       
                                    
                                    <div class="form-group">
                                        <h5>Select State <span class="text-danger">*</span></h5>
                                        <div class="controls">
                                            
                                             <select class="form-control" name="state_id" id="state_id" onchange="getCity(this.value)"   required>
                                            <option>--Select State--</option> 
                                           
                                        </select>

                                        </div>
                                       
                                    </div>

@nakov please check this code