/** * * @param article $id */ function viewArticle($id) { $mysqli = connectBD(); $query = "SELECT * FROM posts WHERE id = {$id}"; if ($result = $mysqli->query($query)) { $obj = $result->fetch_object(); return $obj; } else { return null; } }
<body> <!--<h1 id="tiha"><span id="f">F</span><span id="a1">A</span><span id="t">T</span><span id="i">I</span><span id="h">H</span><span id="a">A</span></h1>--> <div id="content"> <form id="laisserCom" name="laisserCom" method="POST" action="comments.php"><input type="submit" value="Laisser un commentaire?" ></form> <!--test commentaires --> <div id="affichage"> <h1 id="orTitle" >LIVRE D'OR</h1> <?php //création de la variable contenu, initialement vide $contenu = ''; //on se connecte $connection = connectBD(); if ($connection) { //on prépare la requête de selection, on l'organise par ordre de date $req = 'SELECT * FROM comments INNER JOIN clients ON comments.user_id = clients.id ORDER BY datecomments DESC'; //$req='SELECT * FROM comments ORDER BY datecomments DESC'; //on insere dans la variable results la requête $results = $connection->query($req); //si on trouve un résultat. Si la recherche est plus grande que 0 if ($results->rowCount() > 0) { //boucle pour récupérer les données foreach ($results as $key) { //on affiche les COMMENTAIRES //($key['facturationData']=='' ? '<white>Pas de facture disponible</white>' : '<white><b><a href="'.$key['facturationData'].'"> <green>Cliquez pour voir Votre Facture</green></a></b></white>') //($_SESSION['client'] == 1 ? '<or><b>'.$key['user_pseudo'].'</b></or>' : '<b><red>'.$key['user_pseudo'].'</b></red></br>') echo ' <div id="affichCom"><red>' . ($key['client'] == 1 ? '<or><b>' . $key['user_pseudo'] . '</b></or>' : '<red><b>' . $key['user_pseudo'] . '</b></red>') . '</br> <ul id="arrows">
function selectedArticles($current_user_id, $current_time = null) { if (!isset($current_time)) { $current_time = time(); } $last = strtotime('last Sunday', $current_time); $next = strtotime('next Sunday', $current_time); $lastSunday = mktime(8, 0, 0, date('m', $last), date('d', $last), date('Y', $last)); $nextSunday = mktime(8, 0, 0, date('m', $next), date('d', $next), date('Y', $next)); $list_articles = '<table id="list-articles">'; $list_articles .= '<tr class="title"><td>Date</td><td>Auteur</td><td>Titre</td><td>Cotation</td><td>Action</td><td>Intervenants</td></tr>'; connectBD(); /* On recupere les infomations des articles */ $sql = "SELECT DISTINCT (num_article), nom_membre, article_titre, article_url, article_pub\n\t\tFROM article, membre, article_pool\n\t\tWHERE article.num_membre = membre.num_membre\n\t\tAND article_pool.article_id = article.num_article\n\t\tAND article_pool.period = " . $nextSunday . "\n\t\tORDER BY article_pub DESC"; $request = mysql_query($sql) or die("Error with request {$sql}"); $nb_articles = 0; while ($article = mysql_fetch_row($request)) { $nb_articles++; $article_id = $article[0]; $article_author = $article[1]; $article_date = date("d/m/Y", $article[4]); $article_titre = decode_strip($article[2], 100); $article_titre = '<a href="' . $article[3] . '" target="_blank">' . $article_titre . '</a>'; $sql = "SELECT user_id, login, cotation\n\t\t\tFROM article_pool, user\n\t\t\tWHERE article_pool.user_id = user.id\n\t\t\tAND article_id = " . $article_id; $res = mysql_query($sql); $users = '<ul class="userlist">'; $status = 'unselected'; $cotation = array('nb_votes' => 0, 'style' => 0, 'recherche' => 0, 'contenu' => 0); while ($vote = mysql_fetch_row($res)) { $n++; if ($vote[0] == $current_user_id) { $status = 'selected'; } $users .= '<li>' . $vote[1] . "</li>"; $user_vote = json_decode($vote[2]); $cotation['nb_votes'] += 1; $cotation['style'] += $user_vote->{'style'}; $cotation['contenu'] += $user_vote->{'contenu'}; $cotation['recherche'] += $user_vote->{'recherche'}; } $users .= '</ul>'; $cotation = compute_cotation($cotation); if ($status == 'selected') { $action = '<img src="images/like-light.png" title="Sélectionner cet article" />'; } else { $action = '<a href="javascript:select(' . $article_id . ')"><img src="images/like.png" title="Sélectionner cet article" /></a>'; } $list_articles .= '<tr id="line' . $article_id . '" class="' . $status . '">'; $list_articles .= '<td>' . $article_date . '</td>'; $list_articles .= '<td><b>' . $article_author . '</b></td>'; $list_articles .= '<td>' . $article_titre . '</td>'; $list_articles .= '<td>' . $cotation . '</td>'; $list_articles .= '<td><span id="action' . $article_id . '">' . $action . '</span></td>'; $list_articles .= '<td>' . $users . '</td></tr>'; } $list_articles .= "</table>"; $content = '<h3>Articles déjà selectionnés</h3>'; $content .= $list_articles; closeBD(); if ($nb_articles == 0) { return $content . '<p>Aucun article trouvé</p>'; } return $content; }
<?php require_once 'functions.php'; $mysqli = connectBD(); $query = "SELECT * FROM categories WHERE id_parent = 0"; if ($result = $mysqli->query($query)) { ?> <ul> <?php while ($obj = $result->fetch_object()) { $article = getArticles($obj->id) ? getArticles($obj->id) : ''; $sub = getSubCategory($obj->id) ? getSubCategory($obj->id) : ''; echo '<li>' . $obj->name . '' . $sub . $article . '</li>'; } ?> </ul> <?php }