Home / Questions / 148427
Accepted
albertolg89
Asked: 2020-03-20 04:44:20 +0800 CST 2020-03-20 04:44:20 +0800 CST

Problems displaying elements in laravel 5.0

  • 772

I am doing this query

$ventas = VentasProductos::select('id_factura','=' ,$id);

to a database table from a Controller InvoiceController and when I check the number of elements it returns me that elements exist but when displaying them in a view it does not return values. How can i solve this?

laravel-5

2 Answers

  1. Best Answer

    The query to use an Eloquent would be:

    $ventas = VentasProductos::where('id_factura',$id)->get();

    That would be a query to the model you made. It is not selectsince that is used to specify fields of the model you created.

    Now you have to have the model imported into the Controller you created for it to work as well. But if that's not the case you can use DBde Query Builderwhich I don't recommend but it's used for queries that don't use models created in your project.

    $ventas = DB::select('select * from nombreTabla where id_factura =:id', ['id' => $id]);
    • 1

  2. Your query is fine but it is incomplete, that is, once you execute these operations you have to indicate it with another method to return the results, in this case, since you are making a query with a filter at the end, you must have access to the get() method. ;

    then it should be:

    $ventas = VentasProductos::where('id_factura','=' ,$id)->get();
    • 1