php - 如何使用源和图像获取 wp_posts 详细信息

Question

我使用以下查询来获取 tittle,data,tagss content,slug,parent id 。这工作正常，但我需要获取与 wp_postmeta 表有关系的帖子图像和图像源，所以我在第一个查询的 while 循环中使用了第二个查询

第一个查询:- 选择 wp_posts.ID 作为 Id，wp_posts.post_title 作为标题，wp_posts.post_date 作为日期，

  GROUP_CONCAT(wp_terms.name) AS TAGS, wp_posts.post_content as CONTENT,wp_terms.term_id,wp_terms.slug,wp_posts.post_parent as parent_id FROM wp_terms

  INNER JOIN wp_term_taxonomy ON wp_terms.term_id  = wp_term_taxonomy.term_id

  INNER JOIN wp_term_relationships ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id

  INNER JOIN wp_posts ON wp_posts.ID = wp_term_relationships.object_id

  WHERE post_type LIKE 'post' AND post_status LIKE 'publish' AND wp_terms.slug in ('interview','variety','lastpage','sport','arab-global','opinion','business','uae','firstpage')  

GROUP BY wp_posts.ID order by post_date limit 150

第二个查询为

select select wp_postmeta.meta_value from wp_postmeta left join wp_posts on wp_postmeta.post_id in ('".$row['Id']."') = wp_posts.id in ('".$row['Id']."') and meta_key='_wp_attached_file'" 

但我没有得到任何细节，所以我将与 wp_post 表的 parent_id 的关系作为第三个查询而不是第二个查询。

select select wp_postmeta.meta_value from wp_postmeta left join wp_posts on wp_postmeta.post_id in ('".$row['parent_id']."') = wp_posts.id in ('".$row['parent_id']."') and meta_key='_wp_attached_file'"

之后我使用单个查询来获取所有记录，如下所示

SELECT wp_posts.ID as Id,wp_posts.post_title as Title,wp_posts.post_date as DATE,wp_postmeta.meta_key,wp_postmeta.meta_value,
GROUP_CONCAT(wp_terms.name) AS TAGS, wp_posts.post_content as CONTENT,wp_terms.term_id,wp_terms.slug,wp_posts.post_parent as parent_id FROM wp_terms
INNER JOIN wp_term_taxonomy ON wp_terms.term_id  = wp_term_taxonomy.term_id
INNER JOIN wp_term_relationships ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
INNER JOIN wp_posts ON wp_posts.ID = wp_term_relationships.object_id
INNER JOIN wp_postmeta ON(wp_posts.ID = wp_postmeta.post_id)
WHERE post_type LIKE 'post' AND post_status LIKE 'publish'
GROUP BY wp_posts.ID order by post_date limit 150

但是在那个查询中我有多个 meta_key 和多个 meta 值有任何有用的解决方案所以我可以通过我的 sql 和 php 简单地获取 wp_post 详细信息及其源和图像

Answer 1

试试这个

$meta_value_id= "select meta_value from wp_postmeta where meta_key='_thumbnail_id' and post_id='".$row['Id']."'";
$query_run_meta= mysql_query($meta_value_id); $row1= mysql_fetch_assoc($query_run_meta);

            $meta_image=  "select meta_value from wp_postmeta where meta_key='_wp_attached_file' and post_id='".$row1['meta_value']."'";   
            $query_meta=  mysql_query($meta_image);
            $row2=  mysql_fetch_assoc($query_meta);

现在您可以从 $row2 获取图像源。