php - 查询中的时间戳问题

Question

我有这段代码，我用它来将时间戳字段与我之前选择的日期进行比较!但我收到语法错误..怎么会这样？

$query = sprintf( 'SELECT * FROM coupon WHERE date("Y-m-d", "time") = $date' );

错误是:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' "time") = $date' at line 1

同时，我正在比较时间戳(即字段时间)和日期($date)提前致谢..

Answer 1

time 不应加引号，因为它是字段引用，而不是 string literal .

$query = sprintf('SELECT * FROM coupon WHERE DATE(time) = $date');

注意:您很容易受到 SQL Injection 的影响。 .