How can I list all pages with their templates?

Question

I want to list all site pages with the template they use.

Is there a mod to wp_list_pages which does this?

Answer 1

https://codex.wordpress.org/Function_Reference/get_page_template_slug

a basic query to get all pages, sorted by title, then output page title and template file name:

$args = array(
    'post_type' => array( 'page' ),
    'order' => 'ASC',
    'orderby' => 'title'
    );
$the_query = new WP_Query( $args );
if ( $the_query->have_posts() ) {
    while ( $the_query->have_posts() ) {
        $the_query->the_post();
        echo '<p>'; 
        the_title();
        echo ' - ';
        echo get_page_template_slug(); 
        echo '</p>';
    }
    wp_reset_postdata();
}

Answer 2

If you wish to get a list of posts within all post types that are using a template, use:

$args = array(
        'post_type' => 'any',
        'order' => 'ASC',
        'orderby' => 'title',
        'posts_per_page' => -1
    );
    $query = new WP_Query($args);
    if ($query->have_posts()) {
        while ($query->have_posts()) {
            $query->the_post();
            if (get_page_template_slug($post->ID)) {
                echo '<a href="' . get_the_permalink() . '">' . get_the_title() . ' - ' . esc_html(get_page_template_slug($post->ID)) . '</a><br>';
            }
        }
        wp_reset_postdata();
    }

Can be a large query though.

Answer 3

I have tried flowing code to get all page with template, and worked perfect for me. this code purpose was to get all custom page template,as i was developed single page template.

$args = array(
    "post_type" => "page",
    "order" => "ASC",
    "orderby" => "menu_order"
);
$the_query = new WP_Query( $args );
if ( have_posts() ) {
    while ( $the_query->have_posts() ) {
        $the_query->the_post();
        ?>
        <div id="post-<?php the_ID() ?>">
        <?php
        global $post;
        $slug = $post->post_name;
        get_template_part("page", $slug);
        ?>
        </div>
        <?php
    }
    wp_reset_postdata();
}

Answer 4

Rather than do this in PHP, you can do it with this mysql:

SELECT distinct meta_value FROM `wp_postmeta` WHERE meta_key='_wp_page_template'

I just needed it for a quick check so that I could clean up unused templates with the theme_page_templates filter.

Answer 5

Using phpmyadmin (sql) you can run this query to get a list of all pages with its used template:

SELECT p.post_name, p.post_title, meta_key, meta_value FROM `wp_postmeta` INNER JOIN wp_posts p ON p.ID = post_id WHERE meta_key='_wp_page_template' ORDER BY meta_value, p.post_name

Answer 6

This is an old question, but for anyone coming here now:

You could use WP-CLI - https://wp-cli.org/

It might already be installed, depending on where you're working.

The relevant command is: https://developer.wordpress.org/cli/commands/post/list/

For example, if I want the pages:

wp post list --post_type=page --fields=name,url,page_tempalte

You could even get a CSV:

wp post list --post_type=page --fields=name,url,page_tempalte > pages.csv