show-required-levels-in-posts-dashboard.php

<?php

// Example for showing membership ID in posts dashboard.

function my_pmpro_custom_posts_table_head( $columns ) {

    $columns['membership_ids']  = 'Memberships';
    return $columns;

}
add_filter('manage_posts_columns', 'my_pmpro_custom_posts_table_head');

function my_pmpro_posts_table_content( $column_name, $post_id ) {
	global $wpdb;
	if ( 'membership_ids' == $column_name ) {

		// Get membership data for each post.
		$results = $wpdb->get_results( "SELECT membership_id FROM $wpdb->pmpro_memberships_pages WHERE page_id = " . $post_id );

		
		if ( empty( $results ) ) {
			echo 'none';
		} else {
			if ( is_array( $results ) ) {
				foreach( $results as $level ) {
					$levels .= $level->membership_id;
					$levels .= ', ';
				}

				echo $levels;
			}
		}
	}
}
add_action( 'manage_posts_custom_column', 'my_pmpro_posts_table_content', 10, 2);