getConnect(); //記事の年を取得 $sql1 = "SELECT distinct to_char(view_date,'YYYY') as yyyy FROM t_page_article " . "WHERE belong_no = '2' "//TYIS . "AND approval = '0' " . "AND delete_flg = '0' " . "AND view_date <= now() " . "ORDER BY yyyy desc"; $years = $db->getAll($sql1); $error_message = "ただ今メンテナンス中です。"; $error_message2 = "該当記事がありません。"; $select_year = ""; if(!array_key_exists('y',$_REQUEST)){ $select_year = $years['0']['yyyy']; } else { //数字チェック if (preg_match("|^\d{4}$|", $_REQUEST['y'])) { //該当年がDBにあるかチェック foreach($years as $key => $val) { if($years[$key]['yyyy'] == $_REQUEST['y']){ $select_year = $_REQUEST['y']; } } } } if($select_year == ""){ header("Location:" . URL_TOP . "tyis/wn/index.php"); } $sql = "SELECT view_date, page_no, sub_title, link_text, pagetype_flg FROM t_page_article WHERE belong_no = '2' AND delete_flg = '0' AND approval = '0' AND to_char(view_date,'YYYY') = '". $select_year ."' AND view_date <= now() ORDER BY view_date DESC, update_date DESC "; $results = $db->getAll($sql); //mb_convert_variables('UTF-8', 'EUC-JP', $results); $count = count($results); $perPage = '20';// 1画面あたりの最大表示件数 // pager $params = array( 'itemData' => $results, 'mode' => 'Jumping', 'perPage' => $perPage, 'totalItems' => $count, 'prevImg' => "> back",//前のページのリンク文字列 'nextImg' => "< more",//前のページのリンク文字列 ); $pager =& Pager::factory($params); $page = $pager->getCurrentPageId();//現在何ページ目か $offset = $pager->getOffsetByPageId();//何件目から何件目か $links = $pager->getLinks(); $topnews = $pager->getPageData(); //現在のページのデータを取得する $DBSurvey->setDisConnect($db); ?> What's New! - Tokyo YMCA International School
  • telephone81-3-3615-5632
  • mail

What's New!

Home>What's New!

\n
". $error_message2 . "
\n\n"; } else { foreach($topnews as $key=>$value){ if($key % 2 == '0'){ echo "
\n"; }else{ echo "
\n"; } $value['view_date'] = mb_substr($value['view_date'],0,10); $value['view_date'] = str_replace('-', '.', $value['view_date']); echo "
{$value['view_date']}
\n"; $str = mb_strlen($value['sub_title']); if($str > '50'){ $text = mb_substr($value['sub_title'], 0, 50) . "…"; } else { $text = $value['sub_title']; } if($value['pagetype_flg'] == '1'){ echo "
{$text}
\n"; } else if ($value['pagetype_flg'] == '2'){ echo "
{$text}
\n"; }else{ echo "
{$text}
\n"; } echo "
\n"; } } ?>
{$links['next']}\n"; } ?> {$links['back']}\n"; } ?>
page top

Accepting Applications 2012-2013 School Year and 2012 Spring Enrollment Program

What's New!

\n"; foreach($years as $key => $value) { echo "
  • {$value['yyyy']}
    • \n"; } echo " \n"; } ?>

    Accredited by Western Assosiation of Schools and Colleges

    Contact us


    Address：2-2-20 Toyo, Koto-ku, Tokyo, Japan 135-0016 Map

    Phone：81-3-3615-5632
    Fax：81-3-5635-1023

    Copyright 2010. Tokyo YMCA International School. All Rights Reserved.