PHP - Nested (Master Detail) query
From Ingres Community Wiki
The following PHP code shows how to execute a master detail (nested) query. This code requires version 2.0.0 or later (CVS) to work.
<HTML>
<HEAD>
<style>
body { font-family : verdana, tahoma, arial; }
</style>
<TITLE>Sample Master Detail report</TITLE>
</HEAD>
<BODY>
<?php
$link = ingres_connect("iidbdb");
echo "connected<br>";
var_dump($link);
$master = ingres_query($link, "select relid from iirelation order by relid asc");
var_dump($master);
?><table><?php
while ( $iirelation = ingres_fetch_object($master) ) {
$sql = "select * from iirelation where relid = '".trim($iirelation->relid)."'";
echo "<tr><td>".$iirelation->relid."</td></tr>";
$detail = ingres_query($link,$sql);
if ($detail) {
$tuple = ingres_fetch_object($detail);
echo "<tr>";
foreach ( $tuple as $key => $value )
{
echo "<td>".$value."</td>";
}
echo "</tr>\n";
ingres_free_result($detail);
} else {
echo ingres_stmt_error();
}
}
?>
</table>
<?php
ingres_free_result($master);
?>
</BODY>
</HTML>
Back to PHP Driver Examples
