edit multiple wordpress posts body text at the same time





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















I am the owner of a WordPress books library website. I want to edit 23000 posts and add some text or replace some text or links from the body of the posts. I am unable to find any solution for quick editing. Because it will take me ages to complete this daunting task.



Please help










share|improve this question





























    0















    I am the owner of a WordPress books library website. I want to edit 23000 posts and add some text or replace some text or links from the body of the posts. I am unable to find any solution for quick editing. Because it will take me ages to complete this daunting task.



    Please help










    share|improve this question

























      0












      0








      0








      I am the owner of a WordPress books library website. I want to edit 23000 posts and add some text or replace some text or links from the body of the posts. I am unable to find any solution for quick editing. Because it will take me ages to complete this daunting task.



      Please help










      share|improve this question














      I am the owner of a WordPress books library website. I want to edit 23000 posts and add some text or replace some text or links from the body of the posts. I am unable to find any solution for quick editing. Because it will take me ages to complete this daunting task.



      Please help







      wordpress posts editing






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 17 '18 at 6:42









      Imran AhmedImran Ahmed

      62




      62
























          1 Answer
          1






          active

          oldest

          votes


















          0














          $post_content =  $wpdb->get_results("select post_content from wp_posts where ID = 9969");
          $content = $post_content[0]->post_content ;

          $replaced_content = preg_replace_callback('/code to replace in form of regex/',
          'code with which you want to replace',
          $content);

          $wpdb->query('UPDATE wp_posts SET post_content = "'.$wpdb->_real_escape($replaced_content).'" WHERE ID = "'.$post_id.'"');





          share|improve this answer
























          • Greetings, It is really nice to see your response. I want to add text material to all posts. Some material will remain the same but some material has to change in each post like the name of the book, name of the author, download link and read online link. In fact, I want to add 3-4 paragraphs with headings, and links and a table to each and every post physically. I mean when google bot checks the posts material should be present in each and every post.

            – Imran Ahmed
            Nov 18 '18 at 13:34














          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53348899%2fedit-multiple-wordpress-posts-body-text-at-the-same-time%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          0














          $post_content =  $wpdb->get_results("select post_content from wp_posts where ID = 9969");
          $content = $post_content[0]->post_content ;

          $replaced_content = preg_replace_callback('/code to replace in form of regex/',
          'code with which you want to replace',
          $content);

          $wpdb->query('UPDATE wp_posts SET post_content = "'.$wpdb->_real_escape($replaced_content).'" WHERE ID = "'.$post_id.'"');





          share|improve this answer
























          • Greetings, It is really nice to see your response. I want to add text material to all posts. Some material will remain the same but some material has to change in each post like the name of the book, name of the author, download link and read online link. In fact, I want to add 3-4 paragraphs with headings, and links and a table to each and every post physically. I mean when google bot checks the posts material should be present in each and every post.

            – Imran Ahmed
            Nov 18 '18 at 13:34


















          0














          $post_content =  $wpdb->get_results("select post_content from wp_posts where ID = 9969");
          $content = $post_content[0]->post_content ;

          $replaced_content = preg_replace_callback('/code to replace in form of regex/',
          'code with which you want to replace',
          $content);

          $wpdb->query('UPDATE wp_posts SET post_content = "'.$wpdb->_real_escape($replaced_content).'" WHERE ID = "'.$post_id.'"');





          share|improve this answer
























          • Greetings, It is really nice to see your response. I want to add text material to all posts. Some material will remain the same but some material has to change in each post like the name of the book, name of the author, download link and read online link. In fact, I want to add 3-4 paragraphs with headings, and links and a table to each and every post physically. I mean when google bot checks the posts material should be present in each and every post.

            – Imran Ahmed
            Nov 18 '18 at 13:34
















          0












          0








          0







          $post_content =  $wpdb->get_results("select post_content from wp_posts where ID = 9969");
          $content = $post_content[0]->post_content ;

          $replaced_content = preg_replace_callback('/code to replace in form of regex/',
          'code with which you want to replace',
          $content);

          $wpdb->query('UPDATE wp_posts SET post_content = "'.$wpdb->_real_escape($replaced_content).'" WHERE ID = "'.$post_id.'"');





          share|improve this answer













          $post_content =  $wpdb->get_results("select post_content from wp_posts where ID = 9969");
          $content = $post_content[0]->post_content ;

          $replaced_content = preg_replace_callback('/code to replace in form of regex/',
          'code with which you want to replace',
          $content);

          $wpdb->query('UPDATE wp_posts SET post_content = "'.$wpdb->_real_escape($replaced_content).'" WHERE ID = "'.$post_id.'"');






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 17 '18 at 12:16









          Krishna thakorKrishna thakor

          10010




          10010













          • Greetings, It is really nice to see your response. I want to add text material to all posts. Some material will remain the same but some material has to change in each post like the name of the book, name of the author, download link and read online link. In fact, I want to add 3-4 paragraphs with headings, and links and a table to each and every post physically. I mean when google bot checks the posts material should be present in each and every post.

            – Imran Ahmed
            Nov 18 '18 at 13:34





















          • Greetings, It is really nice to see your response. I want to add text material to all posts. Some material will remain the same but some material has to change in each post like the name of the book, name of the author, download link and read online link. In fact, I want to add 3-4 paragraphs with headings, and links and a table to each and every post physically. I mean when google bot checks the posts material should be present in each and every post.

            – Imran Ahmed
            Nov 18 '18 at 13:34



















          Greetings, It is really nice to see your response. I want to add text material to all posts. Some material will remain the same but some material has to change in each post like the name of the book, name of the author, download link and read online link. In fact, I want to add 3-4 paragraphs with headings, and links and a table to each and every post physically. I mean when google bot checks the posts material should be present in each and every post.

          – Imran Ahmed
          Nov 18 '18 at 13:34







          Greetings, It is really nice to see your response. I want to add text material to all posts. Some material will remain the same but some material has to change in each post like the name of the book, name of the author, download link and read online link. In fact, I want to add 3-4 paragraphs with headings, and links and a table to each and every post physically. I mean when google bot checks the posts material should be present in each and every post.

          – Imran Ahmed
          Nov 18 '18 at 13:34






















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53348899%2fedit-multiple-wordpress-posts-body-text-at-the-same-time%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Xamarin.iOS Cant Deploy on Iphone

          Glorious Revolution

          Dulmage-Mendelsohn matrix decomposition in Python