_db_server, $consts->_db_user, $consts->_db_password); mysqli_query($db,"SET NAMES utf8"); mysqli_select_db($db, $consts->_db_name); $db_tb = $consts->_news_tb; $query = "SELECT * FROM $db_tb WHERE (up_fg = 1) ORDER BY entry_date DESC";// 日付でソート $query2 = $query; // 表示行の管理 -------------------------------------------------- $row_max = 10; $offset = $page_num*$row_max; $query .= " limit $row_max offset $offset"; // --------------------------------------------------------------- $res = mysqli_query($db, $query); // 要素のカウンタ(最新) $res2 = mysqli_query($db, $query2); $cnt = $res2->num_rows; ?>
=$row["title"]?>
<<< | ◀◀◀ | 1) echo "( ",$page_num + 1, "/", ceil($cnt / $row_max), " )"; ?> | ▶▶▶ | >>> |
お気軽にお問い合わせください
お電話でのお問合せはこちら 028-684-0500