How to change the case of all post titles to “Title Case”

by

I am helping my father with his WordPress website.
It has over 1,700 posts with TITLES IN UPPERCASE.

We’d like to change these to “Title Case” in the database (possibly using this PHP script).

The WordPress “To Title Case” plug-in changes the case at the template level – we’d like to change it at the database level.

What would be the best way to apply the script to all titles in the WordPress database?
I could write some code from scratch but I’m guessing there’s existing code/methods out there that can apply a function/method across all titles.

5

Updating the posts

$all_posts = get_posts(
    'posts_per_page' => -1,
    'post_type' => 'post'
);

foreach ( $all_posts as $single ) {
    wp_update_post( array(
        'ID' => $single->ID,
        'post_title' => to_title_case( $single->post_title ) // see function below
    ));
}

Converting a string to “Title Case”

And, while not pertinent to WP, for the sake of completeness:

function to_title_case( $string ) {
     /* Words that should be entirely lower-case */
     $articles_conjunctions_prepositions = array(
          'a','an','the',
          'and','but','or','nor',
          'if','then','else','when',
          'at','by','from','for','in',
          'off','on','out','over','to','into','with'
     );
     /* Words that should be entirely upper-case (need to be lower-case in this list!) */
     $acronyms_and_such = array(
         'asap', 'unhcr', 'wpse', 'wtf'
     );
     /* split title string into array of words */
     $words = explode( ' ', mb_strtolower( $string ) );
     /* iterate over words */
     foreach ( $words as $position => $word ) {
         /* re-capitalize acronyms */
         if( in_array( $word, $acronyms_and_such ) ) {
             $words[$position] = mb_strtoupper( $word );
         /* capitalize first letter of all other words, if... */
         } elseif (
             /* ...first word of the title string... */
             0 === $position ||
             /* ...or not in above lower-case list*/
             ! in_array( $word, $articles_conjunctions_prepositions ) 
         ) {
             $words[$position] = ucwords( $word );
         }
     }         
     /* re-combine word array */
     $string = implode( ' ', $words );
     /* return title string in title case */
     return $string;
}

Obviously, both lists of words could be expanded – the lower-case list especially by more prepositions, the acronyms by those that are used often on the current site.

The WP-specific part is only the upper code block though, anyhow.

Leave a Comment