Easiest way to mass-edit all posts?

CyberSEO said:

That's very easy. Here is the script:

Code:

<?php
// AddMe.php - simple script that adds a given html code to every published post in the WP database
// Put in into your WP root folder and simple run it once. e.g.: http://www.yourblog.com/addme.php
// Don't forget to delete addme.php from your server when done! And do not run it twice!
// Written by http://www.CyberSEO.net
define ( 'TO_ADD', '<p>PUT HERE SOMETHING YOU WANT TO ADD</p>' );
include ("wp-config.php");
$wp_upload_dir = wp_upload_dir ();
$query = "SELECT ID, post_content, post_excerpt FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post'";
$posts = $wpdb->get_results ( $query );
echo 'Addding. Please wait...<br />';
foreach ( $posts as $post ) {
    $post->post_content .= TO_ADD;
    $post->post_excerpt .= TO_ADD;
    wp_update_post ( $post );
}
echo 'Done!<br />';
echo 'Don\'t forget to delete addme.php from your server!';
?>

Click to expand...

CyberSEO said:

Yes, you have to put it here:

define ( 'TO_ADD', '<p>PUT HERE SOMETHING YOU WANT TO ADD</p>' );

Then simple save the script as addme.php, upload it to your WP root folder and run it once, e.g.: http://www.yourblog.com/addme.php

Remove the script from server when done!

Click to expand...