OK, Evo kako izgleda sesija:
Code:
[root@avalon ez]# export ORACLE_HOME=/opt/oracle/Oracle9i
[root@avalon ez]# php dual.php
<html><body>
<table border="1">
<tr>
<th>DUMMY</th>
</tr>
<tr>
<td>X</td>
</tr>
</table>
1 Records Selected<br />
</body></html>
Segmentation fault
Dakle, vrati mi sve kako treba, ali i Segmentation Fault.
Evo i skripta:
Code:
[root@avalon ez]# cat dual.php
<html><body>
<?php
putenv('ORACLE_HOME=/opt/oracle/Oracle9i');
$conn = oci_connect("system","manager","beorn");
$upit = "select * from dual";
$stmt = oci_parse($conn,$upit);
oci_execute($stmt);
$nrows = oci_fetch_all($stmt, $results);
if ($nrows > 0) {
echo "<table border=\"1\">\n";
echo "<tr>\n";
while (list($key, $val) = each($results)) {
echo "<th>$key</th>\n";
}
echo "</tr>\n";
for ($i = 0; $i < $nrows; $i++) {
reset($results);
echo "<tr>\n";
while ($column = each($results)) {
$data = $column['value'];
echo "<td>$data[$i]</td>\n";
}
echo "</tr>\n";
}
echo "</table>\n";
} else {
echo "No data found<br />\n";
}
echo "$nrows Records Selected<br />\n";
oci_free_statement($stmt);
oci_close($conn);
?>
</body></html>