browser_genera.php

<?php
//IKnew Herbarium Database Package
//Created by Robert R. Pace
//robert_pace3@eku.edu
//quepid@gmail.com
//
//This PHP/MySQL solution was created under direction of Dr. Ronald L. Jones from Eastern Kentucky University
//with the purpose to update the previous database (Index Kentuckiensis) to an online model with similar functionality
//
//This file deals with displaying a table of genera for the previously selected Family.
//
//the include files:
//header.php - this contains the html header information such as university banner and icon along with title text
//common.php - this contains global variables that are needed for formatting or shaping queries (such as the maximum number of query results via LIMIT)
//connect.php - this contains the connection settings for the MySQL database (such as Db name, username, password, server)
//footer.php - this contains the information to be displayed at the bottom of the page (copyright, version)
//

//display the html header
include_once("header.php");

// connect to database.
include("connect.php");

//load the global variables
include("common.php");

$browsefamily = mysqli_real_escape_string($mysqli,$_GET['family']);

//initialize $row_count, this variable will hold the number of rows returned by the query
//and will be used to color resultant rows
$row_count = 0;

//Display return to previous search link
echo "<center><a href=browser_family.php>Return to Search-by-Family</a><br></center>";

// Build a query string that displays distinct (unique) genera given the previously selected Family.
$psql = "SELECT DISTINCT Genus FROM `iknew` WHERE Family = '";
$p2sql = "'";
$query = $psql . $browsefamily .$p2sql;

// submit the query
$result = mysql_query($query) or die("MS-Query Error in select-query");

//calculate number of results of the query ran and display
$querystats=mysql_num_rows($result); 
echo "<center><p><b>Your query returned $querystats results (max queries = $maxsearch)</b></p></center>";

//Start a HTML Table
echo "<center><table border=1>";

// display results in HTML Table
echo "<tr><td bgcolor=$color3><b>Family</td><td bgcolor=$color3><b>Genus</b></td></tr>";

//initialize $resultcounter variable
$resultcounter=1;

// for every result returned from query do the below

while ($row = mysql_fetch_array($result))
{

$genera = "$urlthree"."browser_species.php?family="."$browsefamily"."&genus="."$row[Genus]";
// determine row colour
$row_color = ($row_count % 2) ? $color1 : $color2;

//
// Now display actual data in the table cells via echo to browser of the $row's array of data
   echo "<tr><td bgcolor=$row_color><b>$browsefamily</b></td><td bgcolor=$row_color><a href='$genera'>$row[Genus]</a></td>";
   echo "</tr>";
   $resultcounter++;
   
   // Add 1 to the row count
   $row_count++;
}
echo "</table></center>";

//display footer
include_once("footer.php");
?>
</div>
<center><a href=browser_family.php>Return to Search-by-Family</a></center>
</body>
</html>