• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Knute Snortum
  • Paul Clapham
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Frits Walraven
Bartenders:
  • Ganesh Patekar
  • Tim Holloway
  • salvin francis

\r\n db saving and echo issue  RSS feed

 
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My problem is that when I save data(large data) from textarea into MySQL db by using $mysqli->real_escape_string($content);, it stores special chars escaped and also \r\n. But when I update the same the same way it does not do that(it is desired).

Second problem is that of the same data being echoed with \r\n on the browser, even nl2br() does not work. I know that even without nl2br(), echo prints data without \r\n except that we do not get <br/>(line breaks).

Below are the codes I've written:



Below code retrieves data to forms if already saved. You can see the problem in above figure.




Below code saves or updates the table:

 
There are 10 kinds of people in this world. Those that understand binary get this tiny ad:
how do I do my own kindle-like thing - without amazon
https://coderanch.com/t/711421/engineering/kindle-amazon
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!