How to extract all your Wordpress post URLs [How-to]

A

Axelz

Registered Member
Joined
Feb 19, 2009
Messages
67
Reaction score
33
Do you need a list of links to all the posts of your Wordpress site?
This will come in handy when you want to do linking to posts within your own network, want to post comments on your own blogs using ScrapeBox on your own blogs linking to your other sites, etc. etc.

Open notepad or any other text editor and paste the following code inside:

Code: 
<?php

require_once('../wp-blog-header.php');
query_posts('&showposts=-1&order=ASC');

while (have_posts()) : the_post(); ?>

<?php the_permalink(); ?>|<?php the_title(); ?>|<?php the_tags(); ?>
<br />

<?php endwhile; ?>
Save the file with any name you want, we'll use postlinks.php in this example, but make sure it has the .php extension. Upload this file to your /wp-content/ folder.

Now in your favorite browser bring up http://www.yoursite.com/wp-content/postlinks.php

This will return your links in this format:

http://www.yoursite.com/link-to-post | Name of your post | Tags

If you only need the link take out the code for the_title and the_tags as well as the delimiter.

Now you can use this list for whatever you want.
 
Advertise on BHW
This is monster if I can get it to work. I'm getting the following error:

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32 bytes) in /home/gator11/public_html/NAMEOFWEBSITE.COM/wp-includes/meta.php on line 197

Any clues?
 
bhatsuccess said:
This is monster if I can get it to work. I'm getting the following error:

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32 bytes) in /home/gator11/public_html/NAMEOFWEBSITE.COM/wp-includes/meta.php on line 197

Any clues?
Click to expand...
From WP support forum:

1. Try adding this line to your wp-config.php file:
define('WP_MEMORY_LIMIT', '64M');

2. If you have access to your PHP.ini file, change the line in PHP.ini
If your line shows 32M try 64M:
memory_limit = 64M ; Maximum amount of memory a script may consume (64MB)

3. If you don't have access to PHP.ini try adding this to an .htaccess file:
php_value memory_limit 64M

4. Talk to your host.
Click to expand...
 
The Hostgator hosting I have is actually superb. I have hosting accounts at other hosts also and they are terrible for autoblogs.

Ok let me try to work with this...thanks
 
It works great! Thanks so much. I was looking for way to scrape my own blog post for mass commenting.
 
CyberSEO said:
What for? oO
Click to expand...

1. For link building every post.
2. For mass commenting your every single post using scrapebox.
3. To re-check your url with your tags without buying or using the Web Auditor. You will see clearly how ugly they are if you have NOT done the friendly url properly.

That's all i can think of.
 
Last edited:
dikoro said:
1. For link building every post.
2. For mass commenting your every single post using scrapebox.
3. To re-check your url with your tags without buying or using the Web Auditor. You will see clearly how ugly they are if you have NOT done the friendly url properly.

That's all i can think of.
Click to expand...

The perfect answer. Sure getting list of your wp posts can be used in different ways for SEO.
 
For #2, make sure you're disabling the comment flood in your WordPress blog, here's a plugin I have used in the past when mass commenting my own blogs - wordpress.org/extend/plugins/disable-check-comment-flood/
 
This is so useful! Thank you very much. It's a shame that there are just a few thanks...
 
If you have cpanel just go into phpmyadmin and export the comments table as a csv file then open it in a spreadsheet and copy the urls.
 
You can also use the normal export from wordpress, minimal magic with a text editor and get your list. if you want to have it updated regulary and have additional information, I suggest you set up an ifttt recipe so that new postings get added to a google spreadsheet and have the required information in separate columns
 
Here's a revised version of the code that should work better:

  1. Create a new PHP file named extract_urls.php.
  2. Paste the following code into the file:


  3. Code: 
    <?php
// Include WordPress main configuration file
require_once('wp-config.php');

// Include WordPress functions
require_once('wp-load.php');

// Query posts
$query_args = array(
    'posts_per_page' => -1, // Get all posts
    'order'          => 'ASC', // Order by ascending
);
$query = new WP_Query($query_args);

// Check if there are posts
if ($query->have_posts()) {
    // Loop through each post
    while ($query->have_posts()) {
        $query->the_post();
        // Get post permalink
        $permalink = get_permalink();
        // Output permalink
        echo $permalink . "\n";
    }
} else {
    // No posts found
    echo 'No posts found';
}

// Restore original post data
wp_reset_postdata();
?>

    1. Upload the extract_urls.php file to the root directory of your WordPress installation (where your wp-config.php and wp-load.php files are located).
    2. Open your web browser and navigate to http://www.yoursite.com/extract_urls.php to execute the script.
      This script should output all the URLs of your WordPress posts. Make sure to replace http://www.yoursite.com/ with the actual URL of your WordPress site.
 
Advertise on BHW
You must log in or register to reply here.
Sign up now!

Main Menu

Home Main Forum List Black Hat SEO White Hat SEO BHW Newbie Guide Blogging Black Hat Tools Social Media Downloads

Marketplace

Account Selling Content / Copywriting EBooks / Methods Hosting Misc Proxies For Sale SEO - Link building SEO - Packages Social Media Social Media - Panels Web Design More

Making Money

Affiliate Programs Hire a Freelancer IM Journeys Making Money Pay Per Click Site Flipping Want to Buy

BlackHat World

Dispute Resolution Forum Suggestions & Feedback Introductions Lounge
Back
Top