Back to top of page
Promotion Office for International Alliance

international symposia the staff(s) of RIES organized

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

$disp_var = false;

$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 symposia the staff(s) of RIES organized

from 2007

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

$main_sql = ‘SELECT * FROM symposium_view ORDER BY start_date DESC’;
$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);}

$start_DATE = ”;
$end_DATE = ”;
$disp_term = ”;
##### 同一年月日 #####
if(
$main_data[‘start_date’] == $main_data[‘end_date’]
)
{
$disp_term = (isset($main_data[‘start_date’])) ? date(‘d/F/Y’, strtotime($main_data[‘start_date’])) : ”;
}
##### 同一年月 #####
else if
(
date(‘F/Y’, strtotime($main_data[‘start_date’])) == date(‘F/Y’, strtotime($main_data[‘end_date’]))
)
{
$start_DATE = date(‘d’, strtotime($main_data[‘start_date’]));
$end_DATE = date(‘d/F/Y’, strtotime($main_data[‘end_date’]));
$disp_term = sprintf(‘%s–%s’, $start_DATE, $end_DATE);
}
##### その他 #####
else
{
$start_DATE = (isset($main_data[‘start_date’]))? date(‘d/F/Y’, strtotime($main_data[‘start_date’])) : ”;
$end_DATE = (isset($main_data[‘end_date’]))? date(‘d/F/Y’, strtotime($main_data[‘end_date’])) : ‘present’;
$disp_term = sprintf(‘%s–%s’, $start_DATE, $end_DATE);
}

echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

‘;
echo ‘

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

‘;
echo ‘

‘;
}
[/insert_php]

Term title place Staff(s) participating
as (an) organizer(s)
Countries/
Regions
‘;
echo $disp_term . “\n”;
echo ‘
‘;
echo $main_data[‘title’] . “\n”;
echo ‘
‘;
echo $main_data[‘place’] . “\n”;
echo ‘
‘;
echo $main_data[‘organizer’] . “\n”;
echo ‘
Back to top of page