Find a doctor
Health
information links
//ochrona przed bezposrednim dostepem do pliku przez URI // if( eregi('omaCMS',$_SERVER['REQUEST_URI'])){ // die('This file cannot be accessed directly!'); // }; require_once('admin/includes/DbConnector.php'); require_once('admin/includes/Validator.php'); $connector = new DbConnector(); $validator = new Validator(); if (isset($_REQUEST['cityName'])){ $validator->validateGeneral($_REQUEST['cityName'], SCRIPT_ERROR); // Sprawdzenie czy byly bledy if ( $validator->foundErrors() ){ echo (SCRIPT_ERROR); }else{ $cityName = addslashes($_REQUEST['cityName']); //zapytanie pobierajace lekarzy w lokalizacje danego miasta $query_cms = 'SELECT DISTINCT d.ID, d.first_name, d.last_name, d.degree FROM doctors d INNER JOIN doctors_to_locations dl ON d.ID=dl.doctor_ID WHERE dl.location_ID IN ( SELECT l.ID FROM locations l WHERE l.city LIKE "'. $cityName .'") ORDER BY d.last_name ASC'; $result = $connector->query($query_cms); $rowCount = $connector->getNumRows($result); //stronnicowanie jeśli wyników wiecej niż if ($rowCount > 15){ $perPage = 10; $curPage = abs( (int)$_GET['p'] ); $startPage = $perPage * $curPage; $lastPage = ceil($rowCount/$perPage); //powtórzenie zapytania ze stronnicowanie $query_cms = 'SELECT DISTINCT d.ID, d.first_name, d.last_name, d.degree FROM doctors d INNER JOIN doctors_to_locations dl ON d.ID=dl.doctor_ID WHERE dl.location_ID IN ( SELECT l.ID FROM locations l WHERE l.city LIKE "'. $cityName .'") ORDER BY d.last_name ASC LIMIT '. $startPage .','. $perPage .''; //przysłoniece wyników $result = $connector->query($query_cms); //linki nawigacyjne if ( $startPage != 0 ){ $prevPage = '


'. $prevPage .' page '. ($curPage+1) .' of '. $lastPage .' '. $nextPage .'
';
}else{
$linkPage = NULL;
};
};
if ($rowCount < 1 ){
echo ('No results
'); }else{ echo ('Doctors in city: '. $cityName .'
'); //link stronnicowania echo ($linkPage); echo ('
');
while ($row = $connector->fetchArray($result)){
echo ('
'); echo ($linkPage); echo ('
'); echo('
');
};
};
}else{
echo (SCRIPT_ERROR);
}
?>
'. stripslashes($row['first_name']) .' '. stripslashes($row['last_name']) .', '. $row['degree'] .'
'); //zapytanie pobierajace szczegółową lokalizacje dla danego lekarza $query_cms2 = 'SELECT * FROM locations l WHERE l.city LIKE "'. $cityName .'" AND l.ID IN ( SELECT location_ID FROM doctors_to_locations dl WHERE dl.doctor_ID = '. (int)$row['ID'] .')'; $result2 = $connector->query($query_cms2); while ($row2 = $connector->fetchArray($result2)){ //czy info o suit w bazie if( $row2['street_suite'] != 0 ){ $suite = ', Suite '. stripslashes($row2['street_suite']) .''; }else{ $suite = NULL; }; echo ('');
echo ('
');
echo ('
');
};
};
//link stronnicowania
echo (''. stripslashes($row2['practice_name']) .'
'. $row2['street_num'] .' '. stripslashes($row2['street_name']) .''. $suite .'
'. stripslashes($row2['city']) .', '. $row2['state'] .' '. $row2['zip'] .'
'. stripslashes( $row2['practice_name'] ) .'
'); echo (''. $row2['street_num'] .' '. stripslashes( $row2['street_name'] ) .' '. stripslashes( $suite ) .' - '. stripslashes( $row2['city'] ) .', '. $row2['state'] .' '. $row2['zip'] .' [show on map]
'); echo (''); echo ($linkPage); echo ('
'); echo('