{"id":1673,"date":"2020-01-21T10:11:15","date_gmt":"2020-01-21T01:11:15","guid":{"rendered":"http:\/\/wp.ultimai.org\/wp\/?p=1673"},"modified":"2021-03-22T07:33:39","modified_gmt":"2021-03-21T22:33:39","slug":"post-1673","status":"publish","type":"post","link":"https:\/\/wp.ultimai.org\/?p=1673","title":{"rendered":"WP_Query\u3092\u4f7f\u308f\u306a\u3044\u30eb\u30fc\u30d7\u3067\u7279\u5b9a\u306e\u30ab\u30c6\u30b4\u30ea\u306e\u307f\u8868\u793a\u3057\u3066\u30da\u30fc\u30b8\u30e3\u30fc\u3082\u3064\u3051\u308b"},"content":{"rendered":"<h3>Woocommerce \u306e\u5546\u54c1\u30ab\u30c6\u30b4\u30ea<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\"><code>\r\n\/* \u30c7\u30fc\u30bf\u306e\u8868\u793a\u6307\u5b9a *\/\r\n$type =15;  \/\/ \u30ab\u30c6\u30b4\u30eaID \r\n$item_count = 6; \/\/1\u30da\u30fc\u30b8\u306b\u8868\u793a\u3057\u305f\u3044\u30a2\u30a4\u30c6\u30e0\u6570 \r\n$sp = empty($_GET['pg']) ? 1 : $_GET['pg'] ;\r\n\r\n$field = \"SELECT object_id , p.post_title ,post_content,post_date,post_excerpt,post_name,\r\np.post_type , p.post_status, m.stock_quantity , m.min_price, m.max_price ,meta_value\" ;\r\n\r\n$query = \"\r\nFROM `$wpdb-&gt;term_relationships` as t\r\nleft join $wpdb-&gt;posts as p on p.id = t.object_id \r\nleft join `$wpdb-&gt;wc_product_meta_lookup` as m on m.product_id = t.object_id \r\nleft join `$wpdb-&gt;postmeta` as e on e.post_id = t.object_id \r\nWHERE `term_taxonomy_id` = %d AND p.post_type = 'product' AND p.post_status = 'publish' \r\nAND e.meta_key = '_price' \" ;\r\n\r\n$sql = $field . $query .\" LIMIT %d, $item_count;\";\r\n\r\n$results = $wpdb-&gt;get_results( $wpdb-&gt;prepare( $sql ,$type ,($sp-1)*$item_count) );\r\nforeach($results as $row) var_dump($row);\r\n[\/highlight_php]\r\n\r\n\r\n<h3>\u3053\u306e\u30da\u30fc\u30b8\u306e\u30da\u30fc\u30b8\u30e3\u30fc<\/h3>\r\n[highlight_php]\r\n&lt;?php    \/* \u4ee5\u4e0b\u3001\u30da\u30fc\u30b8\u30e3\u30fc\u306e\u8868\u793a *\/\r\n$field = \"SELECT count(*) \";\r\n$sql = $field . $query ;\r\n$product_count = $wpdb->get_var( $wpdb->prepare( $sql , $type) );\r\n$product_page = ceil( $product_count\/$item_count); \/\/\u30da\u30fc\u30b8\u6570\r\n?&gt;\r\n\r\n&lt;nav class=\"undernav pagination\">\r\n&lt;?php\r\n   if( $sp > 1){\r\n      echo '<a href=\"?pg=',$sp-1,'\"  class=\"prev\">\u2039 \u524d\u3078 <\/a>';\r\n   } \r\n?&gt;\r\n   <span class=\"page_num\">Page <?=$sp?> of <?=$product_page?><\/span>\r\n &lt;?php\r\n   for( $i=1 ; $i <= $product_page; $i++){\r\n      if( $i == $sp ){\r\n         echo '<span class=\"current pager\">', $i,'<\/span>';\r\n      }else{\r\n         echo '<a href=\"?pg=',$i,'\" class=\"pager\">',$i,'<\/a>';\r\n      }\r\n   }\r\n\r\n   if( $sp < $product_page){\r\n      echo '<a href=\"?pg=',$sp+1,'\"  class=\"next\">\u6b21\u3078 \u203a<\/a>';\r\n   } \r\n ?&gt;\r\n   \r\n   \r\n<\/nav>\r\n\r\n\r\n <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Woocommerce \u306e\u5546\u54c1\u30ab\u30c6\u30b4\u30ea \/* \u30c7\u30fc [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1673","post","type-post","status-publish","format-standard","hentry","category-cms"],"_links":{"self":[{"href":"https:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/posts\/1673","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.ultimai.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1673"}],"version-history":[{"count":2,"href":"https:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/posts\/1673\/revisions"}],"predecessor-version":[{"id":2006,"href":"https:\/\/wp.ultimai.org\/index.php?rest_route=\/wp\/v2\/posts\/1673\/revisions\/2006"}],"wp:attachment":[{"href":"https:\/\/wp.ultimai.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.ultimai.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.ultimai.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}