“; } [/insert_php]
“; $q = ‘”%’ . stripslashes(htmlspecialchars($_GET[“q”])) . ‘%”‘; $stmt = $db->query(” SELECT SONGTITLE, TIMESTAMP FROM History WHERE SONGTITLE LIKE $q ORDER BY id DESC LIMIT 3″); if ($stmt->rowCount() == 3) { echo “Found more then 3 results, limited to 3.
“; } else { echo “Found “. $stmt->rowCount() . ” results.
“; } while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $songtitle = $row[‘SONGTITLE’]; $timestamp = $row[‘TIMESTAMP’]; echo $songtitle . ” played at ” . str_replace(“+0100”, “”, date(‘r’, $timestamp)); echo “
“; } } else { $stmt = $db->query(“SELECT SONGTITLE,TIMESTAMP,VoteRating,ID FROM History ORDER BY id DESC LIMIT $load”); while($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $song = $row[‘SONGTITLE’]; $timestamp = $row[‘TIMESTAMP’]; $voterating = $row[‘VoteRating’]; $id = $row[‘ID’]; if ($voterating > 0) { echo “
“;
}
if ($voterating == 0) {
echo “
“;
}
if ($voterating < 0) {
echo "
“;
}
echo “
“;}}
$time = microtime();
$time = explode(‘ ‘, $time);
$time = $time[1] + $time[0];
$finish = $time;
$total_time = round(($finish – $start), 4);
echo ‘” . $song . “
“; echo “started playing at ” . date(‘H:i’, $timestamp) . ” (GMT) , current rating $voterating
“; /*echo ““;*/ echo ““;
echo “ | “;
/*echo ““;*/
echo “
“;
echo “Page generated in ‘.$total_time.’ seconds.
‘;
[/insert_php]