Fetching and printing a single value from database using laravel

Question

I'm currently trying to create my settings page by creating a table settings with company_name column. My idea is to fetch the single value company_name and print it in the title of the pages and where the name is going to be appearing. I just am not sure how to convert the array return from the DB::select to be able to print it correctly.

The code:

public function __construct()
{ 
    $company_name = DB::table('settings')->select('company_name')->get();

    return View::share('company_name', $company_name);
}

And print it in the blade system as {{ $company_name }}, although it can't convert an array to string.

alxscms · Accepted Answer · 2014-04-14 16:12:05Z

1

Either use eloquent (that I would recommend) which would be like this :

$company_name = Setting::first()->company_name;

or using fluent :

$company_name = DB::table('settings')->company_name;

edited Apr 14, 2014 at 16:12

answered Apr 14, 2014 at 15:54

alxscms

3,0576 gold badges24 silver badges43 bronze badges

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

1 Comment

Lucas Gomez Over a year ago

Awesome! I was actually close to that one using Eloquent with $company_name = Setting::where('id', '=', '1')->firstOrFail(); My only concern now is that it prints as: {"company_name":"NOMBRE DE EMPRESA"}

Chrisky · Accepted Answer · 2014-04-14 15:01:53Z

0

Could you use ->first() to select the first value from the returned set?

answered Apr 14, 2014 at 15:01

Chrisky

5773 silver badges9 bronze badges

2 Comments

Chrisky Over a year ago

And if you have more than one entry in your settings, you can perhaps use ->where($id, $_COOKIE["SessionId"]) and add a SessionID column to your table.

Lucas Gomez Over a year ago

That returns with a "Object of class stdClass could not be converted to string"

hannesvdvreken · Accepted Answer · 2014-04-14 15:45:40Z

0

I think you should re-think your DB schema.

But if you want an answer to keep working with you current schema:

DB::table('settings')->select('company_name')->first();

This can throw an Eloquent ModelNotFound exception.

EDIT

public function __construct()
{ 
     $result = DB::table('settings')->select('company_name')->first()->toArray();

     return View::share($result);
}

edited Apr 14, 2014 at 15:45

answered Apr 14, 2014 at 15:16

hannesvdvreken

4,9981 gold badge18 silver badges17 bronze badges

5 Comments

Lucas Gomez Over a year ago

Unfortunately that doesn't work either. It actually returns with an errorBadMethodCallException Call to undefined method Illuminate\Database\Query\Builder::firstOrFail()

hannesvdvreken Over a year ago

You're right, @LucasGomez! I learnt something today! The query builder doesn't have that method. One more reason to use Eloquent. Use the ->first() method instead.

Lucas Gomez Over a year ago

Yup, I was reading it works only when using Eloquent models, which I actually am, for this settings (update mostly). Using first(); returns "Object of class stdClass could not be converted to string"

Lucas Gomez Over a year ago

Went ahead and made it like this: $company_name = Setting::where('id', '=', '1')->firstOrFail(); It works now, but it prints the whole thing: "{"id":1,"company_name":"Sabores No Colombianos","created_at":"0000-00-00 00:00:00","updated_at":"2014-04-14 15:25:32"}"

hannesvdvreken Over a year ago

@LucasGomez Try Setting::where('id', '=', '1')->select('company_name')->firstOrFail();

Collectives™ on Stack Overflow

Fetching and printing a single value from database using laravel

3 Answers 3

1 Comment

2 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related