num_rows==0) return 'unknown'; // mysqli seek to the row of the given dataset $result->data_seek($row); // mysqli assign the rows data to an array $row_result=$result->fetch_assoc(); // assign field of the row to the return variable $field_result=$row_result[$field]; // done, return result return $field_result; } // End Function Definitions //====================================================== //====================================================== // Host Determination Section // test for the existance of a small text file to determine whether // or not your on the local machine (where the file IS), or on the // remote site (where the file IS NOT). This test chooses the correct // database login info file. $info_test_file ="../../php/info_test.txt" ; // set indiicator for whether we are on local or remote machine $in_local_dir = 0 ; if (file_exists($info_test_file)) { include("../../php/dbinfo_dbf.inc.php"); $in_local_dir = 1 ; echo "File test does exist" ; echo "

" ; } else { include("../../php/dbinfo_addr.inc.php"); $in_local_dir = 0 ; //echo "File test does NOT exist" ; } ; // End Host Determination Section //============================================= //============================================= // Database MySqli Connection Section // this database connection needs to be copied $db_eatc7402 = new mysqli($DBHost, $DBUser, $DBPass); if($db_eatc7402->connect_errno > 0){ die(' Unable to connect to MYSQLI database [' . $db_eatc7402->connect_error . ']

'); } else { if ($DEBUG3 == "on") echo "Connected to MYSQLI server successfully

" ; } // end if connect error /* change db to eatc7402 db */ if($db_eatc7402->select_db($DBName) > 0){ if ($DEBUG3 == "on") echo " Connected to MYSQLI database name successfully

" ; } else { die(' Unable to connect to MYSQLI database name [' . $db_eatc7402->connect_error . ']

'); } // end if debug // End Database Connection Section //=========================================================== //=========================================================== // Run Query Section // // NOTE; DO NOT TEST FOR 'True' or 'False' flagd, use 0 or 1 // true or false wil work on local server but will FAIL // when used on the ADDR unix machine!!! USE 1 or 0 // determine the directory we are operating in to // determine the query to run and many other location // sopecific variables in the code // get the current directory $working_dir = getcwd() ; //echo $working_dir ; //echo "
" ; // set var to null to initiate $directory_in_use = "" ; // determine which dir are in and set $directory_in_use to indicate if ($in_local_dir) { if ($pos = strripos($working_dir, 'data_templates')) { //echo "We found the ('data_templates') in ($working_dir) at position ($pos)"; //echo "
" ; $directory_in_use = "data_templates" ; } if ($pos = strripos($working_dir, 'St_Paul')) { //echo "We found the ('St_Paul') in ($working_dir) at position ($pos)"; //echo "
" ; $directory_in_use = "st_paul" ; } if ($pos = strripos($working_dir, 'Minneapolis')) { //echo "We found the ('Minneapolis') in ($working_dir) at position ($pos)"; //echo "
" ; $directory_in_use = "minneapolis" ; } } else { if ($pos = strripos($working_dir, 'data_templates')) { //echo "We found the last ('station_templates') in ($working_dir) at position ($pos)"; //echo "
" ; $directory_in_use = "data_templates" ; } if ($pos = strripos($working_dir, 'St_Paul')) { //echo "We found the ('St_Paul') in ($working_dir) at position ($pos)"; //echo "
" ; $directory_in_use = "st_paul" ; } if ($pos = strripos($working_dir, 'Minneapolis')) { //echo "We found the ('Minneapolis') in ($working_dir) at position ($pos)"; //echo "
" ; $directory_in_use = "minneapolis" ; } } // for debug //echo "Directory in use is $directory_in_use " ; //echo "

" ; // for debug //$directory_in_use = "data_templates" ; //$directory_in_use = "st_paul" ; //$directory_in_use = "minneapolis" ; //============================================ switch ($directory_in_use) { case "data_templates" : $query= "SELECT * FROM stp_motor_app_table_addr stp_motor_app_table_addr WHERE (stp_motor_app_table_addr.ID_pic IS NOT NULL) ORDER BY stp_motor_app_table_addr.ID_pic ASC" ; echo "
" ; // do not comment out this break!!! break ; case "st_paul" : $query= "SELECT * FROM stp_motor_app_table_addr stp_motor_app_table_addr WHERE (stp_motor_app_table_addr.ID_pic IS NOT NULL) ORDER BY stp_motor_app_table_addr.ID_pic ASC" ; echo "
" ; // do not comment out this break!!! break ; case "minneapolis" : $query= "SELECT * FROM mfd_motor_app_table_addr mfd_motor_app_table_addr WHERE (mfd_motor_app_table_addr.ID_pic IS NOT NULL) ORDER BY mfd_motor_app_table_addr.ID_pic ASC, mfd_motor_app_table_addr.Sort_assign_order ASC" ; echo "
" ; // do not comment out this break!!! break ; } //================================================ //echo "The query you generated:
$query
" ; //echo "

