Home / Questions / 525142
Accepted
TaM
Asked: 2022-09-01 00:42:27 +0800 CST 2022-09-01 00:42:27 +0800 CST

GET query in View Laravel

  • 772

I am making a query to the DB from a view with eloquent to print a table, the case is that it works but before the table, where I have the query, it prints the array.

How should I do the query so that it only saves the data to be used in the table but does not print it on the page?

{{ $zero_users = DB::table('empleados')->where('estado', 0)->get() }}

enter image description here

eloquent

1 Answers

  1. Best Answer

    Good day,

    In your controller there is a method showthat is used to return the view that you are going to show, you can pass the response of the query that you make to your database in the following way (Below I show an example that you must adapt to your controller, I do not know the name of your view so I put user.profile):

    public function show($id)
{
    return view('user.profile', [
        'zero_users' => DB::table('empleados')->where('estado', 0)->get()
    ]);
}

    Although I would recommend you first create a variable with your query (This is what you can do dd()to see if it returns the correct information

    public function show($id)
{
    $zero_users = DB::table('empleados')->where('estado', 0)->get()
    // Si necesitas comprobar $zero_users puedes hacer dd($zero_users)

    return view('user.profile', [
        'zero_users' => $zero_users
    ]);
}
    • 1