';
If ($thumbid) {
try {
$stmt2 = $pdo_wfp->prepare('SELECT * FROM photos WHERE id=?');
$stmt2->execute([$thumbid]);
} catch(\PDOException $e){
echo "Error connecting to mysql: ". $e->getMessage();
}
$row2 = $stmt2->fetch();
if ($stmt2->rowCount() > 0) {
echo '
'; // masonry
// find sub-members of top level taxon -
// previous groups page put all sublevels in an array (for displaying multiple levels)
If ($sciname == "No Taxon") {
echo '';
$thispath = $row2['path'];
$caption = $row2['caption'];
$filename = $row2['filename'];
$phnote = $row2['notes'];
$phloc = $row2['location'];
if ($row2['phdate'] == "0000-00-00") {
$phdate ="";
} else {
$time = strtotime($row2['phdate']);
$phdate = date("m/d/y", $time);
}
if ($thispath == "") {
$phpath = "/p46867";
} else {
$phpath = "/psubs/".$thispath."";
}
// get id, genus & species name for top photo
$sid = $row2['fromid'];
$st = $row2['fromtable'];
if ($st != "na") {
try {
$stmt3 = $pdo_wfp->prepare('SELECT sciname, comname, upname FROM '.$st.' WHERE id = ?');
$stmt3->execute([$sid]);
} catch(\PDOException $e){
echo "Error connecting to mysql: ". $e->getMessage();
}
$row3 = $stmt3->fetch();
$genus = $row3['upname'];
$species = $row3['sciname'];
$spcom = ucwords(strtolower($row3['comname']));
$stmt3->closeCursor();
// end get species name for top thumbnail
$thiscaption = ''.$genus.' '.$species.' - '.ucfirst(strtolower($spcom)).' - '.$caption.'';
} else {
$thiscaption = $caption;
}
$thisphoto = $phpath."/".$filename.".jpg";
echo '';
echo '
';
if ($st != "na") {
echo ''.$genus.' '.$species.'
'.$spcom.'
'; } echo $caption; echo '
'; // brick/
}
$stmt2->closeCursor();
} // end if thumbid
// top level caption
echo ''.$spcom.'
'; } echo $caption; echo '
';
if ($topcap == "") {
echo '
'; // brick/
// top level note
echo ''.$phnote.'
'; } else { echo ''.$topcap.'
'; } echo '';
echo '
'; // brick/
echo ''.$topnote.'
'; echo ''.$comname.' at Wild Florida Photo
'; } else { echo 'Members of the '.$sciname.' '.(strtolower($level)).' at Wild Florida Photo
'; } try { $stmt1 = $pdo_wfp->prepare('SELECT * FROM '.$t.' WHERE uprec = '.$id.' ORDER BY sciname'); $stmt1->execute(); } catch(\PDOException $e){ echo "Error connecting to mysql: ". $e->getMessage(); } while ($row1 = $stmt1->fetch()) { $subid = $row1['id']; $subsci = htmlentities($row1['sciname']); $subcom = $row1['comname']; $subphoto = $row1['photoid']; $sublevel = $row1['level']; $subcap = $row1['caption']; $subnote = $row1['notes']; if ($sublevel == 'Family') { $sublink = "family.php?k=".$k."&id="; } else { $sublink = $slink; } if ($subcom) { $subname = $subsci." - ".$subcom; } else { $subname = $subsci; } echo ''; echo '';
// get sub prime photo
try {
$stmt4 = $pdo_wfp->prepare('SELECT * FROM photos WHERE id = ?');
$stmt4->execute([$subphoto]);
} catch(\PDOException $e){
echo "Error connecting to mysql: ". $e->getMessage();
}
$row4 = $stmt4->fetch();
if ($stmt4->rowCount() > 0) {
echo '
'; // masonry
} // while row1
echo '';
$thisid = $row4['id'];
$thispath = $row4['path'];
$caption = $row4['caption'];
$filename = $row4['filename'];
$phloc = $row4['location'];
if ($row4['phdate'] == "0000-00-00") {
$phdate ="";
} else {
$time = strtotime($row4['phdate']);
$phdate = date("m/d/y", $time);
}
if ($thispath == "") {
$phpath = "/p46867";
} else {
$phpath = "/psubs/".$thispath."";
}
// get id, genus & species name for sub photo
$subphid = $row4['fromid'];
$subt = $row4['fromtable'];
if ($subt != "na") {
try {
$stmt7 = $pdo_wfp->prepare('SELECT sciname, comname, upname FROM '.$subt.' WHERE id = ?');
$stmt7->execute([$subphid]);
} catch(\PDOException $e){
echo "Error connecting to mysql: ". $e->getMessage();
}
$row7 = $stmt7->fetch();
$subgenus = $row7['upname'];
$subspecies = $row7['sciname'];
$subcom = ucwords(strtolower($row7['comname']));
$stmt7->closeCursor();
// end get species name for sub thumbnail
$thiscaption = $subcom.' - '.$caption;
} else {
$thiscaption = $caption;
}
$thisphoto = $phpath."/".$filename.".jpg";
echo '';
echo '';
echo '
'; // brick/
// genus, species & photo caption here
echo '';
if ($subt != "na") {
echo ''.$subgenus.' '.$subspecies.'
'.$subcom.'
'; } echo '
'; // brick/
} // if $stmt4
$stmt4->closeCursor();
// sub text
echo ''.$subcom.'
'; } echo '
'.$caption.'
'; echo '';
$tease = substr ($subcap, 0, 144);
echo $tease;
echo ' ... more';
echo ''; // to fix tags broken in the middle of the string
echo '
'; // brick
echo ''; if ($id > 1) { // get next level up try { $stmt5 = $pdo_wfp->prepare('SELECT sciname, comname, level FROM '.$t.' WHERE id = '.$thisup.''); $stmt5->execute(); } catch(\PDOException $e){ echo "Error connecting to mysql: ". $e->getMessage(); } $row5 = $stmt5->fetch(); $upsci = $row5['sciname']; $upcom = $row5['comname']; $uplevel = $row5['level']; $upphoto = $row5['photoid']; echo '
'.$sciname.' is a member of the '.$upsci.' '; if ($upcom) { echo '- '.$upcom.' - '; } echo $uplevel.'
'; $stmt5->closeCursor(); echo ''; echo '
Other members of the '.$upsci.' '.strtolower($uplevel).'
'; echo '';
// get other members of next level up
try {
$stmt6 = $pdo_wfp->prepare('SELECT * FROM '.$t.' WHERE uprec = '.$thisup.' ORDER BY sciname');
$stmt6->execute();
} catch(\PDOException $e){
echo "Error connecting to mysql: ". $e->getMessage();
}
while ($row6 = $stmt6->fetch()) {
echo '
'; // masonry
}
$stmt1->closeCursor();
// Closing connection
$pdo_wfp = null;
echo '';
$sibid = $row6['id'];
$sibsci = $row6['sciname'];
if ($sibid <> $id) {
echo '';
}
echo '
'; // brick
}
$stmt5->closeCursor();
echo 'Click on any subject title or the "more" link to see additional information and photos
'; echo 'Note that this page is not a complete list and only includes what is posted on the Wild Florida Photo website.
'; echo 'Use the drop-down menu and buttons at the top of the page to select specific categories of subjects and the order to display them
'; echo 'Jump to top of page.'; echo ''; echo ''; tweet_btn(); echo '
'; echo '