Mercurial > hg > extraction-interface
diff _xampp/contrib/oracle.php @ 0:b12c99b7c3f0
commit for previous development
| author | Zoe Hong <zhong@mpiwg-berlin.mpg.de> |
|---|---|
| date | Mon, 19 Jan 2015 17:13:49 +0100 |
| parents | |
| children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/_xampp/contrib/oracle.php Mon Jan 19 17:13:49 2015 +0100 @@ -0,0 +1,45 @@ +<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> +