get a single value from the database using laravel

Question

i always use this ugly code to get a single value from the database for a given id

for example here i want to get the number of visits for a website

// ============================================ getNumberOfVisits()
//  
//  website_name : ..
//  return the number of visits for a given website
//
private function getNumberOfVisits($website_name)
{
    $visits = Website::where('name', $website_name)->get(['number_of_visit']);
    return $visits[0]['attributes']['number_of_visit'];
}

is there another way to get a single value from the database for a particular column given a where statement?

no, it's just too long, and i was wondering that it may be a better way to achieve the same result. — Oussama Elgoumri
– Oussama Elgoumri, Commented Jan 11, 2015 at 20:05

lukasgeiter · Accepted Answer · 2015-01-11 20:17:47Z

3

How about this?

$website = Website::where('name', $website_name)->first(['number_of_visit']);
return $website->number_of_visit;

Or even better:

$visits = Website::where('name', $website_name)->pluck('number_of_visit');

In case you want to know...

pluck() actually does the same as my first code example. Here's the source:

public function pluck($column)
{
    $result = $this->first(array($column));

    if ($result) return $result->{$column};
}

answered Jan 11, 2015 at 20:17

lukasgeiter

154k29 gold badges349 silver badges280 bronze badges

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

1 Comment

lukasgeiter Over a year ago

Well I like it more than something like getSingleValueFromFirstResult ;)

Collectives™ on Stack Overflow

get a single value from the database using laravel

1 Answer 1

In case you want to know...

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

In case you want to know...

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related