How to get string value using eloquent query

Question

I am trying to execute a query using eloquent, however it returns me an array. What I want is to only get the string value of my query.

This is what I get

[{"name":"hey"}] [{"name":"sdasdasd"}]

Here's my eloquent query:

 $categoryName = Category::select('name')->where('id', request('category'))->get();
 $subCategory = Subcategory::select('name')->where('id', request('subCat'))->get();

if you always get single value then use first in place of get . it will return single object — Gaurav Gupta
– Gaurav Gupta, Commented Sep 4, 2019 at 10:14
[{"name":"hey"}] [{"name":"sdasdasd"}] aren't arrays, they are instances of Collections which means that when you iterate over them, you can access their values using the ->name syntax, rather than array syntax: ['name'] :) fyi — party-ring
– party-ring, Commented Sep 4, 2019 at 10:22
@party-ring Oh sorry I'm not good with terminologies. :) Thank you for the tip! — kwestionable
– kwestionable, Commented Sep 4, 2019 at 10:27

Kareem Essawy · Accepted Answer · 2019-09-04 10:16:53Z

3

as per the Laravel Docs

Retrieving A Single Row / Column From A Table If you just need to retrieve a single row from the database table, you may use the first method. This method will return a single stdClass object:

$user = DB::table('users')->where('name', 'John')->first();

echo $user->name;

If you don't even need an entire row, you may extract a single value from a record using the value method. This method will return the value of the column directly:

$email = DB::table('users')->where('name', 'John')->value('email');

so in your example maybe you need to do something like the following :

$subCategory = Subcategory::select('name')->where('id', request('subCat'))-> first();

echo $subCategory->name;

answered Sep 4, 2019 at 10:16

Kareem Essawy

6151 gold badge6 silver badges16 bronze badges

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

1 Comment

kwestionable Over a year ago

Thank you, I was thinking of the native PHP kind of query. Thank you!

Udara Chathuranga · Accepted Answer · 2019-09-04 10:32:33Z

0

There are so many ways to achive your goal.

Solutions

Use pluck().

$categoryName = Category::select('name')
                ->where('id', request('category'))
                ->pluck()
                ->first();

Use model properties.

$categoryName = Category::find(request('category'))
                ->name;

answered Sep 4, 2019 at 10:32

Udara Chathuranga

1515 bronze badges

Comments

kirubha · Accepted Answer · 2019-09-04 11:44:39Z

0

If you take only name then follow the below code.

$categoryName = Category::where('id', request('category'))->first()->name;
$subCategory = Subcategory::where('id', request('subCat'))->first()->name;

echo $categoryName;
echo $subCategory;

If you take all columns in a row follow the below code:

$categoryName = Category::where('id', request('category'))->first();
$subCategory = Subcategory::where('id', request('subCat'))->first();

echo $subCategory->name;
echo $categoryName->name;

I hope this i may help you.Try this.

answered Sep 4, 2019 at 11:44

kirubha

1337 bronze badges

Comments

Salman Zafar · Accepted Answer · 2019-09-04 12:02:33Z

0

You can get the answer using

$name = DB::table('Category')->where('id','=',request('category'))->pluck('name')->first();

echo $name;

edited Sep 4, 2019 at 12:02

Salman Zafar

4,0655 gold badges23 silver badges44 bronze badges

answered Sep 4, 2019 at 11:42

Franklin Innocent F

2714 silver badges12 bronze badges

Comments

FocusPlanet · Accepted Answer · 2020-09-09 08:26:33Z

0

$name = Category::select('name')->where('id', request('category'))->take(1)->orderBy('id','asc')->first()->name;

echo $name;

OR

echo Category::select('name')->where('id', request('category'))->take(1)->orderBy('id','asc')->first()->name;

answered Sep 9, 2020 at 8:26

FocusPlanet

1

Collectives™ on Stack Overflow

How to get string value using eloquent query

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related