<?php session_start(); $user = new User(); if ($user->selectByEmail(Database::sessionDecrypt($_SESSION['user']))) { Logger::log('ListTrips', $user->getEmail()); $query = 'SELECT tripId, name FROM trip WHERE userId = ?'; $db = Database::getDbInstance(); $trips = $db->queryFromPreparedStatement($query, array($user->getUserId()), true); foreach ($trips as $trip) { echo '*' . $trip['tripId'] . ':' . $trip['name'] . PHP_EOL; } $query = 'SELECT t.tripId, t.name FROM participant p, trip t WHERE p.tripId = t.tripId and p.userId = ?'; $trips = $db->queryFromPreparedStatement($query, array($user->getUserId()), true); foreach ($trips as $trip) { echo $trip['tripId'] . ':' . $trip['name'] . PHP_EOL; } } else { Logger::log('ListTrips', 'User not found'); echo ReturnCode::$userNotFound; }
<?php session_start(); $user = new User(); if ($user->selectByEmail(Database::sessionDecrypt($_SESSION['user']))) { $query = 'SELECT userId, nickname, name, surname, email FROM user WHERE (userId NOT IN ( SELECT userId FROM participant WHERE tripId = ? ) AND userId != ?) AND (nickname LIKE ? OR name LIKE ? OR surname LIKE ?);'; $key = '%' . $_POST['key'] . '%'; // Logger::var_dump_log('SearchUser', $_POST); echo json_encode(Database::getDbInstance()->queryFromPreparedStatement($query, array($_POST['tripId'], $user->getUserId(), $key, $key, $key), true)); } else { echo ReturnCode::$userNotFound; }
public function __construct() { $this->database = Database::getDbInstance(); }