<?php
	if(isset($_GET['page']))
		$page = $_GET['page'];
	else
		$page=1;

	$url = $_SERVER['REQUEST_URI'];
	$home = "https://www.medicareusa.org";
	$classlink = "https://www.medicareusa.org/?nursing-homes/";
	$snfbase = "https://www.medicareusa.org/?nursing-home/";

	//remove any parameters from the url
	$var1 = explode("?",$url);
	$urlwithoutparam = $home.$var1[0];
	$canonicalurl = "https:".$urlwithoutparam;
	$currenturl = $home.$url;

	$var = explode("/",$var1[0]);

	$states = array(
					'AA'=>"Armed Forces Americas",
					'AE'=>"Armed Forces Europe",
					'AL'=>"Alabama",
					'AK'=>"Alaska",
					'AP'=>"Armed Forces Pacific",
					'AS'=>"American Samoa",
					'AZ'=>"Arizona",
					'AR'=>"Arkansas",
					'CA'=>"California",
					'CO'=>"Colorado",
					'CT'=>"Connecticut",
					'DE'=>"Delaware",
					'DC'=>"District Of Columbia",
					'FL'=>"Florida",
					'FM'=>"Micronesia",
					'FPO'=>"FPO",
					'GA'=>"Georgia",
					'GU'=>"Guam",
					'HI'=>"Hawaii",
					'ID'=>"Idaho",
					'IL'=>"Illinois",
					'IN'=>"Indiana",
					'IA'=>"Iowa",
					'KS'=>"Kansas",
					'KY'=>"Kentucky",
					'LA'=>"Louisiana",
					'ME'=>"Maine",
					'MD'=>"Maryland",
					'MA'=>"Massachusetts",
					'MH'=>"Marshall Islands",
					'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",
					'PW'=>"Palau",
					'RI'=>"Rhode Island",
					'SC'=>"South Carolina",
					'SD'=>"South Dakota",
					'TN'=>"Tennessee",
					'TX'=>"Texas",
					'UT'=>"Utah",
					'VT'=>"Vermont",
					'VA'=>"Virginia",
					'VI'=>"Virgin Island",
					'WA'=>"Washington",
					'WV'=>"West Virginia",
					'WI'=>"Wisconsin",
					'WY'=>"Wyoming",
					'PR'=>"Puerto Rico",
					'MP'=>"Northern Mariana Islands",
				);
	$case = 1;
	if(isset($var[2])&&($var[2]!=""))
	{
		$state = strtolower($var[2]);
		$ustate = strtoupper($state);
		$shortstate = strtoupper($state);
		$statelink = $classlink.$state."/";
		$fullstate = $states[strtoupper($state)];
		$case = 2;
	}
	if(isset($var[2])&&isset($var[3])&&($var[2]!="")&&($var[3]!=""))
	{
		$city1 = strtolower($var[3]);
		$citylink = $statelink.$city1."/";
		$temp = explode("-",$city1);
		$city = implode(" ",$temp);
		$fullcity = ucwords($city);
		$case = 3;
		if($city1=="all")
		{
			include 'allcities-snf.php';
			exit;
		}
	}

	$docsinpage = 20;
	$count = 0;

	$link = mysqli_connect("localhost", "root", "pencil123", "medicare");
	if (!$link) {
		echo "Error: Unable to connect to MySQL." . PHP_EOL;
		echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
		exit;
	}
	if($case==3)
	{
		$sql2 = "Select doccount from snfcount where state='$state' and city='$city'";
	}
	else if($case==2)
	{
		$sql2 = "Select sum(doccount) from snfcount where state='$state' group by state";
	}
	else if($case==1)
	{
		$sql2 = "Select sum(doccount) from snfcount";
	}
	$query2 = MySQLi_query($link,$sql2);
	$myrow = MySQLi_fetch_array($query2, MYSQLI_BOTH);
	$nofdocs = $myrow[0];
	$npages = ceil($nofdocs/$docsinpage);
	if($case == 1)
	{
		$desc = "Medicare Nursing Homes Ratings. Find Medicare ID, medicare ratings, NPI number, address and contact details for all medicare nursing homes in USA";
		$title = "Medicare Nursing Homes Ratings, Address, Contact";
		$title1 = "Medicare Nursing Homes Ratings, Location and Contact";
		$header = "Medicare Nursing Homes in USA";
	}
	else if ( $case == 2)
	{
		$desc = "Medicare Nursing Homes in ".$fullstate.". Find Medicare ID, medicare ratings, NPI number, address and contact details for all medicare nursing homes in ".$fullstate;
		$title = "Medicare Nursing Homes in ".$fullstate." - Ratings, Location, NPI Details";
		$title1 = "Medicare Nursing Homes in ".$fullstate." - Ratings, Address, Contact";
		$header = "Medicare Nursing Homes in ".$fullstate;
	}
	else if ($case == 3)
	{
		$desc = "Medicare Nursing Homes in ".$fullcity.", ".$fullstate.". Find Medicare ID, medicare ratings, NPI number, address and contact details for all medicare nursing homes in ".$fullcity.", ".$fullstate;
		$title1 = "Medicare Nursing Homes in ".$fullcity.", ".$shortstate;
		$title = "Medicare Nursing Homes in ".$fullcity.", ".$shortstate." - Medicare Status, Ratings, Address, Contact";
		$header = "Medicare Nursing Homes in ".$fullcity.", ".$fullstate;
	}

	$advert = '<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
		<!-- medicareusa-resp -->
		<ins class="adsbygoogle"
			 style="display:block"
			 data-ad-client="ca-pub-2287322975177592"
			 data-ad-slot="4151771535"
			 data-ad-format="auto"></ins>
		<script>
		(adsbygoogle = window.adsbygoogle || []).push({});
		</script>';

	$adlinkresp = '<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
				<!-- medicare-link -->
				<ins class="adsbygoogle"
					 style="display:block"
					 data-ad-client="ca-pub-2287322975177592"
					 data-ad-slot="9231567982"
					 data-ad-format="link"></ins>
				<script>
				(adsbygoogle = window.adsbygoogle || []).push({});
				</script>';

	$adlink = '<style type="text/css">
			.adslot_1 { display:inline-block; width: 728px; height: 20px; }
			@media (max-width:500px) { .adslot_1 { display: none; } }
			@media (max-width:750px) { .adslot_1 { width: 468px; height: 20px; } }
			</style>
			<ins class="adsbygoogle adslot_1"
				 data-ad-client="ca-pub-2287322975177592"
				 data-ad-slot="9231567982"
				 data-ad-format="link"></ins>
			<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
			<script>(adsbygoogle = window.adsbygoogle || []).push({});</script>';

	$replace_linkad = '<style type="text/css">
				.adslot_4 { display:inline-block; width: 320px; height: 50px;}
				@media (max-width: 500px) {.adslot_4 {display: none;} }
				@media (min-width: 501px) {.adslot_4 {display:inline-block;min-width:400px;max-width:1200px;width:100%;height:90px;} }
				</style>
				<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
				<!-- Licensee -->
				<ins class="adsbygoogle adslot_4"
						data-ad-client="ca-pub-2287322975177592"
						data-ad-slot="4151771535"></ins>
				<script>
				(adsbygoogle = window.adsbygoogle || []).push({});
				</script>';

