{"id":3494,"date":"2015-02-09T01:58:10","date_gmt":"2015-02-09T01:58:10","guid":{"rendered":"http:\/\/www.wpadmin.cn\/blog\/?p=3494"},"modified":"2015-02-09T01:58:10","modified_gmt":"2015-02-09T01:58:10","slug":"%e6%80%8e%e6%a0%b7%e7%94%a8sql%e8%af%ad%e5%8f%a5%e8%b0%83%e7%94%a8wordpress%e6%9f%90%e5%88%86%e7%b1%bb%e4%b8%8b%e7%9a%84%e6%89%80%e6%9c%89%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"https:\/\/www.wpadmin.cn\/blog\/3494.html","title":{"rendered":"\u600e\u6837\u7528sql\u8bed\u53e5\u8c03\u7528wordpress\u67d0\u5206\u7c7b\u4e0b\u7684\u6240\u6709\u4fe1\u606f"},"content":{"rendered":"
\n
<\/div>\n
    \n
  1. <div <\/span>class<\/span>=<\/span>“mb-a left dInline mb-dl”<\/span>>  <\/span><\/span><\/li>\n
  2.           <\/span><\/li>\n
  3.         <?php    <\/span><\/li>\n
  4.         \/\/\u7528sql\u8bed\u53e5\u8c03\u7528\u67d0\u5206\u7c7b\u4e0b\u7684\u6240\u6709\u4fe1\u606f,$CID\u4e3a\u5206\u7c7bid<\/span>  <\/span><\/span><\/li>\n
  5.         $CID=1<\/span>;  <\/span><\/span><\/li>\n
  6. global $wpdb;    <\/span><\/li>\n
  7. $rs = $wpdb->get_results(“select * from wp_posts,wp_term_relationships,wp_term_taxonomy where ID=object_id and wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id and post_type=’post’ and post_status = ‘publish’ and wp_term_relationships.term_taxonomy_id = $CID and taxonomy = ‘category’ order by ID asc limit 0,3”<\/span> );    <\/span><\/span><\/li>\n
  8. \/\/p($rs);<\/span>  <\/span><\/span><\/li>\n
  9. foreach($rs as $cat)    <\/span><\/li>\n
  10. {?>    <\/span><\/li>\n
  11.             <div class<\/span>=<\/span>“mbDiv”<\/span>>  <\/span><\/span><\/li>\n
  12.   <\/span><\/li>\n
  13.                     <img src=“<?php <\/span> <\/span><\/li>\n
  14.                     \/\/\u6b63\u5219\u5339\u914d\u5185\u5bb9\u4e2d\u7684\u56fe\u7247<\/span> <\/span><\/li>\n
  15.                     $post_thumbnail_src = ”;<\/span> <\/span><\/li>\n
  16.         ob_start();<\/span> <\/span><\/li>\n
  17.         ob_end_clean();<\/span> <\/span><\/li>\n
  18.         $output = preg_match_all(‘\/<img.+src=[\\'”<\/span>]([^\\’<\/span>“]+)[\\'”<\/span>].*>\/i’, $cat->post_content, $matches);  <\/span><\/span><\/li>\n
  19.         $post_thumbnail_src = $matches [1<\/span>] [<\/span>0<\/span>];     <\/span><\/span><\/li>\n
  20.           <\/span><\/li>\n
  21.                     echo $post_thumbnail_src; ?>” width=”<\/span>186<\/span>” height=”<\/span>132<\/span>” \/>  <\/span><\/span><\/li>\n
  22.                     <p>  <\/span><\/li>\n
  23.                         &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span><?php echo $cat->post_title;?><\/span>  <\/span><\/li>\n
  24.                         &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span> <?php echo $cat->post_excerpt;?> <\/span>  <\/span><\/li>\n
  25.                     <\/p>  <\/span><\/li>\n
  26.                   <\/span><\/li>\n
  27.             <\/div>  <\/span><\/li>\n
  28.               <\/span><\/li>\n
  29.             <?php }?>  <\/span><\/li>\n
  30.              <\/span><\/li>\n
  31.         <\/div>  <\/span><\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    <div class=“mb-a left dInline mb-dl”>&nbsp… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[123],"tags":[181,117],"_links":{"self":[{"href":"https:\/\/www.wpadmin.cn\/blog\/wp-json\/wp\/v2\/posts\/3494"}],"collection":[{"href":"https:\/\/www.wpadmin.cn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wpadmin.cn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wpadmin.cn\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wpadmin.cn\/blog\/wp-json\/wp\/v2\/comments?post=3494"}],"version-history":[{"count":0,"href":"https:\/\/www.wpadmin.cn\/blog\/wp-json\/wp\/v2\/posts\/3494\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wpadmin.cn\/blog\/wp-json\/wp\/v2\/media?parent=3494"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wpadmin.cn\/blog\/wp-json\/wp\/v2\/categories?post=3494"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wpadmin.cn\/blog\/wp-json\/wp\/v2\/tags?post=3494"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}