php - 如何使用 php 准备语句在 mysql 中选择日期范围

Question

我正在使用以下准备好的语句来选择确切的日期并且它工作正常:

if($stmt = $mysqli->prepare("SELECT x FROM y WHERE mydate=?"))
{
$stmt->bind_param("s", $ReportDatetDate);
$stmt->execute();
$stmt->bind_result($xx);
while ($stmt->fetch()) 
{
echo ($xx)
}
$stmt->close();
}
else{
$mysqli->close();    
}

我需要选择 Startdate 和 enddate 之间的日期范围，但我无法编写正确的选择查询 .. 如下 .. 如何编写正确的查询？

if($stmt = $mysqli->prepare("SELECT x FROM y WHERE mydate between ? AND ?"))
{
$stmt->bind_param("ss", $ReportStartDate, $reportEndDate);
$stmt->execute();
$stmt->bind_result($xx);
while ($stmt->fetch()) 
{
echo ($xx)
}
$stmt->close();
}
else{
$mysqli->close();    
}

Answer 1

像这样绑定(bind)参数:

$sql = "SELECT x FROM y WHERE mydate between :from_date AND :to_date";
$stmt = $db_pdo->prepare($sql);
$stmt->execute(Array(':from_date' => $from_date, ':to_date' => $to_date));
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);