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>