Problem in making a field search by date and id

Question

Problem in making a field search by date and id

Navigation

#1 by (0 votes)

1

I've made a search field but I'm not able to search by date or by id.

The database I use is Postgres, I'm using Laravel 5.2 framework

public function scopeSearchByKeyword($query, $keyword)
{
   if ($keyword!='') {

        $query->where(function ($query) use ($keyword) {
            $query->where("nome_problema", "LIKE", "%$keyword%")
                  ->orWhere("id", "LIKE", "%$keyword")
                  ->orWhere("data_criacao", "LIKE", "%$keyword");
        });
    }
    return $query;
}

php busca laravel

asked by anonymous 08.11.2016 / 02:07

1 answer

Google Calendar Api Save data associated with CakePHP 3

score 0 · Answer 1

The "where" method appears to have been spelled wrong, try this:

public function scopeSearchByKeyword($query, $keyword)
{
   if ($keyword!='') {

        $query->where(function ($query) use ($keyword) {
            $query->where("nome_problema", "LIKE", "%" .$keyword. "%")
                  ->orWhere("id", "LIKE", "%" .$keyword. "%")
                  ->orWhere("data_criacao", "LIKE", "%" .$keyword. "%");
        });
    }
    return $query;
}