function create_person($params)
{
$firstname = $params['firstname'];
$surname = $params['surname'];
$res = '';
$external = my_mysql_query_hash('SELECT * FROM TbExternalType', 'id');
$query = sprintf('SELECT * FROM TbIdPerson WHERE firstname=%s AND surname=%s', my_mysql_real_escape_string($firstname), my_mysql_real_escape_string($surname));
$row = my_mysql_query_one_row($query);
$id = $row['id'];
$res .= '<ul>';
$res .= '<li>id: ' . $id . '</li>';
$res .= '<li>Name: ' . get_full_name($row, $honorifics) . '</li>';
// handle externals
$query = sprintf('SELECT * FROM TbIdPersonExternal WHERE personId=%s', my_mysql_real_escape_string($id));
$result = my_mysql_query($query);
while ($row = $result->fetch_assoc()) {
$externalcode = $row['externalCode'];
$externalid = $row['externalId'];
$externalname = $external[$externalid]['name'];
$externalidname = $external[$externalid]['idname'];
$link = get_external_href($externalname, $externalcode);
$link = '<a href=\'' . $link . '\'>' . $externalidname . ': ' . $externalcode . '</a>';
$res .= '<li>' . $link . '</li>';
}
my_mysql_free_result($result);
$res .= '</ul>';
return $res;
}
function get_person_data()
{
$honorifics_hash = my_mysql_query_hash('SELECT * FROM TbIdHonorific', 'id');
$query = sprintf('select id,honorificId,firstname,surname,othername,ordinal from TbIdPerson order by firstname,surname');
$result = my_mysql_query($query);
$row = $result->fetch_assoc();
while ($row != NULL) {
$row['label'] = get_full_name($row, $honorifics_hash);
$rows[] = $row;
$row = $result->fetch_assoc();
}
return $rows;
}
