mercredi 15 août 2018

Trying to access to array in view return Trying to get property of non-objec

I'm using Laravel 5.2, I'm trying to execute a stored procedure and display the result in a view using a foreach loop. When I run my app I get the following error message:

Trying to get property of non-object

If I use return or dump I get the following result:

Result

Here is my controller code:

public function VentasPorSucursal() {
    $values = [1, 25, 2, "NULL", "2018-08-10", "2018-08-10", "NULL", "NULL"];

    $data['data'] = DB::select('SP_RPT_VENTAS2 ?, ?, ?, ?, ?, ?, ?, ?', $values);

    //dump($data);
    return view('reportes.index')->with('data', $data);
}

And this is my index.blade.php

<div class="table-responsive">
        <table class="table table-striped table-bordered table-condensed table-hover">
            <thead>
                <th>Folio</th>
                <th>Fecha</th>
                <th>Sucursal</th>
                <th>Vendedor</th>
                <th>Cantidad</th>
                <th>Unidad</th>
                <th>Descripción</th>
                <th>Pzaz x Pq</th>
                <th>Precio</th>
                <th>Total</th>
                <th>Total Pzaz. Vendidas</th>
            </thead>
            @foreach ($data as $result)
                <tr>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                </tr>

            @endforeach
        </table>
    </div>
    

Looking for an answer I found that using '->' it's for an array and maybe my code is returning the result as an object and I need to use '[]' but I don't know exactly how can I do it.

What could be the problem?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire