如何获取用户从类似的html表单输入的日期(from-dates & to_dates )之间的所有数据。当用户输入日期类似,从(1\1\2019)到(30\1\2019)时,我希望在MySQL表中检查这两个日期之间的日期。
我试过:
$from = $_POST['from'];
$end = $_POST['end '];
$sql = "SELECT * FROM table_name WHERE '" . $from . "' between
from_date and to_date and '" . $end . "' between from_date and
to_date
"; mysql表中的from_date和to_date...col
发布于 2019-01-16 09:04:31
这里,但是您应该使用格式化$from和$end来更正格式
"SELECT * FROM table_name WHERE (date_column_name BETWEEN '" . $from . "' AND '" . $end . "') AND (date_column_name2 BETWEEN '" . $from . "' AND '" . $end . "')"其中,date_column_name是您要选择的表,而table_name是您的日期列。
发布于 2019-01-16 09:10:59
尝尝这个,
$from = $_POST['from'];
$end = $_POST['end '];
$sql = "SELECT * FROM table_name WHERE date_column1 >= '" . $from . "' AND date_column2 <= '" . $end . "' "; 发布于 2019-01-16 09:15:59
首先,您需要将输入日期转换为数据库日期格式yyyy dd。
$from = date('Y-m-d',strtotime($_POST['from']));
$end = date('Y-m-d',strtotime($_POST['end ']));
$sql = "SELECT * FROM table_name WHERE (date_column_name1 BETWEEN '" . $from . "' AND '" . $end . "') AND (date_column_name2 BETWEEN '" . $from . "' AND '" . $end . "')"; 或
$sql = "SELECT * FROM table_name WHERE (from_date_column >='" . $from . "' AND to_date_column <='" . $end . "')"; https://stackoverflow.com/questions/54213456
复制相似问题