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, 'station_templates')) { echo "We found the last ('station_templates') in ($working_dir) at position ($pos)"; echo "
" ; $directory_in_use = "station_templates" ; } if ($pos = strripos($working_dir, 'st_paul\active')) { echo "We found the last ('st_paul\active') in ($working_dir) at position ($pos)"; echo "
" ; $directory_in_use = "st_paul_active" ; } if ($pos = strripos($working_dir, 'st_paul\former')) { echo "We found the last ('st_paul\former') in ($working_dir) at position ($pos)"; echo "
" ; $directory_in_use = "st_paul_former" ; } if ($pos = strripos($working_dir, 'minneapolis\active')) { echo "We found the last ('minneapolis\active') in ($working_dir) at position ($pos)"; echo "
" ; $directory_in_use = "minneapolis_active" ; } if ($pos = strripos($working_dir, 'minneapolis\former')) { echo "We found the last ('minneapolis\former') in ($working_dir) at position ($pos)"; echo "
" ; $directory_in_use = "minneapolis_former" ; } } else { if ($pos = strripos($working_dir, 'station_templates')) { //echo "We found the last ('station_templates') in ($working_dir) at position ($pos)"; //echo "
" ; $directory_in_use = "station_templates" ; } if ($pos = strripos($working_dir, 'St_Paul/active')) { //echo "We found the last ('St_paul/active') in ($working_dir) at position ($pos)"; //echo "
" ; $directory_in_use = "st_paul_active" ; } if ($pos = strripos($working_dir, 'St_paul/former')) { //echo "We found the last ('St_paul/former') in ($working_dir) at position ($pos)"; //echo "
" ; $directory_in_use = "st_paul_former" ; } if ($pos = strripos($working_dir, 'Minneapolis/active')) { // echo "We found the last ('Minneapolis/active') in ($working_dir) at position ($pos)"; //echo "
" ; $directory_in_use = "minneapolis_active" ; } if ($pos = strripos($working_dir, 'Minneapolis/former')) { // echo "We found the last ('Minneapolis/former') in ($working_dir) at position ($pos)"; // echo "
" ; $directory_in_use = "minneapolis_former" ; } } // for debug //echo "Directory in use is $directory_in_use " ; //echo "

" ; // for debug //$directory_in_use = "st_paul_former" ; //$directory_in_use = "st_paul_active" ; //$directory_in_use = "minneapolis_active" ; //$directory_in_use = "minneapolis_former" ; //============================================ switch ($directory_in_use) { case "station_templates" : $query= "SELECT * FROM stp_stations_all stp_stations_all WHERE Status_Station = 'Current' ORDER BY stp_stations_all.Status_Station ASC, stp_stations_all.SortOrder ASC" ; echo "
" ; // do not comment out this break!!! break ; case "st_paul_active" : $query= "SELECT * FROM stp_stations_all stp_stations_all WHERE Status_Station = 'Current' ORDER BY stp_stations_all.Status_Station ASC, stp_stations_all.SortOrder ASC" ; echo "
" ; // do not comment out this break!!! break ; case "st_paul_former" : $query= "SELECT * FROM stp_stations_all stp_stations_all WHERE Status_Station = 'Former' ORDER BY stp_stations_all.Status_Station ASC, stp_stations_all.SortOrder ASC" ; echo "
" ; // do not comment out this break!!! break ; case "minneapolis_active" : $query= "SELECT * FROM mfd_stations_all mfd_stations_all WHERE Status_Station = 'current' ORDER BY mfd_stations_all.Status_Station ASC, mfd_stations_all.SortOrder ASC" ; echo "
" ; // do not comment out this break!!! break ; case "minneapolis_former" : $query= "SELECT * FROM mfd_stations_all mfd_stations_all WHERE Status_Station = 'former' ORDER BY mfd_stations_all.Status_Station ASC, mfd_stations_all.SortOrder 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 //========================================================= ?> Former <?echo Nz($City_Name," ");?> Fire Stations <?echo Nz($City_Name," ");?> Fire Stations
    

Fire Stations

Fire Stations


 
Click here for a complete linked list of our apparatus photos in our Station Section
Click here for a complete table of Apparatus, including photo links


Click on a station photo for a larger image and MORE information.
See immediately below for the types of additional information available.

  • Full size station picture
  • Status of the station's location
  • Date history of the station
  • Geographic direction the station faces, if the station is still standing
  • Station's current occupancy
  • Additional station photos
  • Links to other relevant information
  • Photos of apparatus that occupied the station (horse drawn and motorized) when available

  _stations_top"> _stations_top">
Fire Stations Master List: FORMER   STATIONS HOME

Comments or Questions?  Visit Our USERS FORUM
Fire Stations Master List: CURRENT      STATIONS HOME

Comments or Questions?  Visit Our USERS FORUM

Click here for a complete linked list of our apparatus photos in our Station Section
Click here for a complete table of Apparatus, including photo links


Click on a station photo for a larger image and MORE information.
See immediately below for the types of additional information available.

  • Full size station picture
  • Status of the station's location
  • Date history of the station
  • Geographic direction the station faces, if the station is still standing
  • Station's current occupancy
  • Additional station photos
  • Links to other relevant information
  • Photos of apparatus that occupied the station (horse drawn and motorized) when available

  _stations_top"> _stations_top">
Fire Stations Master List: FORMER   STATIONS HOME

Comments or Questions?  Visit Our USERS FORUM
Fire Stations Master List: CURRENT      STATIONS HOME

Comments or Questions?  Visit Our USERS FORUM




  Former Station Station  


Station is no longer standing Station Faces 






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

-- [HOME] --