<?php
// CIFOM-Ecole Technique, salle 226, enseignant: A. Jeanmaire
// Auteur: jeanmaireal, date: 15 sept. 2014 22:12:41, script: Ref43.php
// But du script: Afficher les détails d'abonnement pour l'abo sélectionné
// Partie "métier" ici
// Connexion
require_once './Pdo_start.inc.php';
$pdo = pdo_connexion("natels");
// Récupération de l'Id de l'abonnement
// Exécution de la requête non préparée et récupération des enregistrements
$sql_nonprepare = "SELECT CONCAT(\"<img src='data:image/png;base64,\",`LogoOperateur`,\"' alt='Logo \",`NomOperateur`,\"'>\") AS 'Enseigne', "
. "`operateur`.`NomOperateur`, `NomAbonnement`, `PrixMensuel`, `CentimesMinuteFixeCh`, `CentimesMinuteMobileCh`, `DonneesMoInclus`, `ReserveMoins26Ans`, `DownloadMbParSec` "
. "FROM `abonnement` LEFT JOIN `operateur` ON `abonnement`.`OperateurId` = `operateur`.`idOperateur` "
. "WHERE `IdAbonnement` =$AbonnementId";
$pdo_query = $pdo->query($sql_nonprepare);
$tab_resultats_query = $pdo_query->fetchAll();
$pdo_query->closeCursor();
// Mise en forme dans un tableau HTML comme à l'exercice Pdo2
$grille = "<table><tr>";
foreach ($tab_resultats_query[0] as $key => $value) {
$grille.="<th>$key</th>";
}
$grille.="</tr>";
for ($i = 0; $i < count($tab_resultats_query); $i++) {
$grille.="<tr>";
foreach ($tab_resultats_query[$i] as $key => $value) {
if ($key == "siteMarque")
$value = "<a href='$value'>$value</a>";
$grille.="<td>$value</td>";
}
$grille.="</tr>";
}
$grille.="</table>";
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Ref43 - Abo sélectionné</title>
<style>
svg { width: 100px; height: 40px; }
table, td, th { border: 1px black solid; padding: 10px; border-collapse:collapse; }
</style>
</head>
<body>
<?= $grille; ?>
</body>
</html>
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}