<?php
$com = mysqli_connect("localhost", "123" , "123!" , "123" );
$start = '2018/5/1';
$end = '2018/5/30';
$statement = mysqli_prepare($com, "select * from CARJOIN where DATE(startDay)>= '?' and DATE(startDay)<= '?' ORDER BY startDay DESC ");
mysqli_stmt_bind_param($statement, "ss" , $start , $end);
mysqli_stmt_execute($statement);
mysqli_stmt_store_result($statement);
$response = array();
while($row = mysqli_fetch_array($statement)){
array_push($response, array("id"=>$row[0], "carNum"=>$row[1], "startPlace"=>$row[2], "endPlace"=>$row[3]
,"startTime"=>$row[4], "startDay"=>$row[5], "endTime"=>$row[6], "endDay"=>$row[7], "no"=>$row[8], "kilometer"=>$row[9] )
);
}
echo json_encode(array("response"=>$response));
mysqli_close($com);
?>
It's a code that searches all the values between the specified periods, but nothing comes out...
Which part is wrong?ㅜ<
php mysql
select * from CARJOIN where DATE(startDay)>= '?' and DATE(startDay)<= '?' ORDER BY startDay DESC
I don't know if it's because startDay
comes out twice. According to this query, you need to get something that is greater than or equal to the start date and less than or equal to the start date.
626 Uncaught (inpromise) Error on Electron: An object could not be cloned
577 Who developed the "avformat-59.dll" that comes with FFmpeg?
925 When building Fast API+Uvicorn environment with PyInstaller, console=False results in an error
618 GDB gets version error when attempting to debug with the Presense SDK (IDE)
© 2024 OneMinuteCode. All rights reserved.