Home / Questions / 209759
Accepted
pxs
Asked: 2020-11-01 13:38:22 +0800 CST 2020-11-01 13:38:22 +0800 CST

how to read db query?

  • 772

I am using laravel and I do the following query:

$cantidadDeposito  = DB::select('SELECT SUM(cantidad) FROM `finanzas` WHERE miembro = ?', [$idNombre]);
print_r ($cantidadDeposito);

Which gives me as a result:

stdClass Object ( [SUM(cantidad)] => 750 )

how can i just read the number?

Thanks.

laravel-5

1 Answers

  1. Best Answer

    I recommend that you use an alias in your query like this:

    $cantidadDeposito  = DB::select('SELECT SUM(cantidad) 
AS total FROM `finanzas` WHERE miembro = ?', [$idNombre]);

    and then to print it:

    echo $cantidadDeposito->total;
    • 0