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; }