如何在PHP中传递sql变量 - How to pass variable in sql in PHP?

How to pass variable in sql in PHP?

本文关键字：sql 变量 PHP | 更新日期: 2023-09-27

我使用这个SQL查询来获取时间间隔

之间的数据

$start_time = $_POST['i_date'].' 07:00:00';
$end_time = $_POST['i_date'].' 14:00:00';
/*echo $start_time;
die();*/
$sql = 'select * from datetime where code = 1001 and time between '.$start_time.' and '.$end_time;

，但我得到以下错误信息:无效查询:您的SQL语法有错误;查看对应MySQL服务器版本的手册，在第1行

的'07:00:00 and 2015-09-09 14:00:00'附近使用正确的语法。

您的查询有错误，试试这个

$sql = "select * from datetime where code = 1001 and time between '".$start_time."' and '".$end_time."'";

你必须把分号放在你传递的字符串里面:

$sql = 'select * from datetime where code = 1001 and time between '.$start_time.' and '.$end_time. ';';

将它们用单引号绑定:

$sql = "select * from datetime where 
code = 1001 and time between 
'$start_time' and '$end_time'";