PHP echo long text

Question

This is inside the phpmyadmin:

This is inside the phpmyadmin

This is the output after echo:

This is the output after echo

and this is the code for display output

$joinEvent  =   mysqli_query($db, "SELECT * FROM event WHERE event.eventID='".$_GET['eventID']."'");
while($row  =   mysqli_fetch_array($joinEvent))
{
  $joinDetails      =       $row['details'];
}

<p align="justify"><?php echo $joinDetails; ?></p>

How do I echo exactly what user enter in the input?

score 2 · Accepted Answer · answered Dec 06 '18 at 03:55

2

Use nl2br() when you output to the screen, change your current code to:

<p align="justify"><?php echo nl2br($joinDetails); ?></p>

answered Dec 06 '18 at 03:55

oreopot

3,392
2
19
28

This works perfectly! thanks! – Eefy Dec 06 '18 at 05:15

score 0 · Answer 2 · answered Dec 06 '18 at 03:41

0

It might be better for you to store your details column as a text datatype. Read here: What is the MySQL VARCHAR max size?

answered Dec 06 '18 at 03:41

Lukas Mittun Alexander Guldstv

572
7
24

score 0 · Answer 3 · answered Dec 06 '18 at 03:57

0

Your result is actually exactly what the user input is ; except that in HTML, line break characters (\r\n \n and so) are not interpreted by the browser. As said in the comments, you'll have to use the PHP function nl2br() to convert your line break characters to <br /> tags, which are the HTML line breaks.

answered Dec 06 '18 at 03:57

OddBrew

498
3
15

Thank you for your explanation! works like charm – Eefy Dec 06 '18 at 05:16

PHP echo long text

3 Answers3