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']);