如何使用按日期范围的动态 mysql 查询从数据库中获取数据

Question

如何在此动态查询中使用日期范围函数从数据库中获取数据，例如从日期到日期从数据库中获取数据。

unset($sql);

    if ($stationFilter) {

        $sql[] = " STATION_NETWORK = '$stationFilter' ";

    }

    if ($verticalFilter) {

        $sql[] = " VERTICAL = '$verticalFilter' ";

    }

    $query = "SELECT * FROM $tableName";

    if (!empty($sql)) {

        $query .= ' WHERE ' . implode(' AND ', $sql);

    }

    echo $query;

Answer 1

尝试以下查询以获取范围之间的日期：SELECT&nbsp;&nbsp;*&nbsp;FROM&nbsp;&nbsp;&nbsp;&nbsp;tableName&nbsp;WHERE&nbsp;&nbsp;&nbsp;From_date&nbsp;>=&nbsp;'2019-01-03'&nbsp;AND&nbsp;&nbsp;To_date&nbsp;&nbsp;&nbsp;<=&nbsp;'2016-01-09'添加和条件后$query&nbsp;.=&nbsp;'&nbsp;WHERE&nbsp;'&nbsp;.&nbsp;implode('&nbsp;AND&nbsp;',&nbsp;$sql).&nbsp;'AND&nbsp;From_date&nbsp;>=&nbsp;'2019-01-03'&nbsp;AND &nbsp;&nbsp;&nbsp;&nbsp;To_date&nbsp;&nbsp;&nbsp;<=&nbsp;'2016-01-09'';

Answer 2

你可以像下面的代码那样做unset($sql);if ($stationFilter) {&nbsp; &nbsp; $sql[] = " STATION_NETWORK = '$stationFilter' ";}if ($verticalFilter) {&nbsp; &nbsp; $sql[] = " VERTICAL = '$verticalFilter' ";}if (isset($start_date) && isset($end_date)) {&nbsp; &nbsp; $sql[] = " created_at between '".$start_date."' and '".$end_date."'";}$query = "SELECT * FROM $tableName";if (!empty($sql)) {&nbsp; &nbsp; $query .= ' WHERE ' . implode(' AND ', $sql);}echo $query;希望它会帮助你。