";
$connstr = "dbname=mesonyx user=www host=localhost port=5432";
$dbh = @pg_connect($connstr);
$stat = pg_exec($dbh, $sql);
$row = pg_numrows($stat);
echo '
Results
';
echo "( $row specimens)
";
echo '
| Catalogue Number | Identification | Type | Higher Group | Description |
|---|
';
for ($i = 0; $i < $row; $i++)
{
$data = pg_fetch_row($stat, $i);
echo ' | ';
echo $data[0] ;
echo ' ';
echo $data[1] ;
echo ' | ';
echo $data[2];
echo ' | ';
echo $data[4];
echo ' | ';
echo $data[5];
echo ' |
';
}
pg_close($dbh);
}
if ($A != null && $B != null && $C == null)
{
$sql = "select v_www_catalogue.genus, v_www_catalogue.species, v_www_catalogue.type, v_www_catalogue.catalogue_number, v_www_catalogue.higher_taxon, v_www_catalogue.description from v_www_catalogue $Xtable $Ytable WHERE $Xrel $Xfield $K $Yrel $Yfield;";
echo "";
$connstr = "dbname=mesonyx user=www host=localhost port=5432";
$dbh = @pg_connect($connstr);
$stat = pg_exec($dbh, $sql);
$row = pg_numrows($stat);
echo 'Results
';
echo "( $row specimens)
";
echo '| Catalogue Number | Identification | Type | Higher Group | Description |
|---|
';
for ($i = 0; $i < $row; $i++)
{
$data = pg_fetch_row($stat, $i);
echo ' | ';
echo $data[0] ;
echo ' ';
echo $data[1] ;
echo ' | ';
echo $data[2];
echo ' | ';
echo $data[4];
echo ' | ';
echo $data[5];
echo ' |
';
}
pg_close($dbh);
}
if ($A != null && $B != null && $C != null)
{
$sql = "select v_www_catalogue.genus, v_www_catalogue.species, v_www_catalogue.type, v_www_catalogue.catalogue_number, v_www_catalogue.higher_taxon, v_www_catalogue.description from v_www_catalogue $Xtable $Ytable $Ztable WHERE $Xrel $Xfield $K $Yrel $Yfield $L $Zrel $Zfield;";
echo "";
$connstr = "dbname=mesonyx user=www host=localhost port=5432";
$dbh = @pg_connect($connstr);
$stat = pg_exec($dbh, $sql);
$row = pg_numrows($stat);
echo 'Results
';
echo "( $row specimens)
";
echo '| Catalogue Number | Identification | Type | Higher Group | Description |
|---|
';
for ($i = 0; $i < $row; $i++)
{
$data = pg_fetch_row($stat, $i);
echo ' | ';
echo $data[0];
echo ' ';
echo $data[1];
echo ' | ';
echo $data[2];
echo ' | ';
echo $data[4];
echo ' | ';
echo $data[5];
echo ' |
';
}
pg_close($dbh);
}
if ($A == null && $B == null & $C == null)
{
echo 'No Search Entered
';
}
}
if ($img == "yes")
{
if ($A != null && $B == null && $C == null)
{
$sql = "select v_www_image.genus, v_www_image.species, v_www_image.type, v_www_image.catalogue_number, v_www_image.higher_taxon, v_www_image.description, v_www_image.thumb_nail from v_www_image $Xtable WHERE $Xrel $Xfield;";
echo "";
$connstr = "dbname=mesonyx user=www host=localhost port=5432";
$dbh = @pg_connect($connstr);
$stat = pg_exec($dbh, $sql);
$row = pg_numrows($stat);
echo 'Results
';
echo "( $row images)
";
echo '| Images | Catalogue Number | Identification | Type | Higher Group | Description |
|---|
';
for ($i = 0; $i < $row; $i++)
{
$data = pg_fetch_row($stat, $i);
echo ' | ';
echo ' | ';
echo $data[0];
echo ' ';
echo $data[1];
echo ' | ';
echo $data[2];
echo ' | ';
echo $data[4];
echo ' | ';
echo $data[5];
echo ' |
|---|
';
}
pg_close($dbh);
}
if ($A != null && $B != null && $C == null)
{
$sql = "select v_www_image.genus, v_www_image.species, v_www_image.type, v_www_image.catalogue_number, v_www_image.higher_taxon, v_www_image.description, v_www_image.thumb_nail from v_www_image $Xtable $Ytable WHERE $Xrel $Xfield $K $Yrel $Yfield;";
echo "";
$connstr = "dbname=mesonyx user=www host=localhost port=5432";
$dbh = @pg_connect($connstr);
$stat = pg_exec($dbh, $sql);
$row = pg_numrows($stat);
echo 'Results
';
echo "( $row images)
";
echo '| Images | Catalogue Number | Identification | Type | Higher Group | Description |
|---|
';
for ($i = 0; $i < $row; $i++)
{
$data = pg_fetch_row($stat, $i);
echo ' | ';
echo ' | ';
echo $data[0];
echo ' ';
echo $data[1];
echo ' | ';
echo $data[2];
echo ' | ';
echo $data[4];
echo ' | ';
echo $data[5];
echo ' |
|---|
';
}
pg_close($dbh);
}
if ($A != null && $B != null && $C != null)
{
$sql = "select v_www_image.genus, v_www_image.species, v_www_image.type, v_www_image.catalogue_number, v_www_image.higher_taxon, v_www_image.description, v_www_image.thumb_nail from v_www_image $Xtable $Ytable $Ztable WHERE $Xrel $Xfield $K $Yrel $Yfield $L $Zrel $Zfield;";
echo "";
$connstr = "dbname=mesonyx user=www host=localhost port=5432";
$dbh = @pg_connect($connstr);
$stat = pg_exec($dbh, $sql);
$row = pg_numrows($stat);
echo 'Results
';
echo "( $row images)
";
echo '| Catalogue Number | Identification | Type | Higher Group | Description |
|---|
';
for ($i = 0; $i < $row; $i++)
{
$data = pg_fetch_row($stat, $i);
echo ' | ';
echo ' | ';
echo $data[0];
echo ' ';
echo $data[1];
echo ' | ';
echo $data[2];
echo ' | ';
echo $data[4];
echo ' | ';
echo $data[5];
echo ' |
|---|
';
}
pg_close($dbh);
}
if ($A == null && $B == null & $C == null)
{
$sql = "select genus, species, type, catalogue_number, higher_taxon, description, thumb_nail from v_www_image;";
echo "";
$connstr = "dbname=mesonyx user=www host=localhost port=5432";
$dbh = @pg_connect($connstr);
if ($dbh) {echo "Searching Database.........
";}
$stat = pg_exec($dbh, $sql);
$row = pg_numrows($stat);
echo 'Results
';
echo "( $row images)
";
echo '| Images | Catalogue Number | Identification | Type | Higher Group | Description |
|---|
';
for ($i = 0; $i < $row; $i++)
{
$data = pg_fetch_row($stat, $i);
echo ' | ';
echo ' | ';
echo $data[0];
echo ' ';
echo $data[1];
echo ' | ';
echo $data[2];
echo ' | ';
echo $data[4];
echo ' | ';
echo $data[5];
echo ' |
|---|
';
}
pg_close($dbh);
}
}
?>