Re: ref1.php

From Corrupt Gorilla, 3 Years ago, written in PHP.

This paste is a reply to ref.inc.php from Mustard Pintail - go back

Embed

Viewing differences between ref.inc.php and Re: ref1.php

~~function picklistUnsafe($pdo, $table, $nomClePrimaire, $nomCleMetier, $preselection) {~~
     $MarqueId = filter_input(INPUT_GET, 'MarqueId');
include '../Pdo_start.inc.php';
$pdo = ~~pdo_connexion('natels');~~
    pdo_connexion('natels');
$sql_select = "SELECT ~~`$table`.`$nomClePrimaire`,~~ `marque`.~~`$nomCleMetier`~~
`idMarque`, `marque`.`nomMarque`
FROM `marque`";
    $pdo_query = ~~$pdo->query($sql_select);~~
    $pdo->query($sql_select);
$tab_select = ~~$pdo_query->fetchAll();~~

    $pdo_query->fetchAll();

$picklist = ~~"";~~

    "";

foreach ($tab_select as $row) {
        {
    $picklist .= "     $picklist .= $row['idMarque'];
    $picklist .= "'";
    if ($MarqueId == $row['idMarque']) { $picklist .= " selected "; }

        $picklist .= $row[$nomClePrimaire];
        $picklist .= "'";
        if ($preselection == $row[$nomClePrimaire]) {
            $picklist .= " selected ";
        }
        $picklist .= ">" . $row[$nomCleMetier] . "";
    }
    return $picklist;
">".$row['nomMarque']."";

}
?>?>

Author

Title

Language

Your paste - Paste your paste here

&lt;?php
$MarqueId = filter_input(INPUT_GET, 'MarqueId');
include '../Pdo_start.inc.php';
$pdo = pdo_connexion('natels');
$sql_select = &quot;SELECT `marque`.`idMarque`, `marque`.`nomMarque`
FROM `marque`&quot;;
$pdo_query = $pdo-&gt;query($sql_select);
$tab_select = $pdo_query-&gt;fetchAll();

$picklist = &quot;&quot;;

foreach ($tab_select as $row) {
    $picklist .= &quot;&lt;option value='&quot;;
    $picklist .= $row['idMarque'];
    $picklist .= &quot;'&quot;;
    if ($MarqueId == $row['idMarque']) { $picklist .= &quot; selected &quot;; }
       
        $picklist .= &quot;&gt;&quot;.$row['nomMarque'].&quot;&lt;/option&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;/head&gt;
    &lt;body&gt;
        &lt;form&gt;
            &lt;select name=&quot;MarqueId&quot;&gt;
                &lt;?= $picklist ?&gt;
            &lt;/select&gt;
            &lt;input type=&quot;submit&quot; value=&quot;Envoyer&quot; /&gt;
            &lt;?= $MarqueId ?&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"}

Reply to "Re: ref1.php"