$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
*
<?php require_once "config/config.inc"; $song = Song::random(); Page::goSong($song[0]->getId());