Invited talks in international conferences

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

[insert_php]

##################################################
##### counrty_id の取得
##################################################
#$country_sql = sprintf(‘SELECT DISTINCT students.country_id,country.country_name,country.country_order FROM students,country WHERE students.country_id = country.country_id AND year = %d ORDER BY country.country_order’, $values_y);
#$country_result = $pdo->query($country_sql);
#$country_data = $country_result->fetchall();

##################################################
##### labo_id の取得
##################################################
#$labo_sql = ‘SELECT DISTINCT posdoc.labo_id,labo.labo_name,labo.labo_order from posdoc, labo where posdoc.labo_id = labo.labo_id order by labo.labo_order’;
#$labo_result = $pdo->query($labo_sql);
#$labo_data = $labo_result->fetchall();
/*

from 2007

*/
[/insert_php]

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

##################################################
##### メインデータの取得
##################################################
$pd_sql = sprintf(‘SELECT * FROM presentation_view’);
$pd_result = $pdo->query($pd_sql);

#foreach($pd_data as $keys_pd => $values_pd){
while($values_pd = $pd_result->fetch()){

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

echo ‘

‘;
echo ‘

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

‘;
echo ‘

‘;

}
[/insert_php]

start	end	author	title	meeting_name	place	country
‘; echo $values_pd[‘start_date’] . “\n”; echo ‘	‘; echo $values_pd[‘end_date’] . “\n”; echo ‘	‘; echo $values_pd[‘author’] . “\n”; echo ‘	‘; echo $values_pd[‘title’] . “\n”; echo ‘	‘; echo $values_pd[‘meeting_name’] . “\n”; echo ‘	‘; echo $values_pd[‘place’] . “\n”; echo ‘