function get_comment()
{
global $html;
$array_result = get_array_comment();
if (count($array_result) > 0) {
$html = "<table><tr><th>Commentaire</th><th>Auteur</th><th>Valider</th>";
foreach ($array_result as $value) {
$user = get_User_by_id($value['idUser']);
$html .= "<tr><td>" . $value['content'] . "</td>";
$html .= "<td>" . $user['pseudo'] . "</td>";
$html .= "<td><a href=\"administration.php?validComment=" . $value['idComment'] . "\">Oui</a>/<a href=\"administration.php?deleteComment=" . $value['idComment'] . "\">Non</a></td>";
$html .= "</tr>";
}
} else {
$html = "<h1>Pas de commentaire à valider";
}
$html .= "</table><br/>";
}
function get_comment()
{
$idArtist = get_idArtist_by_name($_REQUEST['name']);
$tab = get_array_comment_artist($idArtist['idArtist']);
if (count($tab) > 0) {
$string = "<table><th>Auteur</th><th>Contenu</th><th>Date</th>";
foreach ($tab as $value) {
$string .= "<tr><td>" . get_User_by_id($value['idUser'])['pseudo'] . "</td>";
$string .= "<td>" . $value['content'] . "</td>";
$date = $value['dateCommentaire'];
$date_format = date("d-m-Y", strtotime($date));
//Conversion de année-mois-jour en jour-mois-année (en chiffre)
$string .= "<td>" . $date_format . "</td></tr>";
}
$string .= "</table>";
return $string;
} else {
return "<h1>Pas de commentaire pour le moment</h1>";
}
}
