如何显示 2 个不同日期范围的数据

Question

我有以下数据，用于显示MySQL数据参数date$tgaw=date("Y-m-10");$tgak=date("Y-m-09", strtotime("+1 months"));我有以下查询：$querylembur = "SELECT SUM(total) as subtotal FROM lembur WHERE tgl between ".$tgaw." AND ".$tgak." AND staff =".$row['nama'];$rslembur=mysqli_query($con,$querylembur);$rowlembur=mysqli_fetch_array($rslembur);我想要的结果是程序将显示从日期到现在的数据：:$tgaw$tgak

Answer 1

您应该在此处使用预准备语句，并且还使用MySQL函数将一个月添加到该范围内的上限日期。

$sql = "SELECT SUM(total) AS subtotal FROM lembur WHERE tgl BETWEEN ? AND DATE_ADD(?, INTERVAL 1 MONTH) AND staff = ?";

$stmt = $mysqli->prepare($sql);

$stmt->bind_param("sss", $tgaw, $tgaw, $row['nama']);

$stmt->execute();

// fetch here

$stmt->close();