CKeditor form problem adding post to database











up vote
0
down vote

favorite












Im currently trying to use CKeditor to have a custom form on a website. Problem when I want to add the textarea to the database is that the form adds extra code.



query=>INSERT INTO post(title,author,post) VALUES ('Jomoja','Djenci','
testpost

rn')


the post "testpost" was just to test. It adds automatically 2 lines and yet rn') when I do a



$postt=mysqli_real_escape_string($connection,$_POST["postt"]);


Without the CKeditor I have no problem adding the post to the database...



How can I remove those 2 lines and rn?










share|improve this question






















  • What about HTML and accented characters? Is it saving these also in the database?
    – Pedro Serpa
    Nov 8 at 22:32















up vote
0
down vote

favorite












Im currently trying to use CKeditor to have a custom form on a website. Problem when I want to add the textarea to the database is that the form adds extra code.



query=>INSERT INTO post(title,author,post) VALUES ('Jomoja','Djenci','
testpost

rn')


the post "testpost" was just to test. It adds automatically 2 lines and yet rn') when I do a



$postt=mysqli_real_escape_string($connection,$_POST["postt"]);


Without the CKeditor I have no problem adding the post to the database...



How can I remove those 2 lines and rn?










share|improve this question






















  • What about HTML and accented characters? Is it saving these also in the database?
    – Pedro Serpa
    Nov 8 at 22:32













up vote
0
down vote

favorite









up vote
0
down vote

favorite











Im currently trying to use CKeditor to have a custom form on a website. Problem when I want to add the textarea to the database is that the form adds extra code.



query=>INSERT INTO post(title,author,post) VALUES ('Jomoja','Djenci','
testpost

rn')


the post "testpost" was just to test. It adds automatically 2 lines and yet rn') when I do a



$postt=mysqli_real_escape_string($connection,$_POST["postt"]);


Without the CKeditor I have no problem adding the post to the database...



How can I remove those 2 lines and rn?










share|improve this question













Im currently trying to use CKeditor to have a custom form on a website. Problem when I want to add the textarea to the database is that the form adds extra code.



query=>INSERT INTO post(title,author,post) VALUES ('Jomoja','Djenci','
testpost

rn')


the post "testpost" was just to test. It adds automatically 2 lines and yet rn') when I do a



$postt=mysqli_real_escape_string($connection,$_POST["postt"]);


Without the CKeditor I have no problem adding the post to the database...



How can I remove those 2 lines and rn?







php mysql mysqli ckeditor






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 8 at 21:55









Djenci Duquene

114




114












  • What about HTML and accented characters? Is it saving these also in the database?
    – Pedro Serpa
    Nov 8 at 22:32


















  • What about HTML and accented characters? Is it saving these also in the database?
    – Pedro Serpa
    Nov 8 at 22:32
















What about HTML and accented characters? Is it saving these also in the database?
– Pedro Serpa
Nov 8 at 22:32




What about HTML and accented characters? Is it saving these also in the database?
– Pedro Serpa
Nov 8 at 22:32












2 Answers
2






active

oldest

votes

















up vote
0
down vote













Iam not sure !!

you can try this



 $postt = str_ireplace(array("r","n",'r','n'),'', $postt); 





share|improve this answer




























    up vote
    0
    down vote













    I was too impatient. :-) Looked around a bit and I downloaded the auto save plugin from CKeditor and now it saves to database without any error.



    Thanks for the help guys!






    share|improve this answer





















      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',
      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%2f53216753%2fckeditor-form-problem-adding-post-to-database%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes








      up vote
      0
      down vote













      Iam not sure !!

      you can try this



       $postt = str_ireplace(array("r","n",'r','n'),'', $postt); 





      share|improve this answer

























        up vote
        0
        down vote













        Iam not sure !!

        you can try this



         $postt = str_ireplace(array("r","n",'r','n'),'', $postt); 





        share|improve this answer























          up vote
          0
          down vote










          up vote
          0
          down vote









          Iam not sure !!

          you can try this



           $postt = str_ireplace(array("r","n",'r','n'),'', $postt); 





          share|improve this answer












          Iam not sure !!

          you can try this



           $postt = str_ireplace(array("r","n",'r','n'),'', $postt); 






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 8 at 22:19









          Nirab

          44




          44
























              up vote
              0
              down vote













              I was too impatient. :-) Looked around a bit and I downloaded the auto save plugin from CKeditor and now it saves to database without any error.



              Thanks for the help guys!






              share|improve this answer

























                up vote
                0
                down vote













                I was too impatient. :-) Looked around a bit and I downloaded the auto save plugin from CKeditor and now it saves to database without any error.



                Thanks for the help guys!






                share|improve this answer























                  up vote
                  0
                  down vote










                  up vote
                  0
                  down vote









                  I was too impatient. :-) Looked around a bit and I downloaded the auto save plugin from CKeditor and now it saves to database without any error.



                  Thanks for the help guys!






                  share|improve this answer












                  I was too impatient. :-) Looked around a bit and I downloaded the auto save plugin from CKeditor and now it saves to database without any error.



                  Thanks for the help guys!







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Nov 8 at 22:46









                  Djenci Duquene

                  114




                  114






























                      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.





                      Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                      Please pay close attention to the following guidance:


                      • 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%2f53216753%2fckeditor-form-problem-adding-post-to-database%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







                      這個網誌中的熱門文章

                      Academy of Television Arts & Sciences

                      L'Équipe

                      1995 France bombings