Search Hospitals

[php] global $wpdb;
$where = ” where city = ‘”.$_REQUEST[‘city’].”‘ “;
$keywords = ”;
$keyword = explode(‘ ‘,$_REQUEST[‘search_keyword’]);
foreach($keyword as $word)
{
$keywords .= ” or hospital like ‘%$word%’ “;
}
$keywords = trim ($keywords,’ or’);

if($keywords) $where.=” And ($keywords)”;

$states = $wpdb->get_results( “SELECT * FROM wp_hospitals $where ” );
$exist = count($states);
[/php]

[php] if(!$exist){[/php]

[php]}else
foreach($states as $st) {[/php]

[php]}[/php]

No Match Found for your keyword
Hospital: [php]echo $st->title;[/php] Address: [php]echo $st->hospital;[/php] phone: [php]echo $st->number;[/php] City: [php]echo $st->city;[/php] state: [php]echo $st->state;[/php]

Add Comment Cancel

You must be logged in to post a comment.