"; if($pNum!="") $query = 'SELECT * FROM PHCBurialPermits WHERE docPermitNum = "'.$pNum.'";'; else if($lNum!="") $query = 'SELECT * FROM PHCBurialPermits WHERE lotNum = "'.$lNum.'";'; else if($dLName!="") $query = 'SELECT * FROM PHCBurialPermits WHERE deceasedLName = "'.$dLName.'";'; else $query = 'SELECT * FROM PHCBurialPermits WHERE deceasedLName != "none";'; $result = mysqli_query($db,$query) or die('Query failed: ' . mysqli_error($db)); $numRows = mysqli_num_rows($result); if($dLName=="" && $pNum=="" && $lNum==""){ $randChoice = rand(0, $numRows); for($i=0;$i<$randChoice;$i++) $line = mysqli_fetch_array($result, MYSQLI_ASSOC); extract($line); $matchingRecords = Array($deceasedFName, $deceasedMName, $deceasedLName, $dateBuried, $permitNum); } else { while($line = mysqli_fetch_array($result, MYSQLI_ASSOC)){ extract($line); //echo "Adding record: ".$deceasedFName.",".$deceasedMName.",".$deceasedLName.",".$dateBuried.",".$permitNum."
"; $oneRecord = Array($deceasedFName, $deceasedMName, $deceasedLName, $dateBuried, $permitNum); $matchingRecords[] = $oneRecord; } } /* for($i=0;$i"; */ return $matchingRecords; } // ************** GATHER DISPLAY DATA ***************************************** function gatherDisplayData($dLName, $pNum, $lNum, $BPNum, $db){ //echo "Entering gather data with values: ".$dLName.",".$pNum.",".$lNum.",".$BPNum."
"; if($pNum!="") $query = 'SELECT * FROM PHCBurialPermits WHERE docPermitNum = "'.$pNum.'";'; else if($lNum!="") $query = 'SELECT * FROM PHCBurialPermits WHERE lotNum = "'.$lNum.'";'; else if($dLName!="") $query = 'SELECT * FROM PHCBurialPermits WHERE deceasedLName = "'.$dLName.'";'; else if($BPNum!="") $query = 'SELECT * FROM PHCBurialPermits WHERE permitNum = "'.$BPNum.'";'; else $query = 'SELECT * FROM PHCBurialPermits WHERE deceasedLName != "none";'; $result = mysqli_query($db,$query) or die('Query failed: ' . mysqli_error($db)); $numRows = mysqli_num_rows($result); //echo "Gather data shows ".$numRows." records from query.

"; $randChoice = ""; if($dLName=="" && $pNum=="" && $lNum==""){ $numRows = mysqli_num_rows($result); $randChoice = rand(0, $numRows-1); //to account for case where randrange returns 0 $line = mysqli_fetch_array($result, MYSQLI_ASSOC); for($i=0;$i<$randChoice;$i++) $line = mysqli_fetch_array($result, MYSQLI_ASSOC); } else $line = mysqli_fetch_array($result, MYSQLI_ASSOC); extract($line); //echo "Chosen record: ".$deceasedFName.",".$deceasedMName.",".$deceasedLName.",".$dateBuried.",".$permitNum."
"; //echo "With randcomChoice of ".$randChoice."
"; /* echo 'Permit Number (format BP00000x): #'.$permitNum.'#
'; echo 'Doc Permit Number (as given): '.$docPermitNum.'
'; echo 'Date Deceased (as given): '.$dateDeceased.'
'; echo 'Date Buried (as given): '.$dateBuried.'
'; echo 'Time Buried (as given): '.$timeBuried.'
'; echo 'Deceased Prefix (like Sir): '.$deceasedPrefix.'
'; echo 'Deceased First Name (or letter): '.$deceasedFName.'
'; echo 'Deceased Middle Name (or letter) '.$deceasedMName.'
'; echo 'Deceased Last Name: '.$deceasedLName.'
'; echo 'Deceased Postfix (like Jr. or MD): '.$deceasedPostfix.'
'; echo 'Deceased Address: '.$deceasedAddress.'
'; echo 'Deceased Age: '.$deceasedAge.'
'; echo 'Cause of Death: '.$causeOfDeath.'
'; echo 'Family Name: '.$familyName.'
'; echo 'Family Address: '.$familyAddress.'
'; echo 'Family Other: '.$familyOther.'
'; echo 'Section Number (as given): '.$secNum.'
'; echo 'Lot Number (as given): '.$lotNum.'
'; echo 'Grave Number/Part of Lot (as given): '.$graveNum.'
'; echo 'Undertaker: '.$undertaker.'
'; echo 'Interment Fee (as given): '.$intermentFee.'
'; echo 'Marker Photo Filename: '.$markerPhotoFile.'
'; echo 'Permit Photo Filename: '.$permitPhotoFile.'
'; echo 'Record Status: '.$recordStatus.'
'; echo 'Remarks: '.$remarks.'
'; echo "

