ต้องการค้นหาแบบ date rang และ keywords พร้อมกันช่วยแนะนำหน่อยครับ

<?php
	ini_set('display_errors', 1);
	error_reporting(~0);

	$key = null;

	if(isset($_POST["txtKeyword"]))
	{
		$key = $_POST["txtKeyword"];
	}

    isset( $_POST['date1'] ) ? $date1 = $_POST['date1'] : $date1 = "";
    isset( $_POST['date2'] ) ? $date2 = $_POST['date2'] : $date2 = "";
    

?>
<form name="frmSearch" method="post" action="<?php echo $_SERVER['SCRIPT_NAME'];?>">
  <table width="500" border="0">
    
    <tr>
    <b>วันที่</b>
    <input type="date" name="date1"> 
    <b>ถึง</b>
    <input type="date" name="date2">
      <th>Keyword
      <input name="txtKeyword" type="text" id="txtKeyword" value="<?php echo $key;?>">
      <input type="submit" value="Search"></th>
    </tr>
  </table>
</form>

<?php

   $serverName = "localhost";
   $userName = "root";
   $userPassword = "";
   $dbName = "workshop_pdo";

   $conn = mysqli_connect($serverName,$userName,$userPassword,$dbName);
	
   $sql = "SELECT * FROM tbl_order WHERE product_name LIKE '%".$key."%' AND order_date BETWEEN '{$date1}' AND '{$date2}'";

   $query = mysqli_query($conn,$sql);

?>
<table width="600" border="1">
  <tr>
    <th width="91"> <div align="center">NO</div></th>
    <th width="98"> <div align="center">product_name </div></th>
    <th width="198"> <div align="center">PRICE </div></th>
    <th width="97"> <div align="center">ODERDATE </div></th>
    
  </tr>
<?php
while($result=mysqli_fetch_array($query,MYSQLI_ASSOC))
{
?>
  <tr>
    <td><div align="center"><?php echo $result["no"];?></div></td>
    <td><?php echo $result["product_name"];?></td>
    <td><?php echo $result["price_total"];?></td>
    <td><div align="center"><?php echo $result["order_date"];?></div></td>
    <
  </tr>
<?php
}
?>
</table>
<?php
mysqli_close($conn);
?>