Getting value from database column Laravel

Question

May be is simple but I have one table where I want to take value from one column. They are two records and always will be two records and I need value from second id.. Here is visual

id     key      value
 1    key_1     Value_1
 2    key_2     value_2

I want to take value_2. Here is what I have in my controller

$free = DB::table('settings')->select('value')->where('key', '=', 'free')->get();
    return View::make('site.cart.order', [
        'cart' => $cart,
        'free' => $free
    ]);

And in my view I'm trying this

@if( $total < $free['value'] )

   // loop
@endif

Currently I'm getting - Undefined index: value

DB93 · Accepted Answer · 2016-07-28 10:23:04Z

1

If I'm right Laravel returns a standard class there and you should access it like this.

$free->value

Instead of

$free['value']

But you have to change now it selects the first record

$free = DB::table('settings')->select('value')->where('key', '=', 'free')->first();

Then you can access it like

$free->value

Or if you don't want to change get() to first() you can access it like this because get() returns an array.

$free[0]->value

edited Jul 28, 2016 at 10:23

answered Jul 28, 2016 at 10:16

DB93

6122 gold badges6 silver badges16 bronze badges

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

7 Comments

S.I. Over a year ago

Got this: 'Trying to get property of non-object'

DB93 Over a year ago

Could you give me the output of $free when you var_dump it?

S.I. Over a year ago

This, which is correct info array(1) { [0]=> object(stdClass)#285 (1) { ["value"]=> string(3) "101" } }

S.I. Over a year ago

is it big difference between get() and first()? I mean which one is preferable for use?

DB93 Over a year ago

Yes because you only need one value so there is no need for get() because you don't need multiple records

|

jeanj · Accepted Answer · 2016-07-28 10:29:40Z

1

Use first() instead of get() and use $free->value, get() return an array of object

edited Jul 28, 2016 at 10:29

answered Jul 28, 2016 at 10:16

jeanj

2,16615 silver badges22 bronze badges

1 Comment

S.I. Over a year ago

Got this: 'Trying to get property of non-object'

Collectives™ on Stack Overflow

Getting value from database column Laravel

2 Answers 2

7 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related