language-center-app/detaille_prof.php at main · Ayoub-ABH/language-center-app · 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
<?php
include('dbconfig.php');
include('security.php');
secAdmin();

include('includes/header.php');
include('includes/navbar.php');
?>

<div class="container mt-5">
    <div class="row justify-content-center">
        <div class="col-md-6">
            <?php
            if (isset($_GET['id'])) {
                $professorId = $_GET['id'];
                $queryProfessor = "SELECT * FROM professeurs WHERE ProfesseurID = ?";

                if ($stmt = $connection->prepare($queryProfessor)) {
                    $stmt->bind_param("i", $professorId);
                    $stmt->execute();
                    $result = $stmt->get_result();

                    if ($rowProfessor = $result->fetch_assoc()) {
                        // Récupérer le nombre de groupes associés à ce professeur
                        $queryCountGroups = "SELECT COUNT(*) AS group_count FROM groupes WHERE ProfesseurID = ?";
                        if ($stmtCount = $connection->prepare($queryCountGroups)) {
                            $stmtCount->bind_param("i", $professorId);
                            $stmtCount->execute();
                            $resultCount = $stmtCount->get_result();
                            $rowCount = $resultCount->fetch_assoc();
                            $groupCount = $rowCount['group_count'];
                            $stmtCount->close();
                        } else {
                            $groupCount = 0;
                        }
                        // Vérifier si une photo est disponible, sinon utiliser une image par défaut
                        $professorImage = !empty($rowProfessor['Image']) ? $rowProfessor['Image'] : 'blanc.png';
                        ?>
                        <div class="card border-0 shadow">
                            <div class="card-body text-center">
                                <div class="mb-4">
                                    <img src="upload/images/<?php echo htmlspecialchars($professorImage); ?>" class="img-fluid rounded" alt="avatar" style="max-width: 200px;">
                                </div>
                                <h5 class="card-title text-primary"><?php echo htmlspecialchars($rowProfessor['Professeur_name'] . ' ' . $rowProfessor['Professeur_prenom']); ?></h5>
                                <ul class="list-group list-group-flush">
                                    <li class="list-group-item">
                                        <strong>CIN:</strong> <?php echo htmlspecialchars($rowProfessor['CIN']); ?>
                                    </li>
                                    <li class="list-group-item">
                                        <strong>Email:</strong> <?php echo htmlspecialchars($rowProfessor['Email']); ?>
                                    </li>
                                    <li class="list-group-item">
                                        <strong>Téléphone:</strong> <?php echo htmlspecialchars($rowProfessor['Tele']); ?>
                                        <a href="https://wa.me/<?php echo htmlspecialchars($rowProfessor['Tele']); ?>" target="_blank" class="text-success ml-2"><i class="fab fa-whatsapp"></i></a>
                                    </li>
                                    <li class="list-group-item">
                                        <strong>Adresse:</strong> <?php echo htmlspecialchars($rowProfessor['Adresse']); ?>
                                    </li>
                                    <li class="list-group-item">
                                        <strong>Nombre de groupes associés:</strong> <?php echo htmlspecialchars($groupCount); ?>
                                    </li>
                                </ul>
                            </div>
                        </div>
                        <?php
                    } else {
                        echo '<div class="alert alert-danger text-center mt-4">Détails non disponibles</div>';
                    }
                    $stmt->close();
                } else {
                    echo '<div class="alert alert-danger text-center mt-4">Erreur de préparation de la requête SQL</div>';
                }
            } else {
                echo '<div class="alert alert-warning text-center mt-4">ID du professeur non spécifié</div>';
            }
            ?>
        </div>
    </div>
</div>

<?php
include('includes/footer.php');
?>