From Tiny Rhinoceros, 3 Years ago, written in PHP.

This paste is a reply to ref42.php from Perl Prairie Dog - view diff

Embed

Download Paste or View Raw
Hits: 110

<?php

include '../Pdo_start.inc.php';

$pdo = pdo_connexion('natels');

$IdAbonnement = @filter_input(INPUT_GET, 'idAbo');

$sql_prepare2 = "SELECT CONCAT(\"<img src='data:image/png;base64,\", `operateur`.`LogoOperateur`,\"' alt='Logo \",`NomOperateur`,\"'>\") AS 'Enseigne', `operateur`.`NomOperateur`, `abonnement`.`NomAbonnement`, `abonnement`.`PrixMensuel`, `abonnement`.`CentimesMinuteFixeCh`, `abonnement`.`CentimesMinuteMobileCh`, `abonnement`.`DonneesMoInclus`, `abonnement`.`ReserveMoins26Ans`, `abonnement`.`DownloadMbParSec`

FROM `operateur`

LEFT JOIN `abonnement` ON `abonnement`.`OperateurId` = `operateur`.`idOperateur` WHERE `abonnement`.`IdAbonnement` = :IdAbo ";

$pdo_prepare2 = $pdo->prepare($sql_prepare2);

$pdo_prepare2->bindValue(":IdAbo", $IdAbonnement);

$pdo_prepare2->execute();

$tab_prepare2 = $pdo_prepare2->fetchAll();

//$pdo_prepare2->closeCursor();

$table = "";

$table .= "<table><tr>";

foreach ($tab_prepare2[0] as $key => $value) {

$table .="<th>$key</th>";

}

$table .= "</tr>";

for ($index = 0; $index < count($tab_prepare2); $index++) {

$table .= "<tr>";

foreach ($tab_prepare2[$index] as $key => $value) {

$table .= "<td>$value</td>";

}

$table .= "</tr>";

}

$table .= "</table>";

?>

<!DOCTYPE html>



<html>

<head>

<meta charset="UTF-8">

<title></title>

<style>

svg { width: 100px; height: 40px; }

table, td, th { border: 1px black solid; padding: 10px; border-collapse:collapse; }

</style>

</head>

<body>

<form>

<h1>D'après votre consomamtion, voici les abonnements les plus favorables</h1>

<?= $table ?>

</form>

</body>

</html>

Replies to Re: ref43.php

Title	Name	Language	UNIX	When
prep1.php	Big Goose	php	1604397478	3 Years ago.

Author

Title

Language

Your paste - Paste your paste here

&lt;?php

include '../Pdo_start.inc.php';
$pdo = pdo_connexion('natels');
$IdAbonnement = @filter_input(INPUT_GET, 'idAbo');
$sql_prepare2 = &quot;SELECT CONCAT(\&quot;&lt;img src='data:image/png;base64,\&quot;, `operateur`.`LogoOperateur`,\&quot;' alt='Logo \&quot;,`NomOperateur`,\&quot;'&gt;\&quot;) AS 'Enseigne', `operateur`.`NomOperateur`, `abonnement`.`NomAbonnement`, `abonnement`.`PrixMensuel`, `abonnement`.`CentimesMinuteFixeCh`, `abonnement`.`CentimesMinuteMobileCh`, `abonnement`.`DonneesMoInclus`, `abonnement`.`ReserveMoins26Ans`, `abonnement`.`DownloadMbParSec`
FROM `operateur`
    LEFT JOIN `abonnement` ON `abonnement`.`OperateurId` = `operateur`.`idOperateur`  WHERE `abonnement`.`IdAbonnement` = :IdAbo &quot;;
$pdo_prepare2 = $pdo-&gt;prepare($sql_prepare2);
$pdo_prepare2-&gt;bindValue(&quot;:IdAbo&quot;, $IdAbonnement);
$pdo_prepare2-&gt;execute();
$tab_prepare2 = $pdo_prepare2-&gt;fetchAll();
//$pdo_prepare2-&gt;closeCursor();

$table = &quot;&quot;;
$table .= &quot;&lt;table&gt;&lt;tr&gt;&quot;;
foreach ($tab_prepare2[0] as $key =&gt; $value) {
    $table .=&quot;&lt;th&gt;$key&lt;/th&gt;&quot;;            
}
$table .= &quot;&lt;/tr&gt;&quot;;
for ($index = 0; $index &lt; count($tab_prepare2); $index++) {
    $table .= &quot;&lt;tr&gt;&quot;;
    foreach ($tab_prepare2[$index] as $key =&gt; $value) {
        $table .= &quot;&lt;td&gt;$value&lt;/td&gt;&quot;;
    }
    $table .= &quot;&lt;/tr&gt;&quot;;
}
$table .= &quot;&lt;/table&gt;&quot;;

?&gt;
&lt;!DOCTYPE html&gt;
&lt;!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
--&gt;
&lt;html&gt;
    &lt;head&gt;
        &lt;meta charset=&quot;UTF-8&quot;&gt;
        &lt;title&gt;&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;form&gt;
            &lt;h1&gt;D'après votre consomamtion, voici les abonnements les plus favorables&lt;/h1&gt; 
            &lt;?= $table ?&gt;
        &lt;/form&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: ref43.php

Replies to Re: ref43.php

Reply to "Re: ref43.php"