How can I list all WordPress users, their email adress, post title and post status?

You can do that with a simple loop assuming that the users are also the authors of the post,
create a template page, and copy the inside of your page.php to it.

then replace the loop part with this code:

<?php
$args = array(
    'post_type' => 'company-listing', //change this to your actual CPT name
    'posts_per_page' => -1, //-1 to get all or any number you want to use with pagination
);
query_posts($args);
if ( have_posts() ) : while ( have_posts() ) : the_post(); ?>
User, email, post title, post status
    <div class="post company-listing">
    <ul>
<?php  $user_info = get_userdata($post->post_author); ?>
        <li class="user">
            <?php echo $user_info->user_nicename; ?>
        </li>
        <li class="email">
            <?php echo $user_info->user_email; ?>
        </li>
        <li class="title">
            <a href="https://wordpress.stackexchange.com/questions/14708/<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title_attribute(); ?>"><?php the_title(); ?></a>
        </li>
        <li class="status">
            <?php echo $post->post_status; ?>
        </li>
    </ul>
</div>
<div style="clear:both"></div>

<?php endwhile; ?>

    <?php else: ?>

        <p class="no-data">
            <?php _e('Sorry, no page matched your criteria.'); ?>
        </p><!-- .no-data -->
 <?php endif; ?>

and add this little code css to style it right:

<style type="text/css">
company-listing ul li{ float: left;padding: 2px;}
</style>

now you didn’t specify what is “USER” so i just showed you how to use user_nicename but after this line $user_info = get_userdata($post->post_author); you can use $user_info with:

  • user_firstname
  • user_lastname
  • ID
  • user_login
  • user_pass
  • user_nicename
  • user_email
  • user_url
  • user_registered
  • display_name

and a few more.

As for status i assume you are talking about the post_status so you will need to add 'post_status' => array('publish','pending','draft','future','private',....) to your $args.

and if you are talking about a custom filed then just call that field with get_post_meta($post->ID,'status_field_name',true);

Hope this helps

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)