" target="_blank"> |
Main Menu |
|
| Logout. |
 |
 |
|
 |
';
$sql = "SELECT ID_DNA FROM dnabanknumbers WHERE Block_General = '0'";
$result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql)) { $countdna = mysqli_num_rows($result); }
$sqltaxa = "SELECT ID_TaxonIdentified FROM cachetaxonidentified LEFT JOIN dnabanknumbers ON cachetaxonidentified.FK_Cache = dnabanknumbers.FK_Cache WHERE dnabanknumbers.Block_General = '0' GROUP BY cachetaxonidentified.NameAuthorYear";
$resulttaxa = mysqli_query($GLOBALS["___mysqli_ston"], $sqltaxa);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sqltaxa)) { $counttaxa = mysqli_num_rows($resulttaxa); }
echo "| Summary | ";
echo "| Total DNA samples | ".$countdna." | ";
echo "| Total Taxa with DNA | ".$counttaxa." |
| ";
}
if (isset($_SESSION['project']) || $_SESSION['project']) {
echo '
 |
|
|
 |
|
|
';
$sql = "SELECT ID_DNA FROM dnabanknumbers WHERE ((Created_Who != '".$log."' AND Block_General = '0') OR Created_Who = '".$log."')";
$result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql)) { $countdna = mysqli_num_rows($result);}
$sqltaxa = "SELECT ID_TaxonIdentified FROM cachetaxonidentified LEFT JOIN dnabanknumbers ON cachetaxonidentified.FK_Cache = dnabanknumbers.FK_Cache WHERE ((dnabanknumbers.Created_Who != '".$log."' AND dnabanknumbers.Block_General = '0') OR dnabanknumbers.Created_Who = '".$log."') GROUP BY cachetaxonidentified.NameAuthorYear";
$resulttaxa = mysqli_query($GLOBALS["___mysqli_ston"], $sqltaxa);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sqltaxa)) { $counttaxa = mysqli_num_rows($resulttaxa);}
echo "| Summary | ";
echo "| Total DNA samples | ".$countdna." | ";
echo "| Total Taxa with DNA | ".$counttaxa." |
| ";
}
if (isset($_SESSION['management']) || $_SESSION['management'] || isset($_SESSION['admin']) || $_SESSION['admin']) { ?>
|
|
|
 |
|
|
|
|
| Summary | ";
echo "| Total DNA samples | ".$countdna." | ";
echo "| Total Taxa with DNA | ".$counttaxa." |
| ";
} ?>
|