1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to Get List of ALL Wordpress Blog Post Urls ?

Discussion in 'Blogging' started by teluguvids, Mar 15, 2011.

  1. teluguvids

    teluguvids Registered Member

    Joined:
    Jul 18, 2008
    Messages:
    89
    Likes Received:
    31
    Hi BHW Memebers


    i want to get all the list of posturls in my wordpress blogs. i am planing to submit all my blog urls using senuke. but i don't know how to get the blogpost urls, i have around 700 post in my blog.
     
  2. coxie

    coxie Registered Member

    Joined:
    Oct 18, 2010
    Messages:
    74
    Likes Received:
    11
    if you have sitemap plugin installed try going to that page and you should see all your url pages, copy and paste the ones you want
     
  3. lacy1978

    lacy1978 Junior Member

    Joined:
    Jan 5, 2011
    Messages:
    153
    Likes Received:
    39
    have you tried an xml sitemap generator? There are tons of free ones out there.
     
  4. BigLarry

    BigLarry Regular Member

    Joined:
    Mar 2, 2011
    Messages:
    218
    Likes Received:
    144
    If you have access to phpmyadmin you can select the database and the from the top select sql and run this query:

    PHP:
    SELECT guid FROM `wp_postsWHERE guid not like '%.jpg' and guid not like '%revision%'  and guid not like '%autosave%'    and guid not like '%gif%'    and guid not like '%jpeg%'    and guid not like '%?%'   and guid not like '%png%'  
    You can the select export and export the URL's to excel, csv etc etc

    Rough and ready but should work.

    Larry.
     
    • Thanks Thanks x 1
  5. wickedguy

    wickedguy Supreme Member

    Joined:
    Jul 22, 2009
    Messages:
    1,402
    Likes Received:
    1,379
    Location:
    BHW--> South Africa
    Home Page:
    Hi OP

    Save the following code as getlinks.php and upload to the home directory of wordpress.
    Then just call the getlinks.php with your browser :D

    PHP:
    <?
    require_once(
    'wp-config.php');
    require_once(
    'wp-includes/wp-db.php');
    global 
    $post;
    $myposts get_posts('numberposts=-1&offset=1');
    foreach(
    $myposts as $post){
    echo 
    trim(the_permalink())."<br>";
    }
    ?>
     
    • Thanks Thanks x 6
  6. teluguvids

    teluguvids Registered Member

    Joined:
    Jul 18, 2008
    Messages:
    89
    Likes Received:
    31
    HI all

    Thank you for giving suggestions, and idea, i have implemented sitemap plugin and wickedguy code , its worked very well thanksalot.

    Thanks
     
  7. amdadhbd

    amdadhbd Newbie

    Joined:
    Jun 11, 2011
    Messages:
    49
    Likes Received:
    1
    Occupation:
    Business Analyst
    Location:
    Bangladesh
    Home Page:
    Thanks a lot. It works for me very well.
     
  8. ggigg73

    ggigg73 Newbie

    Joined:
    Jul 19, 2013
    Messages:
    6
    Likes Received:
    1
    Hi, it doesnt work any more ... at least with my wp-installation its not working ;-) maybe because of changes regarding to the new WP-Updates ?
     
  9. tykoon123

    tykoon123 Registered Member

    Joined:
    Apr 28, 2012
    Messages:
    96
    Likes Received:
    81
    Generate a sitemap and copy from it the links.
     
  10. tojamie

    tojamie BANNED BANNED

    Joined:
    Jan 14, 2013
    Messages:
    1,052
    Likes Received:
    237
    Try some XML Sitemap or HTML Sitemap. Try it Cheers !!