我有以下用于显示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);我想要的结果是程序将显示从日期到日期的数据:$tgak
发布于 2020-01-24 12:11:27
在这里,您应该使用预准备语句,并使用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();https://stackoverflow.com/questions/59890227
复制相似问题