Pegar categoria do post
-
Quero saber como posso pegar a categoria de cada post. Fiz esse foreach, mas só a categoria eu não consigo pegar.
global $wpdb;
$querystr = “
SELECT DISTINCT $wpdb->posts.*
FROM $wpdb->posts, $wpdb->postmeta
WHERE $wpdb->posts.ID = $wpdb->postmeta.post_id
AND $wpdb->posts.post_status = ‘publish’
AND $wpdb->posts.post_type = ‘ad_listing’
AND $wpdb->posts.post_parent = ‘0’
ORDER BY $wpdb->posts.post_date DESC
“;
$pageposts = $wpdb->get_results($querystr, OBJECT);<?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); ?>
<tr>
<td valign=”top”><input type=”checkbox” value=”<?php echo $postid; ?>” /></td>
<td><?php echo get_post_meta($postid, ‘cp_unique_id’, true); ?></td>
<td><?php echo $user->display_name; ?></td>
<td><?php echo $post->post_title; ?></td>
<td><?php echo get_post_meta($postid, ‘cp_price’, true); ?></td>
<td><?php echo date_i18n(“j \d\e F \d\e Y \à\s H:i:s”, strtotime($post->post_date)); ?></td>
<td><?php echo date_i18n(“j \d\e F \d\e Y \à\s H:i:s”, strtotime(get_post_meta($post->ID, ‘cp_sys_expire_date’, true))); ?></td>
<td><?php echo $post->post_status; ?></td>
<td><?php echo $user->user_email; ?></td>
<td><?php echo get_user_meta($post->post_author, ‘user_tel_fixo’, true); ?></td>
<td><?php echo get_post_meta($postid, ‘cp_city’, true); ?></td>
<td><?php echo get_post_meta($postid, ‘cp_state’, true); ?></td>
<td><?php echo $categories[0]->cat_name; ?></td>
</tr>
<?php endforeach; ?>
- O tópico ‘Pegar categoria do post’ está fechado para novas respostas.