From Torrid Hog, 3 Years ago, written in HTML5.

This paste is a reply to Re: Untitled from Unique Pintail - view diff

Embed

Download Paste or View Raw
Hits: 97

<?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

session_start();

error_reporting(E_ALL);

// Connexion

require_once './Pdo_start.inc.php';

$pdo = pdo_connexion("natels");

// Récupération de l'Id de l'abonnement

$AbonnementId=filter_input(INPUT_GET,'AbonnementId');

// 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>

Replies to Re: Re: Untitled

Title	Name	Language	UNIX	When
Re: Re: Re: Untitled	Cream Motmot	php	1604394837	3 Years ago.

Author

Title

Language

Your paste - Paste your paste here

&lt;?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 &quot;métier&quot; ici
session_start();
error_reporting(E_ALL);

// Connexion
require_once './Pdo_start.inc.php';
$pdo = pdo_connexion(&quot;natels&quot;);

// Récupération de l'Id de l'abonnement
$AbonnementId=filter_input(INPUT_GET,'AbonnementId');

// Exécution de la requête non préparée et récupération des enregistrements
$sql_nonprepare = &quot;SELECT CONCAT(\&quot;&lt;img src='data:image/png;base64,\&quot;,`LogoOperateur`,\&quot;' alt='Logo \&quot;,`NomOperateur`,\&quot;'&gt;\&quot;) AS 'Enseigne', &quot;
        . &quot;`operateur`.`NomOperateur`, `NomAbonnement`, `PrixMensuel`, `CentimesMinuteFixeCh`, `CentimesMinuteMobileCh`, `DonneesMoInclus`, `ReserveMoins26Ans`, `DownloadMbParSec` &quot;
        . &quot;FROM `abonnement` LEFT JOIN `operateur` ON `abonnement`.`OperateurId` = `operateur`.`idOperateur` &quot;
        . &quot;WHERE `IdAbonnement` =$AbonnementId&quot;;
$pdo_query = $pdo-&gt;query($sql_nonprepare);
$tab_resultats_query = $pdo_query-&gt;fetchAll();
$pdo_query-&gt;closeCursor();

// Mise en forme dans un tableau HTML comme à l'exercice Pdo2
$grille = &quot;&lt;table&gt;&lt;tr&gt;&quot;;
foreach ($tab_resultats_query[0] as $key =&gt; $value) {
    $grille.=&quot;&lt;th&gt;$key&lt;/th&gt;&quot;;
}
$grille.=&quot;&lt;/tr&gt;&quot;;
for ($i = 0; $i &lt; count($tab_resultats_query); $i++) {
    $grille.=&quot;&lt;tr&gt;&quot;;
    foreach ($tab_resultats_query[$i] as $key =&gt; $value) {
        if ($key == &quot;siteMarque&quot;)
            $value = &quot;&lt;a href='$value'&gt;$value&lt;/a&gt;&quot;;
        $grille.=&quot;&lt;td&gt;$value&lt;/td&gt;&quot;;
    }
    $grille.=&quot;&lt;/tr&gt;&quot;;
}
$grille.=&quot;&lt;/table&gt;&quot;;
?&gt;
&lt;!DOCTYPE html&gt;
&lt;html&gt;
    &lt;head&gt;
        &lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=UTF-8&quot;&gt;
        &lt;title&gt;Ref43 - Abo sélectionné&lt;/title&gt;
        &lt;style&gt;
            svg { width: 100px; height: 40px; }
            table, td, th { border: 1px black solid; padding: 10px; border-collapse:collapse; }
        &lt;/style&gt;
    &lt;/head&gt;
    &lt;body&gt;
&lt;?= $grille; ?&gt;
    &lt;/body&gt;
&lt;/html&gt;

Private - Private paste aren't shown in recent listings.

Delete After - When should we delete your paste?

Spam protection -

{"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"}

Re: Re: Untitled

Replies to Re: Re: Untitled

Reply to "Re: Re: Untitled"