{"id":141,"date":"2013-11-04T00:00:00","date_gmt":"2013-11-03T15:00:00","guid":{"rendered":"http:\/\/taitan916.info\/blog\/?p=141"},"modified":"2014-05-21T23:30:54","modified_gmt":"2014-05-21T14:30:54","slug":"post-141","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/141","title":{"rendered":"PHP\u30da\u30fc\u30b8\u30f3\u30b0\u30c6\u30f3\u30d7\u30ec"},"content":{"rendered":"

\u4f7f\u3044\u3084\u3059\u3044\u306e\u304c\u3042\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002<\/p>\n

 <\/p>\n

$page\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= ($_GET['page'] && is_numeric($_GET['page'])) ? $_GET['page'] : 0;
\n$limit\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 50;
\n$offset\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= $page * $limit;<\/p>\n

$sql<\/a> = '
\nSELECT *
\nFROM table
\nLIMIT ' . $offset . ' , ' . $limit . '
\n';<\/p>\n

if ($max_num > 0) { \/\/$max_num\u306f\u7dcf\u4ef6\u6570
\n$paging_html\u00a0\u00a0\u00a0 \u00a0= '';
\n$paging_url\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= 'aaa.php<\/a>?page=';
\n$start\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= ($page - 2 > 0) ? $page - 2 : 0;
\n$total_page\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= ceil($max_num \/ $limit);
\n$end\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0= min($total_page, $start + 6);
\nif ($end == $total_page) {
\n$start = max($start - abs(4 - ($end - $page)), 0);
\n}
\n$paging_html .= $max_num . '\u4ef6\u4e2d ' . ($offset + 1) . '-' . ($offset+$line_num) . '\u4ef6\u3092\u8868\u793a\uff5c';
\n$paging_html .= ($page > 0) ? '<a href=\"' . $paging_url . ($page - 1) . '\"><< \u524d\u3078\u3000<\/a>' : '<< \u524d\u3078\u3000';
\nif ($start > 0) {
\n$paging_html .= '<a href=\"' . $paging_url . '0\">1<\/a> ... ';
\n}
\nfor ($i = $start; $i < $end; $i++) {
\n$paging_html .= ($i == $page) ? '<b>' . ($i + 1) . '<\/b>': '<a href=\"' . $paging_url . $i . '\">' . ($i + 1) . '<\/a>';
\nif ($i != $end - 1) { $paging_html .= '\uff5c'; }
\n}
\nif ($end != $total_page) {
\n$paging_html .= ' ... <a href=\"' . $paging_url . ($total_page - 1) . '\">' . $total_page . '<\/a>';
\n}
\n$paging_html .= ($page < $total_page - 1) ? '<a href=\"' . $paging_url . ($page + 1) . '\">\u3000\u6b21\u3078 >><\/a>' : '\u3000\u6b21\u3078 >>';
\n}<\/p>\n","protected":false},"excerpt":{"rendered":"

\u4f7f\u3044\u3084\u3059\u3044\u306e\u304c\u3042\u3063\u305f\u306e\u3067\u30e1\u30e2\u3002   $page\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 ... <\/p>\n","protected":false},"author":1,"featured_media":1085,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2],"tags":[],"class_list":["post-141","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/comments?post=141"}],"version-history":[{"count":0,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/141\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media\/1085"}],"wp:attachment":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media?parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/categories?post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/tags?post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}