note 37806 rejected from function.str-replace by tomsommer

Note Submitter: Daniellus83 ---- [ Common Problem with converting text from MySQL database to HTML: line breaks!! (Once and for all the ULTIMATE SOLUTION ;) ] Dear users.... I have struggled for many hours on the following problem wich many people would recognize: 1) you have text in an MySQL database 2) you have a PHP script 3a) the script inserts the text from the database into the HTML page OR 3b) inserts the text into a javascript variable ..='your text'! OR 3c) inserts into a textbox (or whatever...) THE PROBLEM: because php inserts directly from MySQL everything is inserted including ALL characters (like ENTER ' " ... etcetc) wich causes the HTML browser to fail to generate properly. ------------------------------------- I red many text-piece all over the internet on how to convert with str_replace (par example) the ENTER [ n or nr or char(13) or whatever... Mac is different than Win or Linux... aaarrggghhhh!!] But here the allways working (multi-platform) solution!... thaadaaa: A) MySQL database 1) Create an extra table in your MySQL database with 3 columns. 2) Put in the 1rst col : ID (=1,2,3,...) 3) Put in the 2nd col: the wrong character (so if its an enter, put an enter in the cell!!) 4) Put in the 3rd col: the correct <HTML> character: (so if it's an enter; put the HTML-one in it: <br>!!) B) The script: 1) Take care that the string (with wrong characters) is loaded in $yourstring 2) Now create a while loop, the same as you would reading a whole table, but now you read the whole (just made) character-table 3) read in the loop from the corresponding row from the table, the $wrong and the $correct character. 4) put in the loop the code: $corrected_yourstring = str_replace($wrong,$correct,$yourstring); This should replace all evil-evil-evil characters ;) (even ENTERs, wich are different on other platforms!, are replaced with in my case <br>) PLEASE let me know what you think about this solution! (dstrommel at hotmail.com), Daniël