php - PHP 脚本中的 MySQL 语法错误

Question

我在 MySQL 中有一个查询运行良好，但是当我将查询复制到我的 PHP 文件中时，它抛出一个语法错误:** unexpected ") as week_ending ** what我不见了吗？

MySQL:

'SELECT COUNT(*) as count,region, DATE_FORMAT(NOW(),'%d %b %y') as week_ending FROM stores.stats WHERE date > DATE_ADD(DATE(NOW()), INTERVAL -1 WEEK) AND date < DATE(NOW()) GROUP BY region, DATE(NOW())';

PHP:

$stmt = DB::query(Database::SELECT, 'SELECT COUNT(*) as count,region, DATE_FORMAT(NOW(),'%d %b %y'), as week_ending FROM stores.stats WHERE date > DATE_ADD(DATE(NOW()), INTERVAL -1 WEEK) AND date < DATE(NOW()) GROUP BY region, DATE(NOW())';

Answer 1

您的 SQL 中间有几个单引号会提前终止您的请求。您只需要转义附近的引号:

DATE_FORMAT(NOW(),'%d %b %y'),

像这样:

DATE_FORMAT(NOW(),\'%d %b %y\'),