GestionRole_PHP/afficherRole.php at main · Azizkh07/GestionRole_PHP · 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
<?php
require 'connexion.php';
$req=$idcom->prepare("SELECT  CodeR,Libelle,Prix FROM role;");
$req->execute();
$count=$req->rowCount();
if($count<=0){
    echo ("Aucun role Dans Base  ");
}


?>
<!DOCTYPE html>
<html>
<head></head>
<body>
 <h1>Listes Des Roles</h1>
 <table border="1">
   <thead>
     <tr>
       <th>Code role</th>
       <th>Libelle</th>
       <th>Prix</th>


     </tr>
   </thead>
   <tbody>
     <?php while($row = $req->fetch(PDO::FETCH_ASSOC)) : ?>
     <tr>
       <td><?php echo htmlspecialchars($row['CodeR']); ?></td>
       <td><?php echo htmlspecialchars($row['Libelle']); ?></td>
       <td><?php echo htmlspecialchars($row['Prix']); ?></td>

     </tr>
     <?php endwhile; ?>
   </tbody>
 </table>
 </html>