Laravel variable value being lost when passing to a function

Question

$country = DB::table('location_countries')->where('name','India')->first();
$country_id = $country['_id'];
echo $country_id;
$states = DB::table('location_states')->where('country_id',$country_id)->first();
echo $states['name'];

above is the code i am running in the controller i have used jenseggers/mongodb for the mongodb connection.

till this part of code i can see the response when i do the echo

$country = DB::table('location_countries')->where('name','India')->first();
$country_id = $country['_id'];
echo $country_id;

after i pass the $country_id to the function as below it shows no response

$states = DB::table('location_states')->where('country_id',$country_id)->first();
echo $states['name'];

if i directly pass the string like the below code instead of passing the $country_id variable then i get a response but if i pass a variable there is no response.

$states = DB::table('location_states')->where('country_id','value-here')->first();

Why is this happening and how to bypass this.

Try $states = DB::table('location_states')->where('country_id', '=' ,$country_id)->first(); — Sreejith BS
– Sreejith BS, Commented Sep 4, 2017 at 17:24

Wreigh · Accepted Answer · 2017-09-05 01:37:41Z

2

Query returns an object not an array so use it like this:

If you want to retrieve the id column: $country->id;

The same is true for states, e.g., the name column: $states->name;

Also try with trim maybe there is any blank space:

where('country_id', trim($country_id))

edited Sep 5, 2017 at 1:37

Wreigh

3,29719 silver badges40 bronze badges

answered Sep 4, 2017 at 17:28

Niklesh Raut

34.9k17 gold badges82 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Rushikesh Akhare Over a year ago

This is also not working as i have tried this before.

Niklesh Raut Over a year ago

What is your , echo $country_id; ?

Rushikesh Akhare Over a year ago

it is echoing a value for country id

Niklesh Raut Over a year ago

Also try with trim : where('country_id',trim($country_id))

Rushikesh Akhare Over a year ago

worked perfectly with trim. Whats the logic behind it

|

Collectives™ on Stack Overflow

Laravel variable value being lost when passing to a function

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related