public function getUsername()
{
$query = "SELECT * FROM usernames WHERE username = '******'username'] . "'";
$dbAccess = new DBAccess();
$select = $dbAccess->select($query);
return $select;
}
public function getUserfullname($username, $password)
{
session_start();
$query = "SELECT * FROM usernames WHERE username = '******' AND Password = '******'";
$dbAccess = new DBAccess();
$select = $dbAccess->select($query);
return $select;
}
public function getDestinationCities()
{
$destinationCities = array();
$query = 'SELECT DISTINCT destino FROM rutas';
$dbAccess = new DBAccess();
$select = $dbAccess->select($query);
return $select;
}
} else {
if (isset($post['source'])) {
$_SESSION['source'] = $post['source'];
$_SESSION['destination'] = $post['destination'];
$_SESSION['date'] = $post['date'];
}
}
$source = $_SESSION['source'];
$destination = $_SESSION['destination'];
$date = $_SESSION['date'];
if (date('w', strtotime($date)) == 6 || date('w', strtotime($date)) == 0) {
$query = "SELECT * FROM rutas where origen = '{$source}' and destino = '{$destination}' and weekend = 1";
} else {
$query = "SELECT * FROM rutas where origen = '{$source}' and destino = '{$destination}' and weekday = 1";
}
$results = $access->select($query);
$date = new DateTime();
$date = $date->format('Y-m-d');
if (isset($_SESSION['loggedin'])) {
$login = true;
} else {
$login = false;
}
if ($_SESSION['wrongInfo'] == true) {
$wrongInfo = true;
} else {
$wrongInfo = false;
}
?>
<!DOCTYPE html>
<html>
