<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="charte/charte.css" rel="stylesheet" type="text/css" />
<title>Xper2 knowledge base</title>
</head>

<body>
<?php include "inc.header.php"; ?>
<div id="conteneur"> 
<?php include "inc.menu.php"; ?><br/>

		<p class="titre-page">Welcome to the Xper2 knowledge bases website</p>

<?php include "inc.head-texte.php"; ?>
<?php include "sql.php"; ?> 

<?php
$listeGroupeTaxonomique = $conn->query("SELECT * FROM groupe_taxonomique_en");
$listeMilieux = $conn->query("SELECT * FROM milieux_en");
$listeZoneGeographique = $conn->query("SELECT * FROM zone_geographique_en");
$listeLangues = $conn->query("SELECT * FROM langues_en");
$listeRangMin = $conn->query("SELECT * FROM rang_en");
$listeFossileActuel = $conn->query("SELECT * FROM fossile_actuel_en");

//$res = $conn->query($listeGroupeTaxonomique);
/*    foreach ($listeGroupeTaxonomique as $row) {
        echo "id : ".$row['id_groupe']."| taxon : ".$row['taxons']." ; ";
    }*/
?>

<div id="index">

<form method="post" action="liste-bases-recherche.php">
    
    		
            
			<div class="categorie-gauche" style="color:#663300;">
					by taxonomic group <br />
					<select name="groupe" class="form-select" style="color:#663300;"  >
						<option value="?"></option>
<?php
while ($donnees =  mysqli_fetch_array($listeGroupeTaxonomique))
{
        echo "<option value='".$donnees['id_groupe']."'>".utf8_encode($donnees['taxons'])."</option>";
}
?>
        			</select>                  	
                    <br/>
 <a href="liste-bases-tout-groupe.php" class="select" title="Showing classified bases by organism group">
        			<img src="charte/images/fond-groupe.jpg" style="border:none; margin-top:10px;"/>
        			</a>
			
			</div>	

			<div class="categorie-gauche" style="color: #336699;">
				by living environment<br />
				<select name="milieu" class="form-select" style="color: #336699;" >
        			<option value="?"></option>
<?php
while ($donnees =  mysqli_fetch_array($listeMilieux))
{
	echo "<option value='".$donnees['id_milieu']."'>".utf8_encode($donnees['milieu_vie'])."</option>";	
}
?>
				</select>      	
                <br/>
 <a href="liste-bases-tout-milieu.php" class="select" title="Showing classified bases by living environment">
        		<img src="charte/images/fond-milieu.jpg" style="border:none; margin-top:10px;" />   
                </a>
			</div>


	  		<div class="categorie-gauche" style="color: #006600;">
				 by geographical area<br/>
				
    				
					<select name="zone" class="form-select" style="color: #006600;">
        				<option value="?"></option>
<?php
while ($donnees =  mysqli_fetch_array($listeZoneGeographique))
{
	echo "<option value='".$donnees['id_zone']."'>".utf8_encode($donnees['zone_geographique'])."</option>";
}
?>
				</select>
		<br/>
   <a href="liste-bases-tout-zone.php" class="select" title="Showing classified bases by geographical area">
                <img src="charte/images/fond-geographie.jpg" style="border:none; margin-top:10px;" />
                </a>
            </div>
                

			<div class="categorie-gauche" style="color: #993333;" >
				by language<br />
					<select name="langue" class="form-select" style="color: #993333;" >
        					<option value="?"></option>
<?php
while ($donnees =  mysqli_fetch_array($listeLangues))
{
	echo "<option value='".$donnees['id_langue']."'>".utf8_encode($donnees['liste_langue'])."</option>";
}
?>
				</select>
		<br/>
                <a href="liste-bases-tout-langue.php" class="select" title="Showing classified bases by language">
				<img src="charte/images/fond-langue.jpg" style="border:none; margin-top:10px; " />
				</a>
			</div>


			<div class="categorie-gauche" style="color: #550055;">
				by taxonomic rank<br/>
				<select name="rang" class="form-select" style="color: #550055;" >
        			<option value="?"></option>
<?php
while ($donnees =  mysqli_fetch_array($listeRangMin))
{
	echo "<option value='".$donnees['id_rang']."'>".utf8_encode($donnees['liste_rang'])."</option>";
}
?>
				</select>
			<br/>                                 
                <a href="liste-bases-tout-rang.php" class="select" title="Showing classified bases by rank">
				<img src="charte/images/fond-rang.jpg" style="border:none; margin-top:10px; " />
				</a>
			</div>


			<div class="categorie-gauche" style="color: #996600;">
				by fossil/extant<br/>
				<select name="fossile_actuel" class="form-select" style="color: #996600;" >
        			<option value="?"></option>
<?php
while ($donnees =  mysqli_fetch_array($listeFossileActuel))
{
	echo "<option value='".$donnees['id_fossile_actuel']."'>".utf8_encode($donnees['fossile_actuel'])."</option>";
}
?>
				</select>
            
		         <br/>
 <a href="liste-bases-tout-fossile.php" class="select" title="Showing classified bases by fossil / extant">
        			<img src="charte/images/fond-fossile.jpg" style="border:none; margin-top:10px;"/>
        			</a>
			</div>		
            	<br/>
		<div class="bouton_recherche">
             		<input type="image" src="charte/images/puces/bouton-recherche.png"/>
             	</div>
		<br/><br/>
            </form>

	</div>
           

</div>

</body>
</html>
