这是我的代码，我想添加日期选择器事件，它根据日期给出特定的记录

this is my code in this i want to add date-picker event which gives particular record according to date

本文关键字：日期记录选择器代码我的添加事件 | 更新日期: 2023-09-27

我不知道如何在这里添加问题？也请在这方面帮助我。。

$sql = ("SELECT final_report.customer_id,customer.Customer_name,customer.Customer_email,customer.Customer_address,customer.Customer_phone_num,final_report.Product_id,final_report.total_units,final_report.total_price,final_report.Date
FROM final_report 
INNER JOIN customer
ON customer.Customer_id = final_report.customer_id LIMIT $start_from, $per_page")or die(mysql_error());

像这样使用BETWEEN：-

where final_report.Date BETWEEN 'date1' and 'date2'

where final_report.Date='date'