Quero saber como posso pegar a categoria de cada post. Fiz esse foreach, mas s\u00f3 a categoria eu n\u00e3o consigo pegar.<\/p>\n
\n\tglobal $wpdb;<\/p>\n
\t$querystr = “
\n\tSELECT DISTINCT $wpdb->posts.*
\n\tFROM $wpdb->posts, $wpdb->postmeta
\n\tWHERE $wpdb->posts.ID = $wpdb->postmeta.post_id
\n\tAND $wpdb->posts.post_status = ‘publish’
\n\tAND $wpdb->posts.post_type = ‘ad_listing’
\n\tAND $wpdb->posts.post_parent = ‘0’
\n\tORDER BY $wpdb->posts.post_date DESC
\n\t“;
\n\t$pageposts = $wpdb->get_results($querystr, OBJECT);<\/p>\n<\/blockquote>\n\n<?php foreach($pageposts as $post) : setup_postdata($post); $postid = $post->ID; $user = get_user_by(“id”, $post->post_author); $categories = get_the_category($post->ID); ?>
\n\t\t\t<tr>
\n\t\t\t\t<td valign=”top”><input type=”checkbox” value=”<?php echo $postid; ?>” \/><\/td>
\n\t\t\t\t<td><?php echo get_post_meta($postid, ‘cp_unique_id’, true); ?><\/td>
\n\t\t\t\t<td><?php echo $user->display_name; ?><\/td>
\n\t\t\t\t<td><?php echo $post->post_title; ?><\/td>
\n\t\t\t\t<td><?php echo get_post_meta($postid, ‘cp_price’, true); ?><\/td>
\n\t\t\t\t<td><?php echo date_i18n(“j \\d\\e F \\d\\e Y \\\u00e0\\s H:i:s”, strtotime($post->post_date)); ?><\/td>
\n\t\t\t\t<td><?php echo date_i18n(“j \\d\\e F \\d\\e Y \\\u00e0\\s H:i:s”, strtotime(get_post_meta($post->ID, ‘cp_sys_expire_date’, true))); ?><\/td>
\n\t\t\t\t<td><?php echo $post->post_status; ?><\/td>
\n\t\t\t\t<td><?php echo $user->user_email; ?><\/td>
\n\t\t\t\t<td><?php echo get_user_meta($post->post_author, ‘user_tel_fixo’, true); ?><\/td>
\n\t\t\t\t<td><?php echo get_post_meta($postid, ‘cp_city’, true); ?><\/td>
\n\t\t\t\t<td><?php echo get_post_meta($postid, ‘cp_state’, true); ?><\/td>
\n\t\t\t\t<td><?php echo $categories[0]->cat_name; ?><\/td>
\n\t\t\t<\/tr>
\n\t\t\t<?php endforeach; ?><\/p>\n<\/blockquote>\n","protected":false},"template":"","class_list":["post-31735","topic","type-topic","status-closed","hentry","topic-tag-categoria"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/br.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/31735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/br.wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/br.wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/br.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/31735\/revisions"}],"wp:attachment":[{"href":"https:\/\/br.wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=31735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}