Server : Apache/2.4.43 (Win64) OpenSSL/1.1.1g PHP/7.4.6 System : Windows NT USER-PC 6.1 build 7601 (Windows 7 Professional Edition Service Pack 1) AMD64 User : User ( 0) PHP Version : 7.4.6 Disable Function : NONE Directory : C:/xampp/contrib/ |
<html> <head> <title>PHP und Oracle</title> </head> <body> <h1>PHP und Oracle</h1> <table border="1"> <tr> <th>Interpret</th> <th>Titel</th> <th>Jahr</th> </tr> <?php $db="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=localhost) (PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=xe)))"; // Oracle 10g //$db="//localhost/xe"; $c=ocilogon("hr", "geheim", $db); $s = ociparse($c, "SELECT * FROM cds"); if(ociexecute($s)) { while (ocifetch($s)) { echo "<tr>"; echo "<td>".ociresult($s, "INTERPRET")."</td>"; echo "<td>".ociresult($s, "TITEL")."</td>"; echo "<td>".ociresult($s, "JAHR")."</td>"; echo "</tr>"; } } else { $e = oci_error($s); echo htmlentities($e['message']); } ?> </table> </body> </html>