kurs:oar_php_2
Differences
This shows you the differences between two versions of the page.
| — |
kurs:oar_php_2 [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Abfrage testen ====== | ||
| + | das Login-Script mit folgender Funktion erweitern: | ||
| + | <code php> | ||
| + | function prüfen($co,$sql){ | ||
| + | return ociparse($co,$sql); | ||
| + | } | ||
| + | </code> | ||
| + | ergibt: | ||
| + | <code php> | ||
| + | <?php | ||
| + | $co = @ocilogon('HR','tiger'); //Datenbank Anmeldung (Schemaname, Passwort{,SID}) | ||
| + | $sql = 'select* from jobs'; | ||
| + | |||
| + | // Abfrage testen | ||
| + | function prüfen($co,$sql){ | ||
| + | return ociparse($co,$sql); | ||
| + | } | ||
| + | |||
| + | // Fehlerausgabe | ||
| + | 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 | ||
| + | } | ||
| + | else | ||
| + | { | ||
| + | // die Datenbank ansprechen | ||
| + | echo('verbunden mit '.ociserverversion($co).'<br>'); // gibt die Oracle Version zurück | ||
| + | print(prüfen($co,$sql)); | ||
| + | // die Verbindung schließen | ||
| + | ocilogoff($co); | ||
| + | } | ||
| + | ?> | ||
| + | </code> | ||
| + | |||
| + | </code> | ||
kurs/oar_php_2.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
