How to retrieve text as typed in Mysql mediumtext field?

Asked Jun 18 '15 at 22:06

Active Jun 18 '15 at 22:22

Viewed 33 times

i have a Mysql database with text table, that contains: id=int(30) and text=mediumtext; I typed as below, for example, and saved in the table, as id=1.

Whent i retrieve the field:

This is a text.

              This is a new line, with a big space before text.

 here contains more info.

      $id=GetRow("SELECT text from text_table WHERE id=1");

I got this:

"     This is a text.
           This is a new line,
      that contains more info."

Without new lines, paragraphs or tabs.

How i retrieve as typed?

Thx!

edited Jun 20 '20 at 09:12

Community

asked Jun 18 '15 at 22:06

Andre Alves

use `nl2br()` over your resultant string from mysql – M Khalid Junaid Jun 18 '15 at 22:07
What is the output of `var_dump($id);`? – Tuan Anh Hoang-Vu Jun 18 '15 at 22:09
your browser expects HTML, in HTML `
` is a line break not "\n" or "\r" which is what is used in plain text – Jun 18 '15 at 22:12
Yes, browser expects
and &nbsp, but is stored as i typed. Is not possible to retrieve that? – Andre Alves Jun 18 '15 at 22:17
you need to convert the stored "\n" or "\r" to `
` as @MKhalidJunaid suggest nl2br() – Jun 18 '15 at 22:18
I didn´t use
, or when i input. – Andre Alves Jun 18 '15 at 22:18
yes ... so you convert to them – Jun 18 '15 at 22:28
echo nl2br($id) solved the new line
issue, but not the space (paragraph tab), the issue. THX @MKhalidJunaid. – Andre Alves Jun 18 '15 at 22:42
Thx for everybody, i found a way. If anyone face this issue this what i did:
– Andre Alves Jun 18 '15 at 23:38

How to retrieve text as typed in Mysql mediumtext field?

0 Answers0