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
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Document sans nom</title>
<style type="text/css">
<!--
.Style3 {color: #FFFFFF; font-weight: bold; }
.Style4 {color: #000000}
.Style11 {font-weight: bold}
.Style12 {font-weight: bold}
.Style13 {font-weight: bold}
.Style14 {font-weight: bold}
-->
</style>
</head>
<body>
<table width="950" border="1" align="center" bgcolor="#990000">
<tr>
<td width="125"><div align="center" class="Style3">NOM</div></td>
<td width="126"><div align="center" class="Style3">PRENOM</div></td>
<td width="210"><div align="center" class="Style3">ADRESSE MAIL</div></td>
<td width="154"><div align="center" class="Style3">N° DE TEL</div></td>
<td width="134"><div align="center" class="Style3">STAUT</div></td>
<td width="127"><div align="center" class="Style3">C.I.S.</div></td>
<td width="28"></td>
</tr>
</table>
<?php
try
{
// On se connecte à MySQL
$bdd = new PDO('mysql:host=:P:P;dbname=:oops::oops:f;charset=utf8', ':mouarf::mouarf:', ':lol::lol:');
}
catch(Exception $e)
{
// En cas d'erreur, on affiche un message et on arrête tout
die('Erreur : '.$e->getMessage());
}
// Si tout va bien, on peut continuer
// On récupère tout le contenu de la table
$reponse = $bdd->query('SELECT * FROM info_tbl order by nom, prenom');
// On affiche chaque entrée une à une
while ($donnees = $reponse->fetch())
{
?>
<table width="950" border="1" align="center" bgcolor="#FFFFFF">
<tr class="Style4">
<td width="125"><div align="center">
<div align="left"><?php echo $donnees['Nom']; ?></div></div></td>
<td width="126"><div align="center"><div align="left"><?php echo $donnees['Prenom']; ?></div></div></td>
<td width="211"><div align="center"><div align="left"><?php echo $donnees['Email']; ?></div></div></td>
<td width="152"><div align="center"><strong><?php echo $donnees['Telephone']; ?></strong></div></td>
<td width="137"><div align="center"><strong><?php echo $donnees['Statut']; ?></strong></div></td>
<td width="124"><div align="center">
<div align="left"><?php echo $donnees['CIS']; ?></div>
<td width="29"><div align="center"><img src="../images/cancel2.png" width="20" height="20" /> </div> </tr>
</table>
<?php
}
$reponse->closeCursor(); // Termine le traitement de la requête
?>
</body>
</html> |
Partager