Back to top of page
Promotion Office for International Alliance

international collaboration

[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]

international collaboration

  • *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からのデータ呼び出し&表示
fromactriesCOLLABO(2017);

##################################################
##### データの取得
##################################################
$main_sql = ‘SELECT * FROM collabo ORDER BY start_year DESC, end_year DESC’;
$main_result = $pdo->query($main_sql);

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

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

echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
}
[/insert_php]

Year Laboratory Universities/Institutes, Countries/Regions
‘;
$disp_term = ($main_data[‘start_year’] == $main_data[‘end_year’]) ? $main_data[‘start_year’] : $main_data[‘start_year’] . ‘–’ . $main_data[‘end_year’];
echo $disp_term . “\n”;
echo ‘
‘;
$labo_sql = sprintf(‘SELECT * FROM collabo_labo_view WHERE parent_id = %d’, $main_data[‘id’]);
$labo_result = $pdo->query($labo_sql);
$labo_count = $labo_result->rowCount();
if($labo_count){
echo ‘

‘;
}
echo ‘

‘;

$child_sql = sprintf(‘SELECT * FROM collabo_members_view WHERE parent_id = %d’, $main_data[‘id’]);
$child_result = $pdo->query($child_sql);
$child_count = $child_result->rowCount();
if($child_count){
echo ‘

    ‘;
    while($child_data = $child_result->fetch()){
    $child_txt_arr = array();
    foreach(array(‘institute’,’country_name’) as $keys_c){
    if($child_data[$keys_c]){
    $child_txt_arr[] = src2html($child_data[$keys_c]);
    }
    }
    $child_txt = implode(‘, ‘, $child_txt_arr);
    echo ‘‘;
    echo $child_txt . “\n”;
    echo ‘

    ‘;
    }
    echo ‘

‘;
}
echo ‘

Back to top of page