从html表单查询pgsql日期范围

<form action="query.php" method="GET">
  <label for="start_date">起始日期:</label>
  <input type="date" id="start_date" name="start_date">
  <br>
  <label for="end_date">结束日期:</label>
  <input type="date" id="end_date" name="end_date">
  <br>
  <input type="submit" value="查询">
</form>

<?php
$start_date = $_GET['start_date'];
$end_date = $_GET['end_date'];

// 进行查询操作，使用$start_date和$end_date构建查询语句

// 示例查询语句
$query = "SELECT * FROM table_name WHERE date_column BETWEEN '$start_date' AND '$end_date'";

// 执行查询操作并处理结果

// 输出查询结果
?>