Example #1
0
<?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;
}
Example #2
0
<?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;
}
Example #3
0
 public function __construct()
 {
     $this->database = Database::getDbInstance();
 }