Laravel Array Output

Question

I am perfoming a query in my controller and outputting the total cost on my view.

Heres my query:

 $stat = array(
            'TotalCost' => DB::table('ORD_DETAIL')
                        ->select(DB::raw('SUM(OD_QTYORD * OD_QTYUNIT * OD_COSTPRICE) as TotalCost'))
                        ->where('OD_ORDER_NUMBER',$id)->first()
            );

Heres my output:

{{ $stat['TotalCost'] }}

But I am getting the error:

htmlentities() expects parameter 1 to be string, object given (View: F:\view.blade.php)

Try adding get() after first() - ...first()->get()

Alex Lomia
– Alex Lomia

2016-04-28 15:39:01 +00:00
Commented Apr 28, 2016 at 15:39 — Alex Lomia
– Alex Lomia, Commented Apr 28, 2016 at 15:39

Rwd · Accepted Answer · 2016-04-28 15:40:46Z

2

The reason you're getting the above error is because you're query is returning an Object.

To get around this you can either do:

{{ $stat['TotalCost']->TotalCost }}

Or you could change your query to use Laravel's built-in sum() method:

DB::table('ORD_DETAIL')
    ->where('OD_ORDER_NUMBER',$id)
    ->sum(DB::raw('OD_QTYORD * OD_QTYUNIT * OD_COSTPRICE'));

Hope this helps!

answered Apr 28, 2016 at 15:40

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

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

Comments

oseintow · Accepted Answer · 2016-04-28 16:13:45Z

0

Change it to

{{ $stat['TotalCost']->TotalCost }}

To maintain

{{ $stat['TotalCost'] }}

change your query to

 $stat = array(
        'TotalCost' => DB::table('ORD_DETAIL')
                    ->select(DB::raw('SUM(OD_QTYORD * OD_QTYUNIT * OD_COSTPRICE) as TotalCost'))
                    ->where('OD_ORDER_NUMBER',$id)->lists('TotalCost')->first();
        );

edited Apr 28, 2016 at 16:13

answered Apr 28, 2016 at 16:08

oseintow

7,4213 gold badges28 silver badges31 bronze badges

Collectives™ on Stack Overflow

Laravel Array Output

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related