"; */ if($permitPhotoFile!="") $dispPermitFile = "permitFiles/".$permitPhotoFile; $dispLName = $deceasedLName; $dispMName = $deceasedMName; $dispFName = $deceasedFName; $dispLotNum = $lotNum; $dispBurYear = substr($dateDeceased,strlen($dateDeceased)-4); //echo "Buried year is ".$dispBurYear."
"; $query = 'SELECT * FROM PHCGenealogies WHERE LName = "'.$dispLName.'" && BurLot = "'.$dispLotNum.'" && BurYear = "'.$dispBurYear.'";'; $result = mysqli_query($db,$query) or die('Query failed: ' . mysqli_error($db)); $line = mysqli_fetch_array($result, MYSQLI_ASSOC); extract($line); /* echo 'generated GenCode: '.$tentGenCode.'
'; echo 'GenCode: '.$GenCode.'
'; echo 'Last Name: '.$LName.'
'; echo 'First Name: '.$FName.'
'; echo 'Middle Names: '.$MNames.'
'; echo 'Buried Day: '.$BurDay.'
'; echo 'Buried Month: '.$BurMnth.'
'; echo 'Buried Year: '.$BurYear.'
'; echo 'Buried Age: '.$BurAge.'
'; echo 'Buried Lot: '.$BurLot.'
'; echo 'History File Name: '.$HistFileName.'
'; echo 'Record Status: '.$recordStatus.'
'; echo 'Geneology Notes: '.$GenNotes.'

'; */ if($LName!=""){ $dispGenNotes = $LName.", ".$FName." ".$MNames."
Buried: ".$BurDay." ".$BurMnth.", "; $dispGenNotes .= $BurYear."
Age at Interment: ".$BurAge."
Prospect Hill Lot: ".$BurLot."
"; $dispGenNotes .= $GenNotes; } else $dispGenNotes = ""; if($HistFileName!="") $dispHistFileName = $HistFileName; else $dispHistFileName = ""; /* echo '

Burial Permit file
'; */ $retData = Array($dispPermitFile, $dispLName, $dispMName, $dispFName, $dispLotNum, $dispGenNotes, $dispHistFileName); return $retData; } // ************** PRINT INITIAL FORM *********************************************** function print_form(){ PHCfrontStuff(); //echo '
'; echo ''; echo ''; echo <<
Prospect Hill Cemetery

Burial Permit Lookup
Application

No Lookup Information Entered Yet
Look Up Burial Permits (fill at least one box):




OR,
Prospect Hill Cemetery

Permit Image

No Lookup Information Entered Yet
Prospect Hill Cemetery

Geneaology Data

No Lookup Information Entered Yet
Prospect Hill Cemetery

History Data

No Lookup Information Entered Yet
END; PHCbackStuff(); } // ************** PROCESS LOOKUP ********************************************** function processLookup($db){ PHCfrontStuff(); echo <<
Prospect Hill Cemetery
END; //echo "The looked up data would be displayed. Still under construction."; //PHCbackStuff(); //return; //get data, in format: Array($dispPermitFile[0], $dispLName[1], $dispMName[2], $dispFName[3], $dispLotNum[4], $dispGenNotes[5], $dispHistFileName[6]); if (isset($_POST['stage']) && ($_POST['LName']!="LastName" || $_POST['PNum']!="PermitNum" || $_POST['LNum']!="LotNumber")){ if($_POST['LName']=="" || $_POST['LName']=="LastName") $searchLast = ""; else $searchLast = $_POST['LName']; if($_POST['PNum']=="" || $_POST['PNum']=="PermitNum") $searchPermit = ""; else $searchPermit = $_POST['PNum']; if($_POST['LNum']=="" || $_POST['LNum']=="LotNumber") $searchLot = ""; else $searchLot = $_POST['LNum']; $dataArray = gatherDisplayData($searchLast, $searchPermit, $searchLot,"",$db); $searchArray = searchData($searchLast, $searchPermit, $searchLot, $db); } else if (isset($_GET['BP']) && $_GET['BP']!="") $dataArray = gatherDisplayData("", "", "",$_GET['BP'],$db); else $dataArray = gatherDisplayData("", "", "","",$db); echo ''; echo ''; //Note matching results in form: Array($deceasedFName, $deceasedMName, $deceasedLName, $dateDeceased, $permitNum); if(count($searchArray)>=1){ //echo "Your search produced ".count($searchArray)." record.
"; echo "
"; echo "Click on the record to display any available information.
"; echo ''; } if(count($searchArray)==0 && !isset($_GET['BP'])){ echo <<
No records found.
Please try again with
different search terms. END; } if(count($searchArray)==0 && isset($_GET['BP'])){ echo <<
Information provided below. END; } else { echo <<
Currently featuring:
END; echo $dataArray[1].", ".$dataArray[3]." ".$dataArray[2]; } echo <<

