問題描述
MySQL 列 > sdate、edate(它的第 2 列).
MySQL column > sdate, edate ( its 2 column).
sdate 是項目開始的開始日期，edate 是項目結束的結束日期.
sdate is start date for project starting and edate is end date for project ending.
所以我需要在他們之間進行搜索..
so i need to make search between them..
<strong>Search</strong><br />
<form method="post" action="search.php">
Start Report Date : <input type="text" name="sdate" />
End Report Date : <input type="text" name="edate" />
<input type="submit" name="Submit" value="Search" />
</form>
This is example data in mysql
sdate Project Name edate
22 December 2008 project 1 23 December 2008
25 December 2008 project 2 26 December 2008
24 December 2008 project 3 27 December 2008
1 January 2008 project 4 20 January 2008
10 December 2008 project 5 12 December 2008
假設用戶輸入了 sdate(例如，2008 年 12 月 22 日)和 edate(例如，2008 年 12 月 30 日).
so let say a user entered sdate ( eg, 22 December 2008 ) and edate ( eg, 30 December 2008 ).
它應該顯示
22 December 2008 project 1 23 December 2008
25 December 2008 project 2 26 December 2008
24 December 2008 project 3 27 December 2008
所以我需要一個 php 代碼 sql 查詢，它應該顯示這兩個日期之間的條目..
So i need a php code sql query which should display entries lies between those 2 dates..
請幫幫我..
非常感謝..
推薦答案
假設你的 sdate 和 edate 是 MySQL 列類型 DATE您可以執行以下操作:
assuming that your sdate and edate are of MySQL columns type DATE you could do the following:
SELECT
Project_Name
, sdate
, edate
FROM your_table
WHERE
sdate <= '2008-12-26'
AND
edate >= '2008-12-26'
或者你可以使用 DATEDIFF
or you could use DATEDIFF
SELECT
Project_Name
, sdate
, edate
FROM your_table
WHERE
DATEDIFF(sdate, '2008-12-26') <= 0
AND
DATEDIFF(edate, '2008-12-26') >= 0
第一個更有效，因為 MySQL 可以將表中的所有行與靜態值進行比較.對于第二種解決方案，它需要計算表格中每一行的差異.
The first one is more efficient because MySQL can compare all the rows in your table to a static value. For the second solution it needs to calculate the difference for every row in your table.
如果您的 sdate 和 edate 列不是 DATE 列，那么您就不走運了，需要先更改它們.
If your sdate and edate columns are not DATE columns, you are out of luck and need to change them first.
這篇關于PHP中的2列Mysql日期范圍搜索的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！