kurs:ora_1
Differences
This shows you the differences between two versions of the page.
|
kurs:ora_1 [2014/09/10 21:22] |
kurs:ora_1 [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | <code php> | ||
| + | <?php | ||
| + | function oracle_kontakt($sql,&$co,$user='scott',$passwort='tiger'){ | ||
| + | $co = @ocilogon($user,$passwort); // Anmeldung | ||
| + | if(!$co){ | ||
| + | $a_fehler = ocierror(); // Oracle Fehlermeldung | ||
| + | echo('<p>Fehler Nr'); | ||
| + | echo($a_fehler['code']); | ||
| + | echo('br'); | ||
| + | echo($a_fehler['message']."<br>"); | ||
| + | die(); // beendet das Script | ||
| + | } | ||
| + | $result = ociparse($co,$sql); // Abfrage testen | ||
| + | if (!$result){ | ||
| + | die('Fehler bei ociparse'); // Beenden bei Fehler | ||
| + | } | ||
| + | $ausführen = ociexecute($result); // Abfrage ausführen | ||
| + | if (!$ausführen){ | ||
| + | die('Fehler bei ociexecute'); // Beenden bei Fehler | ||
| + | } | ||
| + | return $result; | ||
| + | } | ||
| + | function spalte_name($result,$no){ | ||
| + | return ocicolumnname($result,$no); // Spaltennamenausgabe | ||
| + | } | ||
| + | function spalte_anz($result){ | ||
| + | return ocinumcols($result); // Spaltenanzahl ermitteln | ||
| + | } | ||
| + | // alle Spaltennamen | ||
| + | function spalte_alle($result){ | ||
| + | $z = spalte_anz($result); | ||
| + | for ($i=1; $i<=$z; $i++){ | ||
| + | print(spalte_name($result,$i)."<br>"); | ||
| + | } | ||
| + | } | ||
| + | function zeile_holen($result){ | ||
| + | return ocifetch($result); // Datenzeile holen | ||
| + | } | ||
| + | // die Datenbank ansprechen | ||
| + | $co = ''; | ||
| + | $result = oracle_kontakt('select * from EMP',$co); | ||
| + | $spalten = spalte_anz($result); | ||
| + | |||
| + | print("<table border=1>"); | ||
| + | print("<tr><td align=center bgcolor='#999999' colspan=".$spalten."><font size=18px color='#ffffff'>Scott - EMP</font></td></tr>"); | ||
| + | for($i=1;$i<=$spalten;$i++){ | ||
| + | print("<th>".spalte_name($result,$i)."</th>"); | ||
| + | } | ||
| + | while(ocifetch($result)){ | ||
| + | print("<tr>"); | ||
| + | for($i=1; $i <= $spalten; $i++){ | ||
| + | print("<td width=100>".ociresult($result,$i)."</td>"); | ||
| + | } | ||
| + | print("</tr>"); | ||
| + | } | ||
| + | print("</table>"); | ||
| + | |||
| + | ocilogoff($co); // die Verbindung schließen | ||
| + | ?> | ||
| + | </code> | ||
kurs/ora_1.txt · Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
