Print a sum in the view

Question

In the Mysql Workbench the result comes out, but how to print in View?

Errorexception Array to string Conversion

public function listadepontos()
{
    $id = auth()->user()->id;
    $somas = DB::SELECT("select SUM(pontuacao) FROM palpite WHERE id_u = '$id' ");
    return view('pontuacao')->with('somas', $somas);
}

File punctuation.php

<strong> Sua Pontuação é: <?php echo $somas;?>

</strong>

It worked that way:

@foreach($somas as $s)
  <h4><strong> Sua Pontuação é: {{ $s }}   </strong></h4>
@endforeach

Only once did the score appear, but I don’t think it’s the right way to code.

Answer 1

Let’s go according to the pure SQL execution documentation from Larable that says the return of a DB::select is an array of stdClass, (in the documentation in English: The select method will always return an array of results. Each result within the array will be a PHP StdClass object, allowing you to access the values of the results:), then the variable data $somas would actually that a array and in its first position a stdClass. In the Controller in the return method, make this change in the sql:

$sql = "select SUM(pontuacao) as p FROM palpite WHERE id_u=?"
$somas = DB::select($sql, [$id]);
return view('pontuacao')->with('somas', $somas[0]->p);

and consequently in View only:

{{$somas}}

Observing: try sending to your View only what you need to display.

_References:

• Running Raw SQL Queries
• Laravel: Database

Answer 2

The Laravel uses the Blade Engine to work with templates. Your problem is that your return is being a objeto, see what it says to documentation on the method select, to print read the documentation about loops.

The method select will always return a series of results. Each result within the matrix will be an object PHP Stdclass, allowing you to access the values of the results. ( Free translation )

So just do it loop in View

@foreach ($somas as $soma)
    <p>{{ $soma }}</p>
@endforeach

Obs: When answering the question I had put the code above, then I took it, for thinking I was wrong because I had not done test, before negative see the editing history.

Another way to return, without having to do loops, is to change the line:

return view('pontuacao')->with('somas', $somas);

To:

return view('pontuacao')->with('somas', $somas[0]['soma']);

And leave in the View

{{ $somas }}