//表示用テンプレートの読み込み
$dbr->loadTemplateFromFile("../include/template_kiji.txt", false );
//NULLの場合の文字列を定義
$dbr->null_str = " ";
print $dbr->error_message;
if( !$debug_mode_p ) {
$dbr->GetDirectSQL( "select a.kiji_naiyou, a.title, b.order_no from kiji_data a, page_data b where a.kiji_id=b.kiji_id and b.page_id=1 and (b.flag IS NULL or b.flag!=1) and b.kind=1 order by b.order_no;" );
} else {
$dbr->GetDirectSQL( "select a.kiji_naiyou, a.title, b.order_no from kiji_data a, page_data b where a.kiji_id=b.kiji_id and b.page_id=1 and b.kind=1 order by b.order_no;" );
}
print $dbr->error_message;
//テンプレートを使って表示
print $dbr->DispRowWithTemplate( true, false, false );
?>
//カレンダー
//$ret = Mk_Calender();
$ret = Mk_Calender( $year, $month, true, $dbr, "", "blog.html" );
print $ret;
?>
最近の記事
if( !$debug_mode_p ) {
$sql = "select blog_naiyou, blog_id, title from blog_data where flag IS NULL";
$sql .= " order by blog_id DESC limit 5";
$dbr->GetDirectSQL( $sql );
} else {
$sql = "select blog_naiyou, blog_id, title from blog_data";
$sql .= " order by blog_id DESC limit 5";
$dbr->GetDirectSQL( $sql );
}
//表示用テンプレートの読み込み
$dbr->loadTemplateFromFile("../include/template_blog_title.txt", false );
//テンプレートを使って表示
print $dbr->DispRowWithTemplate( true, false, false );
?>
過去の記事
//年月毎のリスト作成
$sql = "select blog_id,"
. " to_char( tourokubi, 'YYYY/MM') AS t_ym,"
. " date_part( 'year',tourokubi ) AS t_y,"
. " date_part( 'month',tourokubi ) AS t_m"
. " from blog_data";
if( !$debug_mode_p ) {
$sql .= " where flag IS NULL";
}
$sql .= " group by to_char( tourokubi, 'YYYY/MM'),"
. " date_part( 'year',tourokubi ),"
. " date_part( 'month',tourokubi ),"
. " blog_id"
. " order by"
. " to_char( tourokubi, 'YYYY/MM') DESC,"
. " blog_id DESC;";
$dbr->GetDirectSQL( $sql );
//print $dbr->error_message;
//print $sql;
//print_r($dbr->field_data);
//print "ct=" . $dbr->rows . "
";
$no = 0;
$tym = "";
$ty = "";
$tm = "";
$fd_data = array( array() );
$fd_data = $dbr->field_data;
$txt = "";
for( $i=0; $i<$dbr->rows; $i++ ) {
if( $fd_data[ $i ][ 1 ] != $tym ) {
//月が違う場合
$no = $fd_data[ $i ][ 0 ];//その月の最大のblog_id
$tym = $fd_data[ $i ][ 1 ];
$ty = $fd_data[ $i ][ 2 ];
$tm = $fd_data[ $i ][ 3 ];
$txt = "
" . $ty . "年 " . $tm . "月";
print $txt . "
\n";
}
}
?>
" width="201" height="64" />
=getSiteInfo( $dbr, "address");?>
//表示用テンプレートの読み込み
$dbr->loadTemplateFromFile("../include/template_blog.txt", false );
//NULLの場合の文字列を定義
$dbr->null_str = " ";
print $dbr->error_message;
//デフォルトでは最新10件
if( !$debug_mode_p ) {
$sql = "select count(*) from blog_data where flag IS NULL";
if( !empty( $where ) )$sql .= " and " . $where;
$row = $dbr->GetCount( $sql );
$sql = "select blog_id, blog_naiyou, tourokubi, title from blog_data where flag IS NULL";
if( !empty( $where ) )$sql .= " and " . $where;
$sql .= " order by blog_id DESC limit " . $kp . " offset " . $offset;
$dbr->GetDirectSQL( $sql );
} else {
$sql = "select count(*) from blog_data";
if( !empty( $where ) )$sql .= " where " . $where;
$row = $dbr->GetCount( $sql );
$sql = "select blog_id, blog_naiyou, tourokubi, title from blog_data";
if( !empty( $where ) )$sql .= " where " . $where;
$sql .= " order by blog_id DESC limit " . $kp . " offset " . $offset;
$dbr->GetDirectSQL( $sql );
}
//print $sql;
$dbr->list_all_ct = $row;
$dbr->offset_row = $offset;
print $dbr->error_message;
//ナビ設定
$dbr->SetNavi( "blog.html", $get_param , "of"," " ,$kp, $pp );
//ナビゲーションの表示
$ret = $dbr->loadTemplateFromFileNavi("../include/template_navi_blog.txt", false );
//print "
[ loadTemplateFromFileNavi Result]
";
//print_r( $ret );
//print "
";
//上ナビ
print $dbr->DispNaviWithTemplate( true, false );
//テンプレートを使って表示
print $dbr->DispRowWithTemplate( true, false, false );
//下ナビ
print $dbr->DispNaviWithTemplate( true, false );
?>