SoireeExtreme Posted July 19, 2007 Share Posted July 19, 2007 I'm setting up a web page sort of like an editor. In this editor just like any other you can type in coding and turn it into a web page and such. And when you click on a link it is suppose to show the page. My problem here is when the coding is saved to the database it gets changed a bit. Where there are spaces or a new line is put in between the coding I get some letters "rn". I've tried changing the database setting the browser transformation to text/plain: formatted. And I still ended up with the same problem. Is there anyone that can help solve my problem? If this isn't a mysql problem please let me know as I assume it is. If there is anymore information needed please let me know. Thanks in advance for any help. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 20, 2007 Share Posted July 20, 2007 That looks like a stripped \r\n. Quote Link to comment Share on other sites More sharing options...
SoireeExtreme Posted July 21, 2007 Author Share Posted July 21, 2007 Well when I click the save button for it to save to the database rn is what is put in the place of spaces or new lines. And all the text and coding is bunched together like one be block. Stripped or not I wouldn't know. I'm still learning php and mysql. So that means just about nothing to me. lol. Anyone have any idea how to help? It would be great appreciated. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 27, 2007 Share Posted July 27, 2007 You need to find out how your input data is being processed before being sent to mysql... sounds like it's not being escaped. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.