如何在php中使用from和to日期来搜索数据

获取日期列并使用Post函数通过用户选择获取DateFrom和DateTo

Select * From Table1 Where DateTo='".$_POST['DateTo']."' AND DateTo <='".$_POST['DateFrom']."'

您可以使用"between"

SELECT data FROM tbl WHERE date BETWEEN date1 AND date2 

既然你的表中有两列，正如你提到的你的评论，你可以有类似的东西：

编辑：

$fromDate = $_POST['fromDate'];
$toDate = $_POST['toDate'];
...


$dateSql = "Select field1, field2 from someTable where fromdate >= $fromDate ";
if (isset($toDate)) {
    $dateSql = " AND todate <= $toDate";

}

//执行$dateSql以获取记录