php大于等于符号怎么打出来,PHP mysqli条件大于或小于符号错误

I am getting the following strange issue in mysqli prepared statement

This is my sample query and params

SELECT * from ecf_request WHERE id > ? OR id < ?

...

$stmt->bind_param("ii", $id, $id1); //5, 10

When i use just = conditions it's working fine but for > and < conditions it's not working.

I am getting "Number of variables doesn't match number of parameters in prepared statement" error

Is it possible to use greater than and less than symbols in prepared statements ?

I need to implement it for date filter condition. records between two dates.

Thanks in advance

解决方案

one id cannot be greater and smaller to itself at the same time.

you are giving a condition like id >10 and id <10 at the same time.

If you want both id1 and id2 to be selected use SELECT * from ecf_request WHERE id IN(?,?) instead of AND and if you want to select everything in between then use SELECT * from ecf_request WHERE id BETWEEN ? AND ?