This shows you the differences between two versions of the page.
kurs:php12_2 [2014/09/10 21:22] |
kurs:php12_2 [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Tabellen befüllen====== | ||
+ | <code php> | ||
+ | <?php | ||
+ | // Mit Datenbank verbinden | ||
+ | $db = ocilogon("scott","tiger"); | ||
+ | // den höchsten Wert des Primary Key ermitteln | ||
+ | $prim_max_a = "select max(P_NR) from PIZZA"; | ||
+ | $prim_max_b = ociparse($db,$prim_max_a); | ||
+ | ociexecute($prim_max_b); | ||
+ | ocifetch($prim_max_b); | ||
+ | $p_Nr = ociresult($prim_max_b,1); | ||
+ | |||
+ | // Array mit den Pizzanamen und deren Preis anlegen | ||
+ | $a_pizza = array( | ||
+ | "Pizza Napoli" => "5,20", | ||
+ | "Pizza Funghi" => "5,70", | ||
+ | "Pizza Mare" => "6,70", | ||
+ | "Pizza Tonno" => "6,40", | ||
+ | "Pizza Mexicana" => "5,80", | ||
+ | "Pizza Regina" => "4,50", | ||
+ | "Pizza de la Casa" => "7,80", | ||
+ | "Pizza Calzone" => "5,60", | ||
+ | "Pizza con tutti" => "9,00" | ||
+ | ); | ||
+ | |||
+ | // SQL Statement für die Befüllung | ||
+ | $insert = "insert into pizza(P_NR, P_NAME, P_PREIS) | ||
+ | values(:sp0, :sp1, :sp2)"; | ||
+ | $result = ociparse($db,$insert ); | ||
+ | |||
+ | /* den Platzhaltern an eine Variable binden | ||
+ | * Platzhalter sp0 bekommt den Wert der Variable $Nr, | ||
+ | * welche die Länge 7 hat (im Create Table Statement nachzulesen) | ||
+ | */ | ||
+ | ocibindbyname($result, "sp0", $p_Nr,7); | ||
+ | ocibindbyname($result, "sp1", $p_Name,30); | ||
+ | ocibindbyname($result, "sp2", $p_Preis,6); | ||
+ | |||
+ | // Mit Hilfe einer foreach-Schleife die Tabelle befüllen | ||
+ | foreach ($a_pizza as $name=>$preis){ | ||
+ | $p_Nr++; // Primary Key um eins erhöhen | ||
+ | $p_Name = $name; // Feld P_Name der Tabelle mit dem Wert des Arrays befüllen | ||
+ | $p_Preis = $preis; | ||
+ | ociexecute($result); | ||
+ | } | ||
+ | ?> | ||
+ | </code> |