Example #1
0
    while ($search_users_result = $stmt->fetch(PDO::FETCH_NUM)) {
        $search_users[] = new User($search_users_result[0]);
    }
    $stmt->closeCursor();
    if (count($search_songs) + count($search_albums) + count($search_artists) + count($search_users) === 1) {
        if (count($search_songs) == 1) {
            Page::goSong($search_songs[0]->getId());
        }
        if (count($search_artists) == 1) {
            Page::goArtist($search_artists[0]->getId());
        }
        if (count($search_albums) == 1) {
            Page::goAlbum($search_albums[0]->getId());
        }
        if (count($search_users) == 1) {
            Page::goUser($search_users[0]->getId());
        }
    }
}
/**
 * @author Jérôme Boesch 
 *
 */
if (isset($_POST['text']) && isset($_POST['reason']) && !empty($_POST['text']) && isset($_SESSION['online']) && $_SESSION['online'] && is_numeric($_POST['reason']) && Reason::exists($_POST['reason'])) {
    $db = $_SESSION['db'];
    $user = $_SESSION['user']->getId();
    $reason = $_POST['reason'];
    $text = $_POST['text'];
    $stmt = $db->prepare("insert into message (user, text, date, reason) values (:user, :text, unix_timestamp(), :reason);");
    $stmt->execute(array(':user' => $user, ':text' => $text, ':reason' => $reason));
    $stmt->closeCursor();