Javascript to 'find and replace' from mySQL output

Question

I am looking for Javascript expertise to be able to find specific words after mySQL outputs my text. I have numerous fields in a column in my phpmyadmin database with sentences such as: Bobby ran down the hill. He saw nothing. Bobby went home.

I would like to create a javascript code that finds the periods . and be able to replace them with html code   because I cannot add a line break in the mySQL fields even though I've tried concatenation. Help on this issue would be appreciated!

Here is my script:

 $("#tips").append("<li class='treatment'>" + treat.Tips + "</li>");
 $("#tips-text").text(treat.Tips);
 treat.Tips = txt.replace(/\./g, "<br />");
 $('#tips').listview('refresh');`

why you can not insert in your mysql fields? a personal reason or grammatically? — Ali Sheikhpour
– Ali Sheikhpour, Commented Apr 15, 2015 at 15:55
I have tried \n, , as well as them in quotes. However, I believe it is because I am using a SQLite manager for web apps and instead of doing line breaks it instead shows the actual text ie   on the front-end. — chronotrigga
– chronotrigga, Commented Apr 15, 2015 at 16:01
The code up there looks like you are replacing treat.Tips after you added that string the DOM? Just updating treat.Tips is not going to update the DOM. You have to call $("#tips").append("<li class='treatment'>" + treat.Tips + "</li>"); after you run your regex — Ruan Mendes
– Ruan Mendes, Commented Apr 15, 2015 at 16:05

Sam Battat · Accepted Answer · 2015-04-15 16:00:43Z

3

The Javascript replace can do that with the help of regular expressions: the method normally would replace one instance of the found text, but if you user regular expressions, it can replace all instances

I used the regex /\./g: this means find any periodand the g modified means that the search is global for all the text.

var txt = "Bobby ran down the hill. He saw nothing. Bobby went home.";

txt = txt.replace(/\./g, "<br />");

DEMO: http://jsfiddle.net/sj33gg07/

Thank you for your answer. I am pulling treat.Tips from phpmyadmin that contains my data. Do you have any suggestions on how to further display replace? I revised my code par your suggestion but it broke my script. Please see my revised question for the code, thanks! – chronotrigga 4 mins ago

You should do the append after you replace not before

 treat.Tips = treat.Tips.replace(/\./g, "<br />");
 $("#tips").append("<li class='treatment'>" + treat.Tips + "</li>");
 $("#tips-text").text(treat.Tips);
 $('#tips').listview('refresh');`

edited Apr 15, 2015 at 16:00

answered Apr 15, 2015 at 15:52

Sam Battat

5,7651 gold badge22 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

chronotrigga Over a year ago

Thank you for your answer. I am pulling treat.Tips from phpmyadmin that contains my data. Do you have any suggestions on how to further display replace? I revised my code par your suggestion but it broke my script. Please see my revised question for the code, thanks!

abaracedo · Accepted Answer · 2015-04-15 15:55:23Z

1

You can use the replace method and look for the dots and replace it for 

Here is an example:

var text = "Bobby ran down the hill. He saw nothing. Bobby went home.";
text = text.replace(/\./g,"<br />");

answered Apr 15, 2015 at 15:55

abaracedo

1,4545 gold badges27 silver badges46 bronze badges

Collectives™ on Stack Overflow

Javascript to 'find and replace' from mySQL output

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related