function api_getPerson_id($id)
{
$db = new ParlDB();
$q = $db->query("select * from member\n where person_id = '" . mysql_real_escape_string($id) . "'\n order by left_house desc");
if ($q->rows()) {
_api_getPerson_output($q);
} else {
api_error('Unknown person ID');
}
}
function _api_getMLA_constituency($constituencies) {
$db = new ParlDB;
$cons = array();
foreach ($constituencies as $constituency) {
if ($constituency == '') continue;
$cons[] = mysql_real_escape_string($constituency);
}
$q = $db->query("SELECT * FROM member
WHERE constituency in ('" . join("','", $cons) . "')
AND left_reason = 'still_in_office' AND house=3");
if ($q->rows > 0) {
_api_getPerson_output($q);
return true;
}
return false;
}
function _api_getPerson_constituency($constituencies, $house)
{
$db = new ParlDB();
$cons = array();
foreach ($constituencies as $constituency) {
if ($constituency == '') {
continue;
}
if ($constituency == 'Orkney ') {
$constituency = 'Orkney & Shetland';
}
$cons[] = $constituency;
}
$cons_params = array();
$params = array(':house' => $house);
foreach ($cons as $key => $constituency) {
$cons_params[] = ':constituency' . $key;
$params[':constituency' . $key] = $constituency;
}
$q = $db->query("SELECT member.*, p.title, p.given_name, p.family_name, p.lordofname\n FROM member, person_names p\n WHERE constituency in (" . join(",", $cons_params) . ")\n AND member.person_id = p.person_id AND p.type = 'name'\n AND p.start_date <= left_house AND left_house <= p.end_date\n AND left_reason = 'still_in_office' AND house=:house", $params);
if ($q->rows > 0) {
_api_getPerson_output($q);
return true;
}
return false;
}