How to implement multi-value search in php?

Question

Laravel

The search form has several lines, something like this
id, name, description, date
. For example, I want to search by these parameters. I am getting parameters. And sql looks like this.

select * from `table` where `id` = ? and `name` = ?  and `description` = ?  and `date` = ?

Here, but if there is an empty value in id, then how can you make sql look like this, in short, do not search with empty data.

select * from `table` where  `name` = ?  and `description` = ?  and `date` = ?

How is this done in general, what practices are used? I can simply write value="do not search" in the input,
and process everything with

if($id='не искать'){
select * from `table` where  `name` = ?  and `description` = ?  and `date` = ?
}

Is this the same way, or is there a better practice? I do this in Laravel, but I think the philosophy of the solution is the same in the code, or is there another solution in laravel?

Answer 1

The best practice is described in the documentation .