Burial Permit Information

END; if($dataArray[0]!="") echo 'Sample Burial Permit'; else echo "No burial permit image available
at this time.
Please check back later!
"; echo <<

For more information
contact info@prospecthill-omaha.org

Prospect Hill Cemetery

Genealogical Information*

END; if($dataArray[5]!="") echo $dataArray[5]; else{ echo "No Genealogical Information
Do you have information about
"; echo $dataArray[3]." ".$dataArray[2]." ".$dataArray[1]."?
"; echo "If so, please contact the email address below."; } echo <<

*from Omaha's Historic Prospect Hill Cemetery
by Baumann, Martin, and Simpson.
For more information, or to purchase a copy,
contact info@prospecthill-omaha.org

Prospect Hill Cemetery

Historical Research Information

END; //get data, in format: Array($dispPermitFile[0], $dispLName[1], $dispMName[2], $dispFName[3], $dispLotNum[4], $dispGenNotes[5], $dispHistFileName[6]); if($dataArray[6]!="") { echo "Historical Notes* for
"; echo $dataArray[3]." ".$dataArray[2]." ".$dataArray[1]."
"; $inFile = fopen("historyFiles/".$dataArray[6], "r"); if($inFile){ while (!feof($inFile)) { $buffer = fgets($inFile, 4096); echo $buffer; } } echo "
*from Omaha's Historic Prospect Hill Cemetery
"; echo "by Baumann, Martin, and Simpson.
"; echo "For more information, or to purchase a copy,
"; echo "please contact the email address below."; } else{ echo "No Historical Information Available*
Do you have information about
"; echo $dataArray[3]." ".$dataArray[2]." ".$dataArray[1]."?
"; echo "If so, please contact the email address below."; } echo "
"; PHCbackStuff(); } // ************** PROCESS DATA *********************************************** function processData(){ if($_POST['Description']==""){ die("No description entered.
Go back and try again."); } echo "Would be processing data now.
"; echo "With Description: ".$_POST['Description']."
"; echo "With Lot: ".$_POST['Lot']."
"; echo "With Latitude: ".$_POST['Latitude']."
"; echo "With Longitude: ".$_POST['Longitude']."
"; echo "With Accuracy: ".$_POST['Accuracy']."
"; $t=time(); echo "With Timestamp: ".$t."
"; //insert everything into database $string1 = "INSERT INTO Geolocations(Latitude,Longitude,Accuracy,Timestamp,Description,Lot) VALUES('"; $string2 = $_POST['Latitude']."','"; //Latitude $string3 = $_POST['Longitude']."','"; //Longitude $string4 = $_POST['Accuracy']."','"; //Accuracy $string5 = $t."','"; //Timestamp made above $string6 = $_POST['Description']."','"; //Description $string7 = $_POST['Lot']."'"; //Lot $string99 = ");"; $query = $string1.$string2.$string3.$string4.$string5.$string6.$string7.$string99; $result = mysqli_query($db,$query) or die('Query failed: ' . mysqli_error($db)); //echo "Would have loaded one Geolocation with ".$query."
"; echo "Geolocation saved in database.
Here's what's in so far:
"; $string1 = "SELECT * FROM Geolocations;"; #$string99 = "WHERE netID='".$stuNetID."' AND athlete='N';"; #$query10 = $string1.$string99; $query10 = $string1; $result10 = mysqli_query($db,$query10) or die('Query failed: ' . mysqli_error($db)); #$numRows = mysqli_num_rows($result10); echo ""; while($geoLoc = mysqli_fetch_array($result10, MYSQLI_ASSOC)){ extract($geoLoc); echo ""; echo ""; } echo "
$Latitude$Longitude$Accuracy
$Description$Lot
"; } ?>