Quora-2/admin.php at main · 03prashantpk/Quora-2 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
<!DOCTYPE html>
<html lang="fr">
   <head>
      <title>LiveQuestion</title>
      <meta charset="utf-8">
      <meta name="viewport" content="width=device-width, initial-scale=1">
      <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
      <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
      <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.bundle.min.js"></script>
      <link rel="stylesheet" type="text/css" href="styles/admin.css">
      <script src="script.js"></script>
      <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.15.1/css/all.css">
      <link rel="icon" href="img/favicon.png" type="image/png">
   </head>
   <body>
      <!-- NAVBAR -->
    <?php
    session_start();
    if (!isset($_SESSION["pseudo"]) || $_SESSION["pseudo_role"] != "admin") {
       header("Location: connexion.php");
       exit();
    }
    ?>
    <?php include("lqnavbar.php"); ?>
      <section>
         <div class="container">
         <?php

         require("DB/connexion.php");

         function getCateg($id) {
            $co = connexionBdd();
            $query = $co->prepare("SELECT nom FROM categories WHERE id=:id");
            $query->bindParam(":id", $id);
            $query->execute();
            $result = $query->fetch();
            return $result["nom"];
         }

         function getAuteur($id) {
            $co = connexionBdd();
            $query = $co->prepare("SELECT pseudo FROM utilisateurs WHERE id=:id");
            $query->bindParam(":id", $id);
            $query->execute();
            $result = $query->fetch();
            return $result["pseudo"];
         }

         function getAvatar($id) {
            $co = connexionBdd();
            $query = $co->prepare("SELECT avatar FROM utilisateurs WHERE id=:id");
            $query->bindParam(":id", $id);
            $query->execute();
            $result = $query->fetch();
            return $result["avatar"];
         }


         function changeLikeIcon($like_question_id) {
            $co = connexionBdd();
            $query = $co->prepare("SELECT * FROM likes WHERE utilisateur_id=:pseudo_id AND question_id=:question_id");
            $query->bindParam(":question_id", $like_question_id);
            $query->bindParam(":pseudo_id", $_SESSION["pseudo_id"]);
            $query->execute();
            $row = $query->rowCount();
            if ($row == 1) {
               return "fas fa-heart";
            } else {
               return "far fa-heart";
            }
         }


         $co = connexionBdd();
         $query = $co->query("SELECT * FROM questions");
         $results = $query->fetchAll();
         foreach (array_reverse($results) as $result) {
            $query = $co->prepare("SELECT count(*) from repondre WHERE questions_id=:question_id");
            $query->bindParam(":question_id", $result[0]);
            $query->execute();
            $responseNumber = $query->fetch();
            $query = $co->prepare("SELECT * from likes WHERE question_id=:question_id");
            $query->bindParam(":question_id", $result[0]);
            $query->execute();
            $likesNumber = $query->rowCount();
            $likeIcon = changeLikeIcon($result[0]);
            echo "<div class='toast show' role='alert' aria-live='assertive' aria-atomic='true'>",
                 "<div class='toast-header'>",
                 "<strong class='mr-auto'><img class='avatar' src='" . getAvatar($result[3]) . "'> <a href='profil.php?pseudo_id=$result[3]'>" . getAuteur($result[3]) . "</a> | $responseNumber[0] réponses | " . getCateg($result[2]) . " | <a href='like.php?question_id=$result[0]'><i class='$likeIcon'></i></a> $likesNumber</strong>
                 <small>$result[4]</small>",
                 "<a href='delete.php?question_id=$result[0]'><button type='button'>Supprimer</button></a>",
                 "</div>",
                 "<div class='toast-body'>",
                 "<a href='question.php?question_id=$result[0]'>$result[1]</a>",
                 "</div>",
                 "</div>";
         }


         ?>
         </div>
      </section>
   </body>
</html>