歴史の目的をめぐって寛政重修諸家譜人名検索

　　　寛政重修諸家譜人名検索

1) { // 例：２ページ目の場合は、『(2 × 10) - 10 = 10』 $start = ($page * 10) - 10; } else { $start = 0; } // postsテーブルから10件のデータを取得する $kanseichosyukafu = $pdo->prepare(" SELECT * FROM kanseichosyukafu ORDER BY no LIMIT {$start}, 10 "); $kanseichosyukafu->execute(); $kanseichosyukafu = $kanseichosyukafu->fetchAll(PDO::FETCH_ASSOC); foreach ($kanseichosyukafu as $row) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '

', "　　NO.", $row['no'], "　", $row['wahon'], "　", $row['shizoku'], "　", $row['ie'], '

', "　　", '', $row['sairokujinbutsu'],'', "　", $row['yomigana'], '

', "　　", $row['besshokani'], '

', "　　", "父：", $row['father'], "　　母：", $row['mother'], "　　配偶者：", $row['haigusya'], '

', "　　", "生没年：", $row['byw'], "（", $row['bys'], "）", $row['bmd'], "-", $row['dyw'], "（", $row['dys'], "）" , $row['dmd'], "　享年：" , $row['old'], '

', "　　", "刊本：", $row['kanpon'], " ", $row['kanponpage'],'

', "　　", $row['wahonlink'], '

', "　　", $row['kanponlink'], '

'; echo '

'; } // postsテーブルのデータ件数を取得する $page_num = $pdo->prepare(" SELECT COUNT(*) no FROM kanseichosyukafu "); $page_num->execute(); $page_num = $page_num->fetchColumn(); // ページネーションの数を取得する $pagination = ceil($page_num / 10); ?>