$passeddate=$_GET["date"];
if ($passeddate !="")
{
$date=$passeddate;
}
$passedtime=$_GET["time"];
if ($passedtime !="")
{
$time=$passedtime;
}
// Create connection
$conn = new mysqli(DBSERVER, DBUSER, DBPASSWD, DBNAME);
// Check connection
if ($conn->connect_error)
{
die("Connection failed: " . $conn->connect_error);
}
echo "Choose a date
";
?>
Heritage services have been confirmed for these dates:
$sql = "SELECT * FROM timetable where date >= \"".$date."\" order by date";
$result = $conn->query($sql);
if ($result->num_rows > 0)
{
while($row = $result->fetch_assoc())
{
$tt_longname=$row["timetable_name"];
echo "- ".$row["date"]." - " .$row["timetable_name"]."
";
}
}
?>
require("footer.php");
?>