Example #1
0
    $stmt = $db->prepare("select id from artist where name like convert(_utf8 ? using utf8) collate utf8_general_ci order by name;");
    $stmt->execute(array('%' . $q . '%'));
    while ($search_artists_result = $stmt->fetch(PDO::FETCH_NUM)) {
        $search_artists[] = new Artist($search_artists_result[0]);
    }
    $stmt->closeCursor();
    # Users
    $stmt = $db->prepare("select id from user where username like convert(_utf8 ? using utf8) collate utf8_general_ci order by username;");
    $stmt->execute(array('%' . $q . '%'));
    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 
 *
Example #2
0
<?php

require_once "config/config.inc";
$song = Song::random();
Page::goSong($song[0]->getId());