プレスルーム
┃取材の受付・素材の提供について
プレスルームでは、報道関係者に向けた情報を提供しております。また、写真や映像素材等の提供、スタッフインタビューや現地取材のコーディネートに関しましても対応いたします。お問い合わせは、広報担当までご連絡ください。
TEL：03-6859-0011 / FAX：03-6859-0069
E-mail：
japan.press@savethechildren.org
団体概要はこちら
プレスリリース
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);
// ǿʬmidå
$newlist_array = array();
$sql = "select mid from scj_blog where view = '1' order by vdate desc limit 10";
@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);
$newlist_array[] = $col['mid'];
}
mysqli_free_result($rst);
$now = time();
// եꥹ
$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";
$sql .= " , scj_blog.cate";
$sql .= " , scj_blog.title";
$sql .= " , scj_blog.vdate";
$sql .= " , scj_category.sub";
$sql .= " , scj_category.mainid";
$sql .= " , date_format(from_unixtime(scj_blog.vdate), '%Y') as year";
$sql .= " from scj_blog";
$sql .= " inner join scj_category on scj_blog.cate = scj_category.mid";
$sql .= " where scj_blog.view = '1'";
$sql .= " and scj_blog.vdate <= '{$now}'"; //2022.06.29 IL ɲ
$sql .= " and scj_blog.cate = '22'";
$sql .= " order by scj_blog.vdate desc";
// ǯɽ˽20150216
//$sql = "select scj_blog.mid, scj_blog.cate, scj_blog.title, scj_blog.vdate, case when month(from_unixtime(scj_blog.vdate)) > 3 then year(from_unixtime(scj_blog.vdate)) else year(from_unixtime(scj_blog.vdate))-1 end 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";
@mb_convert_variables($enc_db, $enc_in, $sql);
$rst = mysqli_query($con, $sql);
$cnt = 0;
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";
}
@mb_convert_variables($enc_in, $enc_db, $col);
$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);
// 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;
?>
\n";
}
if ($news) $news .= "
