Re: ref43.php

$OperateurId = @filter_input(INPUT_POST, 'OperateurId');
$fixe = @filter_input(INPUT_POST, 'fixe');
$mobile = @filter_input(INPUT_POST, 'mobile');
$mo = @filter_input(INPUT_POST, 'mo');

include '../Pdo_start.inc.php';
$pdo = pdo_connexion('natels');

$sql_prepare pdo_connexion('natels');
$IdAbonnement = @filter_input(INPUT_GET, 'idAbo');
$sql_prepare2 = "SELECT CONCAT(\"\") AS 'Enseigne', `operateur`.`NomOperateur`, `abonnement`.~~`IdAbonnement`, `abonnement`.~~`NomAbonnement`, `abonnement`.~~`OperateurId`, round((`abonnement`.`PrixMensuel` +~~ `PrixMensuel`, `abonnement`.~~`CentimesMinuteFixeCh` * :fixe +~~ `CentimesMinuteFixeCh`, `abonnement`.~~`CentimesMinuteMobileCh` * :mobile),2) AS 'Prix de consommation' ,`abonnement`.`DonneesMoInclus`~~
`CentimesMinuteMobileCh`, `abonnement`.`DonneesMoInclus`, `abonnement`.`ReserveMoins26Ans`, `abonnement`.`DownloadMbParSec`
FROM `operateur`
    LEFT JOIN `abonnement` ~~WHERE `abonnement`.`DonneesMoInclus` > :mo AND~~ ON `abonnement`.`OperateurId` = :OperateurId";
$pdo_prepare `operateur`.`idOperateur`  WHERE `abonnement`.`IdAbonnement` = $pdo->prepare($sql_prepare);
$pdo_prepare->bindValue(":OperateurId", $OperateurId);
$pdo_prepare->bindValue(":fixe", $fixe);
$pdo_prepare->bindValue(":mobile", $mobile);
$pdo_prepare->bindValue(":mo", $mo);
$pdo_prepare->execute();

$tab_prepare :IdAbo ";
$pdo_prepare2 = $pdo_prepare->fetchAll();

$liens $pdo->prepare($sql_prepare2);
$pdo_prepare2->bindValue(":IdAbo", $IdAbonnement);
$pdo_prepare2->execute();
$tab_prepare2 = "";

if (count($tab_prepare) == 0) {
    $liens .$pdo_prepare2->fetchAll();
//$pdo_prepare2->closeCursor();

$table = "Aucun abonnement ne correspond aux critères";
} else {
    "";
$table .= "";
foreach ~~($tab_prepare~~ ($tab_prepare2[0] as ~~$row)~~ $key => $value) {
    $table .="";
}
$table .= "";
for ($index = 0; $index < count($tab_prepare2); $index++) {
    $table .= "";
    foreach ($tab_prepare2[$index] as $key => $value) {
        ~~$idAbo~~ $table .= $row['IdAbonnement'];
        $liens .= "";
        $liens .= $row['NomAbonnement'];
        $liens .= " à ";
        $liens .= $row['Prix de consommation'];
        $liens .= " Fr/mois ";
        $liens .= ", ";
"";
    }
    ~~$liens~~ $table .= ~~rtrim($liens, ", ");~~
"";
}
$table .= "
$key
$value

";

?>












D'après votre consomamtion, voici les abonnements les plus favorables

            $liens $table ?>

$key
$value

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 -

D'après votre consomamtion, voici les abonnements les plus favorables

Replies to Re: ref43.php

Reply to "Re: ref43.php"