include_once "../phpinc/text.inc"; include_once "../phpinc/config.inc"; include_once "../phpinc/head.php"; include_once "../phpinc/class.inc"; include_once "../phpinc/Pager.php"; // RPP define('RPP', 5); // ページ番号初期化 $page = (isset($_REQUEST['page'])) ? $_REQUEST['page'] : 1; // offset / limit $offset = ($page - 1) * RPP; $limit = RPP; $db = new commFunc; $db->class_db_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE); $sql = "select * from tbl_staff_diary where col_active=1 order by col_seqid desc limit $offset, $limit "; $res = $db->class_db_select($sql); $sql = "select count(*) as cnt from tbl_staff_diary where col_active=1 "; $cnt = $db->class_db_select($sql); $total_rows = $cnt[0]['cnt']; // GET パラメータ ぺージャ $pager = Pager::GETParam($page, RPP, $total_rows); ?>
ただいま準備中です。 しばらくお待ちください。 |