Back to top of page
Promotion Office for International Alliance

Academic Staffs from Oversea

[insert_php]
$disp_var = false;

##### 共通ファイルの呼び出し #####
include($_SERVER[‘DOCUMENT_ROOT’] . ‘/common-files/funcs.html’);

$pdo = new PDO(‘pgsql:dbname=english’);
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);

$country_all_sql = ‘SELECT country_id FROM country’;
$country_all_result = $pdo->query($country_all_sql);
$country_displayed = array();
while($country_all_id = $country_all_result->fetchColumn()){
$country_displayed[$country_all_id] = false;
}

[/insert_php]

Academic Staffs from Oversea

  • *2 The titles of laboratories are those renamed on 1 April, 2012.
  • *1 This laboratory was abolished due to either the retirement of the principal investigator (PI) or the movement of PI to the other institution.
from 2005
[insert_php]

## 2017年度以降 ACTRIESからのデータ呼び出し&表示
fromactriesSTAFFS(2017);

##################################################
##### メインデータの取得
##################################################
$main_sql = ‘SELECT * FROM staffs_view WHERE hidden IS NOT TRUE’;
$main_result = $pdo->query($main_sql);

while($main_data = $main_result->fetch()){

foreach($main_data as $keys => &$values){
#switch($keys){
#case ‘title’:
#break;
#default:
if(is_string($values)){
$values = src2html($values);
}
#break;
#}
}
if(!$disp_var){unset($keys, $values);}

echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘‘;
echo $main_data[‘country_name’] . “\n”;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;

}
[/insert_php]

Laboratory Term Name Job Title Country/
Regions
Current State
‘;
echo $main_data[‘labo_name’] . “\n”;
echo ‘
‘;

$start_YM = (isset($main_data[‘appointed’])) ? date(‘M/Y’, strtotime($main_data[‘appointed’])) : ”;
$end_YM = (isset($main_data[‘resigned’])) ? date(‘M/Y’, strtotime($main_data[‘resigned’])) : ‘present’;
$disp_term = sprintf(‘%s–%s’, $start_YM, $end_YM);

echo $disp_term . “\n”;
echo ‘

‘;
echo $main_data[‘staff_name’] . “\n”;
echo ‘
‘;
echo $main_data[‘job_title’] . “\n”;
echo ‘
‘;
echo $main_data[‘current_state’] . “\n”;
echo ‘
Back to top of page