"Alabama",
'AK'=>"Alaska",
'AZ'=>"Arizona",
'AR'=>"Arkansas",
'CA'=>"California",
'CO'=>"Colorado",
'CT'=>"Connecticut",
'DE'=>"Delaware",
'DC'=>"Washington, DC",
'FL'=>"Florida",
'GA'=>"Georgia",
'HI'=>"Hawaii",
'ID'=>"Idaho",
'IL'=>"Illinois",
'IN'=>"Indiana",
'IA'=>"Iowa",
'KS'=>"Kansas",
'KY'=>"Kentucky",
'LA'=>"Louisiana",
'ME'=>"Maine",
'MD'=>"Maryland",
'MA'=>"Massachusetts",
'MI'=>"Michigan",
'MN'=>"Minnesota",
'MS'=>"Mississippi",
'MO'=>"Missouri",
'MT'=>"Montana",
'NE'=>"Nebraska",
'NV'=>"Nevada",
'NH'=>"New Hampshire",
'NJ'=>"New Jersey",
'NM'=>"New Mexico",
'NY'=>"New York",
'NC'=>"North Carolina",
'ND'=>"North Dakota",
'OH'=>"Ohio",
'OK'=>"Oklahoma",
'OR'=>"Oregon",
'PA'=>"Pennsylvania",
'RI'=>"Rhode Island",
'SC'=>"South Carolina",
'SD'=>"South Dakota",
'TN'=>"Tennessee",
'TX'=>"Texas",
'UT'=>"Utah",
'VT'=>"Vermont",
'VA'=>"Virginia",
'WA'=>"Washington",
'WV'=>"West Virginia",
'WI'=>"Wisconsin",
'WY'=>"Wyoming");
$stateName = $states[$state];
$sName = $states[$s];
$lowerState = strtolower($sName);
//select page title
if (!empty($state)){
$title = "Auto Insurance Agents In ".$state;
}
elseif (!empty($city)){
$title = $city." Auto Insurance Agents | ".$city.", ".$s;
}
elseif (!empty($id)){
$title = $agent." | Auto Insurance Agent in ".$c.', '.$s;
}
elseif (!empty($zip)){
$title = $zip." Auto Insurance | Insurance Agents In ".$zip." zip code";
}
require_once($_SERVER['DOCUMENT_ROOT'] . '/auto/dbConnect.php');
?>
';
echo "
".$stateName." Auto Insurance ";
echo "
Are you paying too much for ".$stateName." auto insurance? Did you know the average rate in ".$state." is $468/yr? If you're paying more than this, we can help. Simply use our free quote service to instantly compare rates from up to 5 top ".$state." auto insurance companies. Go ahead ".$state." it's time to save some money!
";
echo "
";
}
elseif (!empty($city)){
echo '';
echo "
".$city." Auto Insurance ";
echo "
Are you paying too much for ".$city." auto insurance? Did you know the average rate in ".$city." is $362/yr? If you're paying more than $362, stop! Simply use our free quote service to instantly compare rates from up to 5 top ".$city." auto insurance companies. Auto insurance shopping in ".$city." has never been easier!
";
echo "
";
}
elseif (!empty($id)){
}
elseif (!empty($zip)){
echo '';
echo "
".$zip." Auto Insurance ";
echo "
List of auto insurance agents local to the ".$zip." zipcode ";
echo "
Are you paying too much for auto insurance in ".$zip."? Did you know the average rate in ".$zip." is $312/yr? If you're paying more than this, we can help. Simply use our free quote service to instantly compare rates from up to 5 top auto insurance companies in ".$zip.".
";
echo "
";
}
?>
query("SELECT * FROM InsuranceAgents WHERE id = $id ");
while($r = $q->fetch_array(MYSQLI_ASSOC)){
$lat = $r[lat];
$lon = $r[lon];
$cityR = $r[city];
$stateR = $r[state];
$agent = $r[agentname];
$address = $r[address];
$zipR = $r[zip];
$areacode = $r[areacode];
$phone = $r[phone];
$countyR= $r[county];
$url = "http://maps.googleapis.com/maps/api/staticmap?zoom=13&size=300x200&maptype=roadmap&markers=color:blue%7Clabel:S%7C".$lat.",".$lon."&sensor=false";
echo '
';
echo '
';
echo '
';
echo '
'.$agent.' ';
echo '
';
echo ''.$address.' ';
echo ''.$cityR.' ,';
echo ''.$stateR.' .';
echo ' | '.$zipR.' ';
echo '
';
echo 'Phone: '.$phone.' ';
echo '
';
echo '
';
echo '
';
echo '
';
echo '
 
';
echo 'Get a free auto insurance quote in ' .$sName. ' ';
echo ' ';
}
}
elseif (!empty($zip)){
$q = $dbc -> query("SELECT * FROM InsuranceAgents WHERE zip = $zip ");
while($r = $q->fetch_array(MYSQLI_ASSOC)){
$lat = $r[lat];
$lon = $r[lon];
$cityR = $r[city];
$stateR = $r[state];
$agent = $r[agentname];
$address = $r[address];
$idR = $r[id];
$zipR = $r[zip];
$areacode = $r[areacode];
$phone = $r[phone];
$countyR= $r[county];
//$url = "http://maps.googleapis.com/maps/api/staticmap?zoom=13&size=300x200&maptype=roadmap&markers=color:blue%7Clabel:S%7C".$lat.",".$lon."&sensor=false";
echo '';
echo '
';
echo '
';
echo '
'.$address.' ';
echo '
'.$cityR,', '.$stateR,' - '.$zipR.' | ('.$countyR.' County) ';
echo '
phone: '.$phone.' ';
echo '
';
echo ' 
';
echo ' ';
}
}
elseif (!empty($state)){
$q = $dbc -> query("SELECT DISTINCT city FROM InsuranceAgents WHERE state = '$state' ORDER BY city ASC");
while($r = $q->fetch_array(MYSQLI_ASSOC)){
$lat = $r[lat];
$lon = $r[lon];
$cityR = $r[city];
$stateR = $r[state];
$agent = $r[agentname];
$address = $r[address];
$zipR = $r[zip];
$areacode = $r[areacode];
$phone = $r[phone];
$countyR= $r[county];
//$url = "http://maps.googleapis.com/maps/api/staticmap?zoom=13&size=300x200&maptype=roadmap&markers=color:blue%7Clabel:S%7C".$lat.",".$lon."&sensor=false";
echo '';
echo ' 
';
echo ' ';
}
}
elseif (!empty($city)&&!empty($s)){
$q = $dbc -> query("SELECT * FROM InsuranceAgents WHERE city = '$city' AND state = '$s' ");
while($r = $q->fetch_array(MYSQLI_ASSOC)){
$lat = $r[lat];
$lon = $r[lon];
$cityR = $r[city];
$idR = $r[id];
$stateR = $r[state];
$agent = $r[agentname];
$address = $r[address];
$zipR = $r[zip];
$areacode = $r[areacode];
$phone = $r[phone];
$countyR= $r[county];
//$url = "http://maps.googleapis.com/maps/api/staticmap?zoom=13&size=300x200&maptype=roadmap&markers=color:blue%7Clabel:S%7C".$lat.",".$lon."&sensor=false";
echo '';
echo '
';
echo '
';
echo '
'.$address.' ';
echo '
'.$cityR,', '.$stateR,' - '.$zipR.' | ('.$countyR.' County) ';
echo '
phone: '.$phone.' ';
echo '
 
';
echo '
';
}
}
elseif (!empty($county)){
$q = $dbc -> query("SELECT * FROM InsuranceAgents WHERE county = '$county' ");
}
include $_SERVER['DOCUMENT_ROOT'] . '/auto/inc/agentSidebar.php';
//mysqli_close($dbc);
?>