?>
<!DOCTYPE html>
<html lang="en">
<head>
<title><?php echo $title;?> | MedicareUSA</title>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="<?php echo $desc;?>">

<?php
	if ($page == 1)
	{
		echo "<link rel=\"canonical\" href=\"$canonicalurl\" />";
	}
	if ($page == 2)
	{
		echo "<link rel=\"prev\" href=\"$canonicalurl\" />";
	}
	else if($page != 1)
	{
		$ppage=$page - 1;
		$prev=$canonicalurl."?page=".$ppage;
		echo "<link rel=\"prev\" href=\"$prev\" />";
	}
	if($page!=$npages)
	{
		$npage=$page + 1;
		$next=$canonicalurl."?page=".$npage;
		echo "<link rel=\"next\" href=\"$next\" />";
	}

?>
<link href="https://www.medicareusa.org/css/all.css?v=1" rel="stylesheet">
<link rel="canonical" href="https://www.medicareusa.org/?nursing-homes/mo/all/">
<meta property="article:published_time" content="2015-15-06T14:29:44+00:00"/>
<meta property="article:modified_time" content="2023-15-06T14:20:41+00:00"/>
<link rel="shortcut icon" href="https://www.medicareusa.org/images/favicon.png">
<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-2287322975177592" crossorigin="anonymous"></script>
</head>
<body>
<?php include 'header.php'; ?>
<div class="container">
	<h1 class="header"><?php echo $title1; ?></h1>
	<ol class="breadcrumb pan">
	<?php
	echo "<li><a href=\"$home\">Home</a></li>\n";
	echo "<li><a href=\"$classlink\">Nursing Homes</a></li>\n";
	if(isset($state))
		echo "<li><a href=\"$statelink\">$fullstate</a></li>\n";
	if(isset($city))
		echo "<li>$fullcity</li>\n";
	?>
	</ol>
	<?php echo $replace_linkad;?>
	<div class="row">
	<div class="col-md-5 col-md-push-3">
	<?php
			$offset = ($page-1)*$docsinpage;
			$showstart = $offset + 1;
			$showend = min($offset + $docsinpage, $nofdocs);

			echo "<h5 class=\"center\">$nofdocs Nursing Homes found. Showing $showstart - $showend</h5>";
			if($case!=3)
			echo "<div class=\"visible-xs hidden-sm hidden-md\"><h5 class=\"center\"><a href=\"#filter\">Filter Results by State/City</a></h5></div>";
			/*Select relevant branches*/
			$qonpage = 0;

			if($case==3)
			{
				$sql3 = "Select * from medsnf where State='$state' AND City='$city' LIMIT $offset, $docsinpage";
			}
			else if($case==2)
			{
				$sql3 = "Select * from medsnf where State='$state' LIMIT $offset, $docsinpage";
			}
			else if($case==1)
			{
				$sql3 = "Select * from medsnf LIMIT $offset, $docsinpage";
			}

			$query3 = MySQLi_query($link,$sql3);
			echo "<table class=\"table\">";
			while($myrow = MySQLi_fetch_array($query3, MYSQLI_BOTH))
			{
				$PID = $myrow['provnum'];
				$name = ucwords(strtolower($myrow['PROVNAME']));
				$address = ucwords(strtolower($myrow['ADDRESS']));
				$city = ucwords(strtolower($myrow['CITY']));
				$state = $myrow['STATE'];
				$zip = $myrow['ZIP'];
				$county = $myrow['COUNTY_NAME'];
				$phone = $myrow['PHONE'];
				$formattedphone = "(".substr($phone,0,3).") ".substr($phone,3,3)."-".substr($phone,6);
				$owner = $myrow['OWNERSHIP'];
				$bedcert = $myrow['BEDCERT'];
				$type = $myrow['CERTIFICATION'];
				$rating = $myrow['overall_rating'];
				$snflink = $myrow['link'];

				$branchlink = $snfbase.$snflink."/";
				$fullstate = $states[$state];
				$fulladdress = $address.", ".$city.", ".$fullstate." ".$zip;

				$qonpage++;
				if($qonpage==4)
				{
					echo "<tr><td>";
					echo "$advert";
					echo "</td></tr>";
				}
				echo "<tr><td>";
				echo "<div class=\"imgs\"><img src=\"https://www.medicareusa.org/images/hospitals.png\" alt=\"nursing home icon\"></div>";
				echo "<div><strong><a href=\"$branchlink\">$name</a></strong><br>";
				echo "<small>$type</small><br><small><b>Location: </b>$fulladdress<br>";

				echo "<b>Ratings:</b></small>";
				if($rating=="1")
					echo "<i class=\"fa fa-star blue\"></i><i class=\"fa fa-star-o blue\"></i><i class=\"fa fa-star-o blue\"></i><i class=\"fa fa-star-o blue\"></i><i class=\"fa fa-star-o blue\"></i>";
				else if($rating=="2")
					echo "<i class=\"fa fa-star blue\"></i><i class=\"fa fa-star blue\"></i><i class=\"fa fa-star-o blue\"></i><i class=\"fa fa-star-o blue\"></i><i class=\"fa fa-star-o blue\"></i>";
				else if($rating=="3")
					echo "<i class=\"fa fa-star blue\"></i><i class=\"fa fa-star blue\"></i><i class=\"fa fa-star blue\"></i><i class=\"fa fa-star-o blue\"></i><i class=\"fa fa-star-o blue\"></i>";
				else if($rating=="4")
					echo "<i class=\"fa fa-star blue\"></i><i class=\"fa fa-star blue\"></i><i class=\"fa fa-star blue\"></i><i class=\"fa fa-star blue\"></i><i class=\"fa fa-star-o blue\"></i>";
				else if($rating=="5")
					echo "<i class=\"fa fa-star blue\"></i><i class=\"fa fa-star blue\"></i><i class=\"fa fa-star blue\"></i><i class=\"fa fa-star blue\"></i><i class=\"fa fa-star blue\"></i>";
				else
					echo "NA";
				echo "&nbsp;&nbsp;&nbsp;<small><b>Phone:</b> $formattedphone";
				echo "</small></div></td></tr>";
			}
			if($qonpage<4)
			{
				echo "<tr><td>";
				echo "$advert";
				echo "</td></tr>";
			}
			echo "</table>";
			if($npages>1)
			{
				echo "<ul class=\"pagination pagination-sm\">";

				$diff = max(0, $page+5-$npages);
				$minpage = max(1, $page-5-$diff);
				$diff = max(0,1+5-$page);
				$maxpage = min($npages, $page+5+$diff);

				$minlink = $urlwithoutparam."?page=".$minpage;
				$maxlink = $urlwithoutparam."?page=".$maxpage;
				if($minpage != 1)
				echo "<li><a href=\"$minlink\">&laquo;</a></li>";
				for ($i=$minpage;$i<=$maxpage;$i++)
				{
					$link2 = $urlwithoutparam."?page=".$i;
					if($i==$page)
					echo "<li class=\"active\"><span>$i<span class=\"sr-only\">(current)</span></span></li>\n";
					else
					echo "<li><a href=\"$link2\">$i</a></li>\n";
				}
				if($maxpage != $npages)
				echo "<li><a href=\"$maxlink\">&raquo;</a></li>";
				echo "</ul>";
			}
		?>
	</div>
	<div class="col-md-3 col-md-pull-5" id="filter">
	<?php
	if($case == 3)
	{
		//do nothing
		echo "<br>$adlinkresp";
	}
	else if($case == 2)
	{
		$sql4 = "SELECT * from (Select city, doccount from snfcount where state='$state' order by doccount desc limit 30) as t1 order by city";
		//$sql4 = "Select city, doccount from snfcount where state='$state' order by city";
		echo "<b><u>Top Cities in $state:</u></b><br>";
		$query4 = MySQLi_query($link,$sql4);
		while($myrow = MySQLi_fetch_array($query4, MYSQLI_BOTH))
		{
			$option = ucwords(strtolower($myrow[0]));
			$countoption = $myrow[1];
			$temp = explode(" ",strtolower($option));
			$tempcity = urlencode(implode("-",$temp));
			$link1 = $statelink.$tempcity."/";
			echo "<a href=\"$link1\">$option ($countoption)</a><br>";
		}
		$allcities = $statelink."all/";
		echo "<br><span id=\"allcities\"><a href=\"$allcities\"><u><b>All Cities in $ustate</b></u></a></span>";
	}
	else if($case == 1)
	{
		$sql4 = "Select state, sum(doccount) from snfcount group by state order by state";
		echo "<b><u>Filter By State:</u></b><br>";
		$query4 = MySQLi_query($link,$sql4);
		while($myrow = MySQLi_fetch_array($query4, MYSQLI_BOTH))
		{
			$option = strtolower($myrow[0]);
			$countoption = $myrow[1];
			$state1 = $states[$myrow[0]];
			$link1 = $classlink.$option."/";
			echo "<a href=\"$link1\" class=\"question\">$state1 ($countoption)</a><br>";
		}
	}
	?>
	</div>
	<div class="col-md-4">
		
		
	<h3>Nursing Home</h3>
		A nursing home (also called skilled nursing facility) is a facility or distinct part of an institution whose primary function is to provide medical, continuous nursing, and other health and social services to patients who are not in an acute phase of illness requiring services in a hospital, but who require primary restorative or skilled nursing services on an inpatient basis above the level of intermediate or custodial care in order to reach a degree of body functioning to permit self care in essential daily living.
		<br><br>A skilled nursing facility (SNF) may be a freestanding facility or part of a hospital that has been certified by Medicare to admit patients requiring subacute care and rehabilitation.
		<h3>Nursing Home Compare</h3>
		Nursing Home Compare allows consumers to compare information about nursing homes. It contains quality of care and staffing information for all 15,000 plus Medicare- and Medicaid-participating nursing homes.
		<br><br><b>Note:</b> Nursing homes aren't included on Nursing Home Compare if they aren't Medicare or Medicaid certified. These Nursing Homes can be licensed by the state.
		<br><br>Information on Nursing Home Compare isn't an endorsement or advertisement for any nursing home and should be considered carefully. Use it with other information you gather about nursing homes facilities. Talk to your doctor or other health care provider about the information on Nursing Home Compare.
		<br>
		<?php
		echo "<br>$advert";
		?>
	</div>
	</div>
</div>
<?php include 'footer.php'; ?>
<!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
      <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->

  <!-- Bootstrap core JavaScript
  ================================================== -->
  <!-- Placed at the end of the document so the pages load faster -->
  <script src="https://www.medicareusa.org/js/jquery-2.2.0.min.js"></script>
  <script src="https://www.medicareusa.org/bootstrap/js/bootstrap.min.js"></script>

  <script>
	$(document).ready(function(){
		$('[data-toggle="popover"]').popover();
	});
  </script>

</body>
</html>