How to write PHP code inside blade template

Question

In my Laravel blade template, I have a table in which I want to add another column after this code

<td>{{format_price($mission->amount)}}</td>

I added this :

    @php
        $amount_to_be_collected = DB::table('shipments')
        ->select('amount_to_be_collected')
        ->where('mission_id', $mission->id)
        ->get();
    @endphp

<td>{{format_price($amount_to_be_collected)}}</td>

What is wrong with this code?

@groovy_guy there is no difference (sql injection wise) between a code in the blade and one in the controller. both are server side (if that is what you though of). — N69S
– N69S, Commented Oct 30, 2021 at 9:45
@Abdelouahad Elfihri it would be better if your mention problem you facing error anything? — Amir Khan
– Amir Khan, Commented Oct 30, 2021 at 9:50
@groovy_guy it still not open to SQL injection since he is using the eloquent query builder and not a raw statement. Being in the blade or the controller has nothing to do with this type of vulnerabilities — N69S
– N69S, Commented Oct 30, 2021 at 9:52
@groovy_guy yeah, using @php --- @endphp is no good in the blade and putting a query in the blade is very bad. but nothing to do with SQL injection — N69S
– N69S, Commented Oct 30, 2021 at 9:56

N69S · Accepted Answer · 2021-10-30 09:50:02Z

2

First of all, You should not put DB query code in your blade.

Now, when you run a query using eloquent and call get(), the response is a Collection::class instance that can be treated as an array but cannot be automatically transformed into a number/string.

If you only need the value of on field for one entry, use value() instead.

$amount_to_be_collected = DB::table('shipments')
    ->where('mission_id', $mission->id)
    ->value('amount_to_be_collected');

answered Oct 30, 2021 at 9:50

N69S

17.3k4 gold badges25 silver badges41 bronze badges

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

1 Comment

Abdelouahad Elfihri Over a year ago

thanks millions times brother it works

Amir Khan · Accepted Answer · 2021-10-30 09:46:52Z

0

Note: It is not good to use db queries in blade views, you can also use helper

Try this before using DB facade you need to call this class in blade view Running Database Queries

use Illuminate\Support\Facades\DB;

edited Oct 30, 2021 at 9:46

answered Oct 30, 2021 at 9:43

Amir Khan

4415 silver badges14 bronze badges

1 Comment

N69S Over a year ago

Laravel has an alias for the DB facade on the root namespace, you can use \DB directly

Collectives™ on Stack Overflow

How to write PHP code inside blade template

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related