|
EMBRY-RIDDLE
AERONAUTICAL UNIVERSITY - PRESCOTT, ARIZONA CAMPUS - 800-888-3728
3700 Willow Creek Road
Prescott, AZ 86301
home | admissions | student life | financial
aid and scholarships | ERAU ROTC | Army ROTC | Air
Force ROTC | athletics | careers
contact Embry-Riddle Aeronautical
University | social
media | about Prescott
Arizona | photo gallery | upcoming events | courses | sitemap
©
2008 Embry-Riddle Aeronautical University - Prescott, Arizona Campus.
All rights reserved.
800-888-3
aviation
colleges, colleges of engineering, space physics-astrophysics-astronomy,
global security intelligence technology,
aerospace engineering colleges, aeronautical engineering colleges, electrical
engineering colleges, mechanical engineering colleges,
computer engineering colleges, computer science colleges, commercial
pilot training, pilot training schools,
airline pilot training schools, aviation weather meteorology colleges,
aviation crash investigation others
Web
site developed by Caddis Advertising, LLC.
|
\n");
//view press release if set
if ($strView == "release")
{
viewrelease($intReleaseID);
}
else // there is a lot of processing before this ends and the publicsearch div is closed
{
//if a search has occurred print search feedback
if ($booSearch=="true" && ($strKey != "" || $strCatg != "" || $intYear != ""))
{
print("
You searched on -- \n");
if ($intMonth!="")
{
print(" Month: \n");
switch($intMonth)
{
case "1":
print("January");
break;
case "2":
print("February");
break;
case "3":
print("March");
break;
case "4":
print("April");
break;
case "5":
print("May");
break;
case "6":
print("June");
break;
case "7":
print("July");
break;
case "8":
print("August");
break;
case "9":
print("September");
break;
case "10":
print("October");
break;
case "11":
print("November");
break;
case "12":
print("December");
break;
}
print(" \n");
}
if ($intYear!="")
print("Year: $intYear \n");
if ($strKey!="")
print("Keyword: " . stripslashes(stripslashes($strKey)) . " \n");
if ($strCatg!="")
print("Category: " . stripslashes(stripslashes($strCatg)) . " \n");
print(" \n");
}
//set start record to be used in SQL limit
$intStartrecord = (($intPage*$intPublicpagesize)-($intPublicpagesize));
//build SQL query to get number of records only
$SQLstmt ="SELECT COUNT(*) FROM prpressrelease WHERE recordstatus = 'Active'";
if ($strKey != "")
{
$SQLstmt .= " AND (" .
"heading LIKE '%$strKey%' OR " .
"summary LIKE '%$strKey%' OR " .
"releasebody LIKE '%$strKey%')";
}
if ($intYear != "")
{
$SQLstmt .= " AND YEAR(pubdate) = $intYear";
if ($intMonth!="")
{
$SQLstmt .= " AND MONTH(pubdate) = $intMonth";
}
}
if ($strCatg != "") {
$SQLstmt .= " AND (category = '$strCatg')";
}
if ($strDisplay == "" && ($strKey == "" && $strCatg == "" && $intYear == ""))
$SQLstmt .= " LIMIT $numlatestreleases";
if ($setdebug=="ON")
print ("$SQLstmt \n");
//execute query to record count
$resultSet = dbaction($SQLstmt);
$row = getrsrow($resultSet);
$intTotalrecords = $row[0];
// if records exists display them otherwise display no records found message
$intTotalpages = 0;
if ($intTotalrecords > 0) {
//build query to get actual records
$SQLstmt ="SELECT releaseID, pubdate, heading, summary, category FROM prpressrelease";
$SQLstmt .= " WHERE recordstatus = 'Active'";
// if keyword is set then append search query
if ($strKey != "") {
$SQLmid = " AND (" .
"heading LIKE '%$strKey%' OR " .
"summary LIKE '%$strKey%' OR " .
"releasebody LIKE '%$strKey%')";
$SQLstmt .= $SQLmid;
}
if ($intYear != "")
{
$SQLstmt .= " AND YEAR(pubdate) = $intYear";
if ($intMonth != "")
{
$SQLstmt .= " AND MONTH(pubdate) = $intMonth";
}
}
if ($strCatg != "") {
$SQLstmt .= " AND (category = '$strCatg')";
}
if ($strDisplay == "" && ($strKey == "" && $strCatg == "" && $intYear == ""))
{
//limit to latest releases by default
$SQLstmt .= " ORDER BY pubdate DESC LIMIT $numlatestreleases";
}
else
{
$SQLstmt .= " ORDER BY pubdate DESC LIMIT $intStartrecord,$intPublicpagesize";
}
if ($setdebug == "ON")
print ("$SQLstmt \n");
$resultSet = dbaction($SQLstmt);
//calculate total number of pages
if (fmod($intTotalrecords,$intPublicpagesize)==0)
$intTotalpages = $intTotalrecords/$intPublicpagesize;
else
$intTotalpages = floor($intTotalrecords/$intPublicpagesize)+1;
if ($setdebug == "ON")
{
print("\n");
print("Total records: $intTotalrecords ");
print("Number of pages: $intTotalpages ");
print("Page size: $intPublicpagesize ");
print("Chapter size: $intPublicchaptersize ");
}
//calculate current chapter based on current page
if (!fmod($intPage,$intChaptersize)==0)
$intChapter = floor($intPage/$intChaptersize)+1;
else
$intChapter = ($intPage/$intChaptersize);
if ($setdebug == "ON")
{
print("Chapter: $intChapter
");
print(" \n");
}
//print results status if a search has occured
if ($strDisplay == "all" || ($strKey !="" || $strCatg !="" || $intYear !=""))
{
print("\n");
if ($intTotalrecords == 1) {
print("1 match found.");
}
else
{
print("$intTotalrecords matches found. Displaying matches " . ($intStartrecord+1) . "-");
if (($intPublicpagesize*$intPage) < $intTotalrecords)
print($intPublicpagesize*$intPage);
else
print($intTotalrecords);
}
print(" \n");
}
//print records
print("\n");
while($row = getrsrow($resultSet))
{
print(" \n");
if ($row["pubdate"] != "")
{
$strTempdate = strtotime($row["pubdate"]);
$strTempdate = date("F jS, Y",$strTempdate);
print("$strTempdate
\n");
}
if ($row["heading"] != "")
print("" . $row["heading"] . "
\n");
if ($row["summary"] != "")
{
print("" . $row["summary"] . " ");
}
readmorelink($row["releaseID"]);
if ($row["summary"] != "")
print("");
print(" \n");
}
print(" \n");
print(" No matches found \n");
print(" \n");
print(" \n");
//display previous chapter link if appropriate
if ($intChapter > 1)
{
print("| Prev $intPublicchaptersize pages | ");
}
//display page links
$intStartat = (($intChapter*$intPublicchaptersize) - ($intPublicchaptersize - 1));
if ($intTotalpages < ($intChapter*$intPublicchaptersize))
$intFinishat = $intTotalpages;
else
$intFinishat = ($intChapter*$intPublicchaptersize);
for($x=$intStartat;$x<=$intFinishat;$x++)
{
print(" ");
if ($x!=$intPage)
{
print("$x");
}
else
{
print("$x");;
}
print(" | \n");
}
//display next chapter link if appropriate
if (($intChapter * $intPublicchaptersize) < $intTotalpages)
{
print(" Next $intPublicchaptersize pages | ");
}
print(" \n");
print(" \n");
print(" Search press releases \n");
print(" \n");
print("\n");
print(" \n");
print(" \n");
print(" \n");
print(" \n");
print(" ![](\"../images/rss.gif\") | \n");
print(" | \n");
print(" view all | \n");
print(" | \n");
print(" \n");
if ($showarchivelinks == "ON")
{
archivelinks();
}
print(" | \n");
print(" \n");
print(" \n");
print(" $SQLstmt \n");
}
backlink();
print("\n");
$resultSet = dbaction($SQLstmt);
$row = getrsrow($resultSet);
if ($row["pubdate"] != "")
$strTempdate = strtotime($row["pubdate"]);
$strTempdate = date("F jS, Y",$strTempdate);
print(" $strTempdate \n");
if ($row["heading"] != "")
print(" " . $row['heading'] . " \n");
if ($row["summary"] != "")
print(" " . $row['summary'] . " \n");
if ($row["releasebody"] != "")
print(" " . $row['releasebody'] . " \n");
if ($row["relatedlinks"] != "")
{
print(" \n");
}
if ($row["relatedfiles"] != "")
{
print(" \n");
}
print(" |
 |
| |
| |
| |
| |
| |
 |
|
 |
|
EMBRY-RIDDLE
AERONAUTICAL UNIVERSITY - PRESCOTT, ARIZONA CAMPUS - 800-888-3728
3700 Willow Creek Road
Prescott, AZ 86301
home | admissions
| student life | financial
aid and scholarships | ERAU ROTC
| Army ROTC | Air
Force ROTC | athletics
| careers
contact Embry-Riddle Aeronautical
University | social
media | about Prescott
Arizona | photo gallery
| upcoming events |
courses | sitemap
©
2008 Embry-Riddle Aeronautical University - Prescott, Arizona Campus.
All rights reserved.
800-888-3
aviation
colleges, colleges of engineering, space physics-astrophysics-astronomy,
global security intelligence technology,
aerospace engineering colleges, aeronautical engineering colleges, electrical
engineering colleges, mechanical engineering colleges,
computer engineering colleges, computer science colleges, commercial
pilot training, pilot training schools,
airline pilot training schools, aviation weather meteorology colleges,
aviation crash investigation others
Web
site developed by Caddis Advertising, LLC.
|
