Using WHERE in Laravel Returns Empty Array

Question

I'm trying to do a WHERE in Laravel. My model has id_usuario, and in my database, I have five rows with id_usuario = 3, but Laravel is only returning an empty array.

Controller

<?php

public function show(Request $request)
{
    $animaisPerdidos = AnimalPerdido::where('id_usuario', $request->id);

    return response()->json($animaisPerdidos);
}

Route

Route::get('selectanimalperdido', 'AnimalPerdidoController@show');

In Postman

Model

class AnimalPerdido extends Model
{
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */

    protected $table = 'animais_perdidos';

    protected $fillable = [
        'id', 'id_usuario', 'lat', 'lng', 'id_tipo_pet', 'raca', 'id_sexo', 'data', 'possui_identificador', 'id_cores', 'informacoes_adicionais', 'nome_identificador', 'foto'
    ];  

}

wamba kevin · Accepted Answer · 2018-12-01 16:07:29Z

4

use the code below for your controller "get() if you want an array or first() if you want first result":

public function show(Request $request)
{
    $animaisPerdidos = AnimalPerdido::where('id_usuario', $request->id)->get();

    return response()->json($animaisPerdidos);
}

answered Dec 1, 2018 at 16:07

wamba kevin

3093 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Criss Over a year ago

This is correct - ->where(...) returns just a query builder, to actually get the results from query builder you need to call ->where(...)->get(), which will actually retrieve the results using the built query. Also, I don't think that $request->id is going to get you the input variable, as Eric pointed out and you should replace thast with $request->get('id') or $request->input('id').

groenhen · Accepted Answer · 2018-12-02 05:34:50Z

2

Just append "->get()" at the end of query, like below:

AnimalPerdido::where('id_usuario', $request->id)->get();

edited Dec 2, 2018 at 5:34

groenhen

3,02725 gold badges51 silver badges69 bronze badges

answered Dec 1, 2018 at 17:31

Saurabh Bhatewara

1102 bronze badges

Comments

Abdo Abo · Accepted Answer · 2018-12-01 15:34:08Z

0

Change :

Route::get('selectanimalperdido', 'AnimalPerdidoController@show

to

Route::get('selectanimalperdido/{id}', 'AnimalPerdidoController@show');

answered Dec 1, 2018 at 15:34

Abdo Abo

931 gold badge2 silver badges14 bronze badges

1 Comment

Criss Over a year ago

If he does that, he needs to change the controller as well, to receive the ID variable, as well as change the request url. But that's not needed here.

Eric Vautier · Accepted Answer · 2018-12-01 15:41:29Z

0

You need $request->input('id');

https://laravel.com/docs/5.7/requests#accessing-the-request

answered Dec 1, 2018 at 15:41

Eric Vautier

1485 bronze badges

Collectives™ on Stack Overflow

Using WHERE in Laravel Returns Empty Array

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related