[RESOLVED] Selecting Date Range

[obrienkev]

Hi all,

What would be the best way to provide a date range on a webpage.

The user will select from the date range and results will be drawn form the database based on the selection.

Thanks.

Kevin.

[devinemke]

a simple example:

<?php
if (!isset($_POST['submit']))
{
	echo '
	<form action="" method="POST">
	start date: <input type="text" name="dates[start]"><br>
	end date: <input type="text" name="dates[end]"><br>
	<input type="submit" name="submit" value="submit">
	</form>
	';
}
else
{
	foreach ($_POST['dates'] as $key => $value)
	{
		if (!$value) {exit('missing date(s)');}
		$timestamp = strtotime($value) or exit('invalid date(s)');
		$dates[$key]['date'] = date('Y-m-d', $timestamp);
		$dates[$key]['timestamp'] = $timestamp;
	}
	if ($dates['start']['timestamp'] > $dates['end']['timestamp']) {exit('start date must be earlier than end date');}
	$sql = "SELECT * FROM table WHERE date BETWEEN '" . $dates['start']['date'] . "' AND '" . $dates['end']['date'] . "'";
	echo $sql;
}
?>

[obrienkev]

Create two input fields then process...

$start_date = $_GET['start_date'];
$end_date = $_GET['end_date'];
$location = $_GET['location'];

// Connect to DB
include('../../db_connect.php');

// Perform Query
$query = "SELECT * ".
			 	 "FROM class AS cl ".
				 "INNER JOIN ".
				 "course AS c ".
				 "ON cl.course_ID = c.course_ID ".
				 "INNER JOIN ".
				 "location AS l ".
				 "ON cl.location_ID = l.location_ID ".
				 "INNER JOIN ".
				 "instructor AS i ".
				 "ON cl.instructor_ID = i.instructor_ID ".
			 	 "WHERE cl.class_date BETWEEN '$start_date' AND '$end_date' ".
				 "AND cl.location_ID = '$location' ".
				 "ORDER BY class_date ".
				 "DESC";