我在理论上使用了原始的SQL。我的SQL:
//input datetime type for $dateStart,$dateEnd
$start = date_format( $dateStart,'Y-m-d');
$end = date_format( $dateEnd,'Y-m-d');
$sql = '
SELECT
*
FROM
log
WHERE
time >= "? 00:00:00"
AND
time <= "? 23:59:59"
';
$pdo = $this->em->getConnection();
$stmt = $pdo->prepare($sql);
$stmt->bindValue(1,$start);
$stmt->bindValue(2,$end);
$stmt->execute();
$rs = $stmt->fetchAll();
我试过bindValue,bindParam,但是没有希望。我还尝试将$param
作为数组传递给execute
,但没有起作用。
$param = array($start,$end);
有人能帮帮我吗?
https://stackoverflow.com/questions/41241750
复制相似问题