Adding columns in table

Question

I have display quantity and price attributes on my table from database but for some reasons I don't save the total into database but I display total by multiplying quantity * total on the table when data is being fetched.

Total for every column on my table is being displayed accurately. Is there a way that I can add all total columns on the table in my html?

PS: with my code, it only displays the total of the current column of the table

Table

<tbody>
    @foreach($items as $items)
        <tr>
            <td>{{$item>id }}</td>
            <td>{{$item->quantity}}</td> 
            <td>{{ $item->price}}</td>
            <td>{{ $item->quantity * $item->price}}</td>
        </tr>    
    @endforeach
    <p>Sum: {{ $item->quantity * $item->price}}</p>
</tbody>

you can easily google this kind of things do not post this kind of questions here. you can use JS as well jsfiddle.net/z_acharki/jnwrc5ay/347 — Ravi Sharma
– Ravi Sharma, Commented Nov 13, 2017 at 11:54

tompec · Accepted Answer · 2017-11-13 11:50:26Z

1

<tbody>
    {{ $total = 0 }}
    @foreach($items as $items)
        <tr>
            <td>{{$item>id }}</td>
            <td>{{$item->quantity}}</td> 
            <td>{{ $item->price}}</td>
            <td>{{ $item->quantity * $item->price}}</td>
            {{ $total = $total + ($item->quantity * $item->price) }}
        </tr>

    @endforeach
    <p>Sum: {{ $total }}</p>
</tbody>

answered Nov 13, 2017 at 11:50

tompec

1,2309 silver badges16 bronze badges

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

3 Comments

Ravi Sharma Over a year ago

don't do copy paste you copied sapnesh ans. and just lil bit modified it.

tompec Over a year ago

Yeah dude, look at the time difference, < 1min, also his code doesn't work.

Ravi Sharma Over a year ago

yup ! you are correct let me give you +1 for this :-)

Sapnesh Naik · Accepted Answer · 2017-11-13 11:49:31Z

0

You can use blade's @php directive like this

<tbody>
@php
$total = 0
    @foreach($items as $items)
    <tr>
        <td>{{$item>id }}</td>
        <td>{{$item->quantity}}</td> 
        <td>{{$item->price}}</td>
        <td>{{$total = $total + ($item->quantity * $item->price)}}</td>        
    </tr>        
    @endforeach

    <p>Sum: {{ $total }}</p>
@endphp
</tbody>

answered Nov 13, 2017 at 11:49

Sapnesh Naik

11.7k9 gold badges70 silver badges103 bronze badges

Comments

Ronak Lodaya · Accepted Answer · 2017-11-13 11:50:52Z

0

Try the following:

{{ $sum = 0 }}
<tbody>
    @foreach($items as $items)
       <tr>
          <td>{{$item>id }}</td>
          <td>{{$item->quantity}}</td> 
          <td>{{ $item->price}}</td>
          <td>{{ $item->quantity * $item->price}}</td>
      </tr>
      $sum+ = $item->quantity * $item->price;
    @endforeach
    <p>Sum: {{ $sum }}</p>
</tbody>

answered Nov 13, 2017 at 11:50

Ronak Lodaya

1311 gold badge6 silver badges16 bronze badges

Comments

Erin · Accepted Answer · 2017-11-13 13:06:13Z

0

I assume here $items is a Illuminate\Support\Collection. You can calculate a sum using a closure:

$items->sum( function ($item) {
    return $item->quantity * $item->price;
});

Or in your blade template:

{{ $items->sum( function ($item) {
    return $item->quantity * $item->price;
}); }}

See Laravel Collections docs.

answered Nov 13, 2017 at 13:06

Erin

5,8853 gold badges22 silver badges37 bronze badges

Collectives™ on Stack Overflow

Adding columns in table

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related