';
//Section 6 contains the two flags html div start tag; two flags code; and two flags html div end tag
echo '
';
//Section 7 contains the welcome to key to the city html div start tag; welcome to key to the city html code; and welcome to key to the city html div end tag;
echo '
Welcome To KEY TO THE CITY's Page For
Coeur D'Alene
Kootenai County, Idaho,
';
//Section 8 contains the statistics and facts html div start tag; statistics and facts html code; and statistics and facts html div end tag;
echo '
Statistics & Facts
Coeur D'Alene Zip Codes
-
83814
Location
-
on Interstate 90 in the far northern portion of Idaho, near the Washington border, only 32 miles from Spokane, Washington.
Coeur D'Alene Mottos & Nicknames
-
Idaho's City with a Heart
Statistics
- The Idaho state capital is Boise.
- The population of Coeur D'Alene is approximately 32,200 (1998), 44137 (2010).
- The approximate number of families is 10,956 (1990), 18395 (2010).
- The amount of land area in Coeur D'Alene is 27.568 sq. kilometers.
- The amount of surface water is 1.159 sq kilometers.
- The distance from Coeur D'Alene to Washington DC is 2187 miles.
- The distance to the Idaho state capital is 283 miles. (as the crow flies)
- Coeur D'Alene is positioned 47.69 degrees north of the equator and 116.78 degrees west of the prime meridian.
- Coeur D'Alene elevation is 2,157 feet above sea level.
- Coeur D'Alene average annual rainfall is 26 inches per year
- Coeur D'Alene average annual precipitation is 26.75 inches peryear.
- The average summer temperature is 63.5 degrees F.
';
//Section 8a contains the local attractions sub section
echo
'
Local Attractions
Contribute Coeur D'Alene Local Attractions Information
';
// Section introductory text. Unique for this city-page and this section(1). //
$sql2 = "SELECT section_1_uniform_text FROM city_page_section_uniform_text";
$result2 = mysqli_query($conn, $sql2); //result is an array
$row2 = mysqli_fetch_assoc($result2); //Fetch all of the data
$token = strtok($row01["section1_note"], "");
while ($token !== false)// this loop fetches each subRecord(5 in this case) and sends it to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("'");
}
// Comment that is common to all sections
$token = strtok($row01["section_comt"], "");
while ($token !== false)// this loop fetches each sub Record and sends them to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("");
}
echo
'
';
//select and fetch the city-page section 8a data.
//
if (mysqli_num_rows($result_Sec8) > 0) { //check to see if any section data was fetched from the database for this city.
//Display Attractions Section(secton 8a) Data
//$row = mysqli_fetch_assoc($result_Sec8); //Fetch all of the data from the section form.
printf ("%s", $row01["records_sec1"]);
} else { //no section data was found in this cities section 8a.
echo "Section Information missing";
}
echo '
'.'';
//
echo '
Search for a different Key To The City page.
';
//Section 8b contains the it happened hear sub section
echo '
It Happened Here
Contribute Coeur D'Alene It Happened Here Information
';
// Section introductory text. Unique for this city-page and this section(2). //
$sql2 = "SELECT section_2_uniform_text FROM city_page_section_uniform_text";
$result2 = mysqli_query($conn, $sql2); //result is an array
$row2 = mysqli_fetch_assoc($result2); //Fetch all of the data
$token = strtok($row01["section2_note"], "");
while ($token !== false)// this loop fetches each subRecord(9 in this case) and sends it to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("'");
}
// Comment that is common to all sections
$token = strtok($row01["section_comt"], "");
while ($token !== false)// this loop fetches each sub Record and sends them to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("");
}
echo
'
';
//select and fetch the city-page section 8a data.
//
if (mysqli_num_rows($result_Sec8) > 0) { //check to see if any section data was fetched from the database for this city.
//Display Attractions Section(secton 8a) Data
//$row = mysqli_fetch_assoc($result_Sec8); //Fetch all of the data from the section form.
printf ("%s", $row01["records_sec2"]);
} else { //no section data was found in this cities section 8a.
echo "Section Information missing";
}
echo '
'.'';
//
echo '
Search for a different Key To The City page.
';
//Section 8c contains the noted notables sub section
echo '
NOTABLES
Contribute Coeur D'Alene Noted Notables Information
';
// Section introductory text. Unique for this city-page and this section(3). //
$sql2 = "SELECT section_3_uniform_text FROM city_page_section_uniform_text";
$result2 = mysqli_query($conn, $sql2); //result is an array
$row2 = mysqli_fetch_assoc($result2); //Fetch all of the data
$token = strtok($row01["section3_note"], "");
while ($token !== false)// this loop fetches each subRecord(5 in this case) and sends it to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("'");
}
// Comment that is common to all sections
$token = strtok($row01["section_comt"], "");
while ($token !== false)// this loop fetches each sub Record and sends them to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("");
}
echo
'
';
//select and fetch the city-page section 8a data.
//
if (mysqli_num_rows($result_Sec8) > 0) { //check to see if any section data was fetched from the database for this city.
//Display Attractions Section(secton 8a) Data
//$row = mysqli_fetch_assoc($result_Sec8); //Fetch all of the data from the section form.
printf ("%s", $row01["records_sec3"]);
} else { //no section data was found in this cities section 8a.
echo "Section Information missing";
}
echo '
'.'';
//
echo '
Search for a different CITY on our history site.
';
//Section 8d contains community news sub section
echo '
COMMUNITY NEWS
Contribute Coeur D'Alene Community News Information
';
// Section introductory text. Unique for this city-page and this section(4). //
$sql2 = "SELECT section_4_uniform_text FROM city_page_section_uniform_text";
$result2 = mysqli_query($conn, $sql2); //result is an array
$row2 = mysqli_fetch_assoc($result2); //Fetch all of the data
$token = strtok($row01["section4_note"], "");
while ($token !== false)// this loop fetches each subRecord(5 in this case) and sends it to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("'");
}
// Comment that is common to all sections
$token = strtok($row01["section_comt"], "");
while ($token !== false)// this loop fetches each sub Record and sends them to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("");
}
echo
'
';
//select and fetch the city-page section 8a data.
//
if (mysqli_num_rows($result_Sec8) > 0) { //check to see if any section data was fetched from the database for this city.
//Display Attractions Section(secton 8a) Data
//$row = mysqli_fetch_assoc($result_Sec8); //Fetch all of the data from the section form.
printf ("%s", $row01["records_sec4"]);
} else { //no section data was found in this cities section 8a.
echo "Section Information missing";
}
echo '
'.'';
//
echo '
Search for a different CITY on our history site.
';
//Section 8e contains organizations sub section
echo '
ORGANIZATIONS
Contribute Coeur D'Alene Information About Local Organizations
';
// Section introductory text. Unique for this city-page and this section(5). //
$sql2 = "SELECT section_5_uniform_text FROM city_page_section_uniform_text";
$result2 = mysqli_query($conn, $sql2); //result is an array
$row2 = mysqli_fetch_assoc($result2); //Fetch all of the data
$token = strtok($row01["section5_note"], "");
while ($token !== false)// this loop fetches each subRecord(7 in this case) and sends it to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("'");
}
// Comment that is common to all sections
$token = strtok($row01["section_comt"], "");
while ($token !== false)// this loop fetches each sub Record and sends them to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("");
}
echo
'
';
//select and fetch the city-page section 8a data.
//
if (mysqli_num_rows($result_Sec8) > 0) { //check to see if any section data was fetched from the database for this city.
//Display Attractions Section(secton 8a) Data
//$row = mysqli_fetch_assoc($result_Sec8); //Fetch all of the data from the section form.
printf ("%s", $row01["records_sec5"]);
} else { //no section data was found in this cities section 8a.
echo "Section Information missing";
}
echo '
'.'';
//
echo '
Search for a different CITY on our history site.
';
//Section 8f contains government sub section
echo '
GOVERNMENT
Contribute Coeur D'Alene Local Government Information
';
// Section introductory text. Unique for this city-page and this section(6). //
$sql2 = "SELECT section_6_uniform_text FROM city_page_section_uniform_text";
$result2 = mysqli_query($conn, $sql2); //result is an array
$row2 = mysqli_fetch_assoc($result2); //Fetch all of the data
$token = strtok($row01["section6_note"], "");
while ($token !== false)// this loop fetches each subRecord(5 in this case) and sends it to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("'");
}
// Comment that is common to all sections
$token = strtok($row01["section_comt"], "");
while ($token !== false)// this loop fetches each sub Record and sends them to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("");
}
echo
'
';
//select and fetch the city-page section 8a data.
//
if (mysqli_num_rows($result_Sec8) > 0) { //check to see if any section data was fetched from the database for this city.
//Display Attractions Section(secton 8a) Data
//$row = mysqli_fetch_assoc($result_Sec8); //Fetch all of the data from the section form.
printf ("%s", $row01["records_sec6"]);
} else { //no section data was found in this cities section 8a.
echo "Section Information missing";
}
echo '
'.'';
//
echo '
Search for a different CITY on our history site.
';
//Section 8g contains schools sub section
echo '
SCHOOLS
Contribute Coeur D'Alene Information About Local Schools
';
// Section introductory text. Unique for this city-page and this section(7). //
$sql2 = "SELECT section_7_uniform_text FROM city_page_section_uniform_text";
$result2 = mysqli_query($conn, $sql2); //result is an array
$row2 = mysqli_fetch_assoc($result2); //Fetch all of the data
$token = strtok($row01["section7_note"], "");
while ($token !== false)// this loop fetches each subRecord(5 in this case) and sends it to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("'");
}
// Comment that is common to all sections
$token = strtok($row01["section_comt"], "");
while ($token !== false)// this loop fetches each sub Record and sends them to the user browser.
{
if(strcasecmp($token,"uName") == 0)
{$token = ""; echo $uName;} //This is a special case where the subRecord is the contents of a variable defined and populated above.
echo $token;
$token = strtok("");
}
echo
'
';
//select and fetch the city-page section 8a data.
//
if (mysqli_num_rows($result_Sec8) > 0) { //check to see if any section data was fetched from the database for this city.
//Display Attractions Section(secton 8a) Data
//$row = mysqli_fetch_assoc($result_Sec8); //Fetch all of the data from the section form.
printf ("%s", $row01["records_sec7"]);
} else { //no section data was found in this cities section 8a.
echo "Section Information missing";
}
echo '
'.'';
//
echo '
Search for a different CITY on our history site.
';
echo '
KEY TO THE CITY website has pages for over 23,000 towns and cities. A large
variety of material is published on many of the pages, such as: Noted notables,
interesting facts, mottos, interesting events, history, news, and more.
Each page contains information from a variety of sources including information
donated by individuals who have visited 'Key To The City'. In order to contribute
information for a particular city go to that city page and then to the
page section of interest. At the top of each section is a link to a form that can be used.
Some city pages are rented by a seperate publisher, other than Key To The City.
These publishers are responsible for the content of the page they are renting.
Key To The City does not edit or monitor content published by these publishers and
doesnt take responsibility for the content.
City pages that are not rented out are published by Key To The City
and as such, Key To The City is the publisher of those city pages. Other Key
To The City pages that are not 'city pages' are also the responsibility of
Key To The City and Key To The City is the publisher.
For questions or comments regarding this Coeur D'Alene Idaho City Page contact
the publisher:
';
echo '
Below is the contact information for Coeur D'Alene Idaho(Be sure and include the name of the city in any correspondence.).:
Publisher:
Editor:
';
echo '
