Hospital Directory

Find a Hospital

Search Hospital

 Hospital in , . USA

&state=>, >

>   Average Rating "); $ratingImg = getStarRating($commentsResult[0]); echo $ratingImg; } else { echo"\n"; } } echo ""; //echo "\n"; //echo"\n"; //printf("",$NumberHoles,$yardage,$par); //} while ($myrow = mysql_fetch_array($result_comments)); //echo "
\n"; /* * Creates a street view image link for each bank and display them * along with the other blood bank information. * * Uses the StreetView class from the root. * See /streetview.php */ $row['laty'] = $result['loc_LAT_centroid']; $row['longy'] = $result['loc_LONG_centroid']; include_once $_SERVER['DOCUMENT_ROOT'] . '/streetview.php'; $sv = new StreetView($row); echo '
Street view of '.$center.'
'; printf("

Comments on ".$hospital_name."

"); $result2 = "SELECT, h.biz_name, h.e_address, h.e_city, h.biz_phone,,,c.Comments,c.rating, c.DatePlayed FROM hospitals as h LEFT JOIN hospcomments as c ON = c.ID WHERE = ? AND c.approved = 'Y' ORDER BY c.DatePlayed desc"; $commentsArrStatement = $pdo->prepare($result2); $commentsArrStatement->bindParam(1, $ID, PDO::PARAM_INT); $commentsArrStatement->execute(); $commentsArrResult = $commentsArrStatement->fetchAll(PDO::FETCH_ASSOC); //if ($result2 == ''){ //echo "comments = nothing"; //}else{ /* * Displays the comments and reviews of the blood center. */ if ( !empty($commentsArrResult) ) { //printf("%s (%s)

",$myrow["CourseName"],$myrow["ID"],$myrow["street1"],$myrow["City"],$myrow["PhoneRes"]); foreach ($commentsArrResult as $key => $myrow) { echo "\n"; //hack for name replacement if ($myrow["name"] =="" ){ //echo 'inside name null'; $myrow["name"] = "Anonymous Donor"; } printf("\n"; elseif ( $myrow["rating"] == 2) echo "\n"; elseif ( $myrow["rating"] == 3) echo "\n"; elseif ( $myrow["rating"] == 4) echo "\n"; elseif ( $myrow["rating"] == 5) echo "\n"; printf("",$myrow["Comments"]); printf(" Rate and Comment on ".$center."

"); echo "

Donor: %s
",$myrow["name"]); if ( $myrow["DatePlayed"] > 0) printf("Date: %s
",$myrow["DatePlayed"]); echo "Rating: "; if ( $myrow["rating"] == 1) echo "
\n"; echo "

\n"; } }else{ printf(" Be the 1st to Rate and Comment on ".$center."

"); } /** * Destroy the database handler object. */ $pdo = null; ?>

DISCLAIMER: BloodBanker attempts to provide the most accurate and up-to-the-minute information regarding each of the blood banks and companies listed. However, we cannot guarantee the information will always be complete, accurate and up-to-the-minute. The map images and driving directions are provided by a third party, thus BloodBanker has no control over this information. BloodBanker accepts no liability for any inconvenience, damage, or loss caused by any data within our organization. The information provided should under no circumstances be relied upon as accurate, especially in any emergency or urgent situations. We recommend you call all locations before making a trip out to see them, and leave us a comment if any of the information is incorrect.

Find Blood Banks