asked on Query MySQL Date Range Via PHP
Hi,
I have a StartDate & EndDate column in the table products my DB
I have a Search Filter on my PHP website which has a Date picker called dpStartDate & dpEndDate.
I need to query my MySQL DB to select records that have
StartDate = or > than dpStartDate
AND
EndDate < or = dpEndDate
I need the PHP code to get the values from the Datepicker Textboxes, Parse the date to the correct format and then create the query based on the values.
Thanks so much!
I have a StartDate & EndDate column in the table products my DB
I have a Search Filter on my PHP website which has a Date picker called dpStartDate & dpEndDate.
I need to query my MySQL DB to select records that have
StartDate = or > than dpStartDate
AND
EndDate < or = dpEndDate
I need the PHP code to get the values from the Datepicker Textboxes, Parse the date to the correct format and then create the query based on the values.
Thanks so much!
PHPMySQL Server
Last Comment
Ray Paseur
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Here is a better explaination:
$myStartDate = date('c', strtotime($_REQUEST["dpSta
$myEndDate = date('c', strtotime($_REQUEST["dpEnd
$query = "SELECT product_id FROM jos_vm_product_type_1 WHERE ( start_date BETWEEN '$myStartDate' AND '$myEndDate' ) AND ( end_date BETWEEN '$myStartDate' AND '$myEndDate' )";
Execute the $query
Loop through returned $query records
$query2 = "SELECT distinct parent_product_id from jos_vm_product WHERE product_id = '$query->productid'";
End Loop
RETURN parent_product_id ARRAY
$myStartDate = date('c', strtotime($_REQUEST["dpSta
$myEndDate = date('c', strtotime($_REQUEST["dpEnd
$query = "SELECT product_id FROM jos_vm_product_type_1 WHERE ( start_date BETWEEN '$myStartDate' AND '$myEndDate' ) AND ( end_date BETWEEN '$myStartDate' AND '$myEndDate' )";
Execute the $query
Loop through returned $query records
$query2 = "SELECT distinct parent_product_id from jos_vm_product WHERE product_id = '$query->productid'";
End Loop
RETURN parent_product_id ARRAY
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Thanks for the points. Since this question was written, there is a new edition of the book, available here:
http://www.sitepoint.com/books/phpmysql5/
http://www.sitepoint.com/books/phpmysql5/
>= and <=
EG:
SELECT product_id FROM jos_vm_product_type_1
WHERE start_date >= '$DEPARTONORAFTER'
AND end_date <= '$RETURNBY'
How would multiple record values be selected from the above query ?
How would i loop through these results in PHP ?
Basically running the below query nested in the loop returning only the DISTINC "parent_prodcut_id" ?
Loop through SelectedValues until EOF
SELECT parent_product_id
from jos_vm_product
WHERE product_id = $CHILDPRODUCTID
end loop
RETURN Distinct "parent_product_id"