function lastUser()
{
$db = new DBHandler();
$stmt = $db->query("SELECT u.id, u.username, u.email, u.publicEmail, u.active FROM `user` u order by id DESC limit 5;");
$data = "";
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$data = $data . $row[0] . "," . $row[1] . "," . $row[2] . "," . $row[3] . "," . $row[4] . ";";
}
$stmt->closeCursor();
echo $data;
}
$db = new DBHandler();
$stmt = $db->query("SELECT s.title, u.username, r.grade, r.date\r\n\t\t\t\t\t\tFROM song s, user u, rate r\r\n\t\t\t\t\t\tWHERE r.song = s.id\r\n\t\t\t\t\t\tAND r.user = u.id\r\n\t\t\t\t\t\tORDER BY r.date DESC \r\n\t\t\t\t\t\tLIMIT 0 , 30");
$data = "";
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$data = $data . $row[0] . "," . $row[1] . "," . $row[2] . ",";
$tstamp = new Timestamp($row[3]);
$date = $tstamp->format("y-m-d");
$data = $data . $date . ";";
}
$stmt->closeCursor();
$data = convertToUTF8($data);
echo $data;
}
if (isset($_GET['action']) && $_GET['action'] == 'comment') {
$db = new DBHandler();
$stmt = $db->query("SELECT s.title, u.username, c.text, c.date,c.user,c.song\r\n\t\t\t\t\t\tFROM song s, user u, comment c\r\n\t\t\t\t\t\tWHERE c.song = s.id\r\n\t\t\t\t\t\tAND c.user = u.id\r\n\t\t\t\t\t\tORDER BY c.date DESC \r\n\t\t\t\t\t\tLIMIT 0 , 30");
$data = "";
while ($row = $stmt->fetch(PDO::FETCH_NUM)) {
$data = $data . $row[0] . "," . $row[1] . "," . $row[2] . ",";
$tstamp = new Timestamp($row[3]);
$date = $tstamp->format("y-m-d");
$data = $data . $date . "," . $row[4] . "," . $row[5] . ";";
}
$stmt->closeCursor();
$data = convertToUTF8($data);
echo $data;
}
//partie suppression
if (isset($_GET['action']) && $_GET['action'] == 1) {
$notarizealbum = new Notarizealbum($_GET['user'], $_GET['id']);
$notarizealbum->delete($_GET['user'], $_GET['id']);
