HTML;
// MySQL³
$con = pbof_mysql_connect(); //2017.11.07 IL ɲ аܹб
// ƥꥹ
$category_array = array();
$category_name_array = array();
$sql = "select mid, name from scj_category order by sid";
@mb_convert_variables($enc_db, $enc_in, $sql);
$rst = mysqli_query($con, $sql);
while ($col = mysqli_fetch_array($rst)) {
@mb_convert_variables($enc_in, $enc_db, $col);
$category_array[] = $col['mid'];
$category_name_array[$col['mid']] = $col['name'];
$category_rname_array[$col['name']] = $col['mid'];
}
mysqli_free_result($rst);
// եꥹ
$news = '';
$cate = $category_rname_array['ץ쥹롼'];
$year = '';
//$sql = "select scj_blog.mid, scj_blog.cate, scj_blog.title, scj_blog.vdate, scj_category.sub, scj_category.mainid, date_format(from_unixtime(scj_blog.vdate), '%Y') as year from scj_blog inner join scj_category on scj_blog.cate = scj_category.mid where scj_blog.view = '1' and scj_blog.cate = '22' order by scj_blog.vdate desc";
$sql = "select scj_blog.mid, scj_blog.cate, scj_blog.title, scj_blog.vdate, scj_category.sub, scj_category.mainid, scj_category.grp, date_format(from_unixtime(scj_blog.vdate), '%Y') as year from scj_blog inner join scj_category on scj_blog.cate = scj_category.mid where scj_blog.view = '1' and scj_blog.vdate <= '{$now}' and ( scj_category.name != 'ץ쥹롼' and scj_category.name != 'ץ쥹' ) order by scj_blog.vdate desc";
@mb_convert_variables($enc_db, $enc_in, $sql);
$rst = mysqli_query($con, $sql);
$cnt = 0;
$view = true;
while ($col = mysqli_fetch_array($rst)) {
if ($year=='') {
$year = $col['year'];
$cnt++;
$news .= "
".$year."ǯ\n\n";
} elseif ($year != $col['year']) {
$year = $col['year'];
$cnt++;
$news .= "
\n\n";
$news .= "
".$year."ǯ\n\n";
$view = false;
}
@mb_convert_variables($enc_in, $enc_db, $col);
if ($view) {
$news .= '- ';
$item = $base_html;
$path = './dat/img/blog/'.$col['mid'].'/index.jpg';
if (is_file($path)) {
$img = '';
} else {
$img = '';
}
$item = str_replace('<-img->', $img, $item);
$title = $col['title'];
$title = html_entity_decode($title, ENT_QUOTES, $enc_in);
$title = strip_tags($title);
$item = str_replace('<-title->', $title, $item);
$item = str_replace('<-date->', date('Y.m.d', $col['vdate']), $item);
$item = str_replace('<-cate->', $category_name_array[$col['cate']], $item);
if ($category_name_array[$col['cate']]=='EVERY ONE') {
$page = 'everyone.php';
} elseif ($category_name_array[$col['cate']]=='ץ쥹롼') {
$page = 'press.php';
} elseif ($col['mainid']==5) {
$page = 'press.php';
} else {
$page = 'sc_activity.php';
}
$item = str_replace('<-link->', '/scjcms/'.$page.'?d='.$col['mid'], $item);
$news .= $item;
$news .= "
\n";
}
}
if ($news) $news .= "
\n\n";
mysqli_free_result($rst);
//$news .= '';
// 2010
//$news .= '
2010ǯ';
//$news .= '
2009ǯ';
// HTMLɽ
header($html_header);
header('Content-Language: ja');
$html = mb_convert_encoding($news, $enc_out, $enc_in);
echo $html;
// MySQL³
$con = mysqli_close($con);
exit;
?>
アニュアルレポート／ニュースレター
<-img->
HTML;
$url = '../news/publications/index.html';
$buff = "";
$fp = fopen($url,"r");
while ( !feof($fp) ) {
$buff .= fgets($fp);
}
fclose($fp);
$buff = preg_replace('/^.*?/s', '', $buff);
$buff = preg_replace('/.*$/s', '', $buff);
$buff = preg_replace('/^.*?
\n";
}
}
if ($news) $news .= "
