permalink list (archive)

  • philgreen

    (@philgreen)


    14 years, 10 months ago

    I’m trying to find a list of all posts on my blog, with author, date, title and url included.

    I’m at work trying to figure this out. My boss is trying to get a list of all of the permalinks of posts on our company’s blog so we an do SEO analysis on them.

    I exported wp_posts and cleaned it up, removing all but those 4 fields, but it just shows the unpretty permalink “?p=664” for example, which isn’t the way that google’s SEO data is listed, they use “blogname.com/date/title-of-the-post”. The post title and date are in the wp_posts, so I guess I could figure out some macro or regexp to add the columns together and replace all the spaces with dashes, but there must be a simpler way.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter philgreen

    (@philgreen)

    14 years, 10 months ago

    I figure I should make an archive.php and use this line:

    <?php wp_get_archives(‘type=postbypost&limit=200&format=custom&after=’); ?>

    But I want to include date, author and post title in there also, not just post title and link to post.

    Thread Starter philgreen

    (@philgreen)

    14 years, 10 months ago

    I figued it out and am posting here in case someone else has the same problem. I did like this:

    <table>
    <?php query_posts(‘showposts=10’); ?>
    <?php $posts = get_posts(‘numberposts=1200’);
    foreach ($posts as $post) : start_wp(); ?>

    <tr>
    <td><?php the_time(‘m/j/y’) ?></td>
    <td><?php the_title(); ?></td>
    <td>“><?php the_permalink() ?></td>
    <td><?php the_author() ?></td>
    </tr>
    <?php endforeach; ?>
    </table>

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘permalink list (archive)’ is closed to new replies.