" ; // run the query ==========++++++++++ // ------------------------------------------------------- /* Select queries return a resultset */ if ($result = $db_eatc7402->query($query)) { $num_of_rows = $result->num_rows ; if ($DEBUG3 == 'on') { echo "Select MYSQLI query returned $num_of_rows rows.

" ; } } // Check result // This shows the actual query sent to MySQL, and the error. Useful for debugging. if ($DEBUG3 == 'on') { if (!$result) { $message = 'Invalid query!!:
' . mysqli_error($db_eatc7402) . '
'; $message .= 'Whole query: ' . $query; die($message); } } $num = $num_of_rows ; // phpinfo() ; if (is_null($num)) { $num = "0"; } ; //echo "Your query returned $num rows"; //echo "

"; // End Run Query Section //========================================================= //============================================================ // the loop for processing the query results $i=0; $ID=db_result($result,$i,"ID"); $UniqueID=db_result($result,$i,"UniqueID"); $Station_ID_Text=db_result($result,$i,"Station_ID_Text"); $Unique_Pic_Numt=db_result($result,$i,"Unique_Pic_Num"); $ID_pic=db_result($result,$i,"ID_pic"); $ID_pic2=db_result($result,$i,"ID_pic2"); $ID_pic3=db_result($result,$i,"ID_pic3"); $adnl_index=db_result($result,$i,"adnl_index"); $Full_Size_filename_HTM=db_result($result,$i,"Full_Size_filename_HTM"); $Status_Station=db_result($result,$i,"Status_Station"); $Year=db_result($result,$i,"Year"); $Make=db_result($result,$i,"Make"); $Cab=db_result($result,$i,"Cab"); $GPM=db_result($result,$i,"GPM"); $Tnk=db_result($result,$i,"Tnk"); $Aer=db_result($result,$i,"Aer"); $Type=db_result($result,$i,"Type"); $Serial=db_result($result,$i,"Serial"); $Miscellaneous=db_result($result,$i,"Miscellaneous"); $Shop=db_result($result,$i,"Shop"); $Assignment=db_result($result,$i,"Assignment"); $City_Name=db_result($result,$i,"City Name"); $AddnlPictureFileName=db_result($result,$i,"AddnlPictureFileName"); $AddnlPictureTille=db_result($result,$i,"AddnlPictureTille"); $Unique_Pic_Num=db_result($result,$i,"Unique_Pic_Num"); $RigViz=db_result($result,$i,"RigViz"); $Title_body=db_result($result,$i,"Title_body"); $Title_exten1=db_result($result,$i,"Title_exten1"); $AddnlPicBlockText=db_result($result,$i,"AddnlPicBlockText"); $GraphicsDir=db_result($result,$i,"GraphicsDir"); $PictureAuthor=db_result($result,$i,"PictureAuthor"); $Assinged_To=db_result($result,$i,"Assinged_To"); ?>
    

Index sheet of Motorized Fire Apparatus

Clicking on a photo thumbnail will get you a larger image of JUST the photo.
Clicking on the TITLE will take to a larger image on the full station page, with much more information.

Photos appear sorted by delivery year, apparatus ID number, then by assignment order
if photos of more than one apparatus of same ID is present.

There are entries listed today:

Comments or Questions?  Visit Our USERS FORUM

     


Photo source:


Photo source: Unknown

 




There are entries listed today:

Comments or Questions?  Visit Our USERS FORUM



Valid XHTML 1.0 Transitional


Copyright © 1996- The Extra Alarm Association
of The Twin Cities, Inc.
All Rights Reserved
Last Modified
Edited and maintained by D.B. Freedman
mailto: eaatc.web@gmail.com

-- [HOME] --