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

echo ‘‘;

[/insert_php]

*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 2007

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

$list_sql = ‘SELECT * FROM visitors_view’;
$list_result = $pdo->query($list_sql);

while($list_data = $list_result->fetch()){

foreach($list_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 $list_data[‘country_name’] . “\n”;
echo ‘

‘;
echo ‘

‘;

}
[/insert_php]

Year, Month	Year, Month	Laboratory	Locations of the Institutions	the institute	Name	Titles
‘; echo date(‘Y, M’, strtotime($list_data[‘start_date’])) . “\n”; echo ‘	‘; echo date(‘Y, M’, strtotime($list_data[‘end_date’])) . “\n”; echo ‘	‘; echo $list_data[‘labo_name’] . “\n”; echo ‘	‘; echo $list_data[‘organ’] . “\n”; echo ‘	‘; echo $list_data[‘name’] . “\n”; echo ‘	‘; echo $list_data[‘title’] . “\n”; if($list_data[‘abst’]){ echo ‘‘; echo ‘ ‘; echo ‘ ‘; echo ‘‘; echo ‘‘; echo ‘ ‘; echo ‘ ‘; } echo ‘

Year, Month

Laboratory

Locations
of the Institutions

the institute

Name

Titles

‘;
echo date(‘Y, M’, strtotime($list_data[‘start_date’])) . “\n”;
echo ‘

‘;
echo date(‘Y, M’, strtotime($list_data[‘end_date’])) . “\n”;
echo ‘

‘;
echo $list_data[‘labo_name’] . “\n”;
echo ‘

‘;
echo $list_data[‘organ’] . “\n”;
echo ‘

‘;
echo $list_data[‘name’] . “\n”;
echo ‘

‘;
echo $list_data[‘title’] . “\n”;

if($list_data[‘abst’]){
echo ‘‘;
echo ‘

‘;

}
echo ‘