/**
*日本医科大学:TLOセンター:研究者紹介
*mercury project office.inc:2007
*kenji@mercury-cafe.com
* Table "tlo_researcher"
Attribute | Type | Modifier
---------------+--------------------------+-----------------------------------------------------------
id | integer | not null default nextval('"tlo_researcher_id_seq"'::text)
college | smallint |
belong | integer |
list_part | integer |
display_part | text |
part | text |
name | text |
kana | text |
specialty | text |
contents_clm | smallint |
contents_flg | boolean |
keyword | text |
keyword_flg | boolean |
book_clm | smallint |
book_flg | boolean |
exchange | text |
exchange_flg | boolean |
device | text |
device_flg | boolean |
society | text |
society_flg | boolean |
contact | text |
free_title | text |
free_text | text |
img | text |
sort | smallint |
regist | timestamp with time zone | default "timestamp"('now'::text)
last_update | timestamp with time zone | default "timestamp"('now'::text)
contents_type | smallint |
book_type | smallint |
**/
session_start();
include "nms_secure_init.inc";
db_init();
if($_GET['id'] || is_numeric($_GET['id'])){
$id=$_GET['id'];
$query = "SELECT * from tlo_researcher where id = $id";
$list = db_query_once($query);
$name=htmlspecialchars($list['name']);
$kana=htmlspecialchars($list['kana']);
$specialty=htmlspecialchars($list['specialty']);
$part=htmlspecialchars($list['post']);
/*表示用に所属、部*/
/*
$b_id=$list['belong'];
$query = "SELECT name from tlo_researcher_belong where id = $b_id"; //所属
$belong = db_query_once($query);
*/
$belong_name=htmlspecialchars($list['display_part']);
if($list['contents_flg']=='t'){
$query = "SELECT * from tlo_researcher_contents where master_id = $id order by id";
$contents=db_query($query);
}
if($list['book_flg']=='t'){
$query = "SELECT * from tlo_researcher_book where master_id = $id order by id";
$books=db_query($query);
}
}
if($list['img']){
$photo='';
}else{
if($list['college']==1){
$photo='
';
}else{
$photo='
';
}
}
db_close();
?>
| =$photo?> |
=$name?> =$kana?> =$belong_name?>、=$part?>
|