MySQL output with line breaks in php

Question

I have the following output from my database. How can I output the existing line breaks of the text??

while($row = mysql_fetch_array( $result )) {

    // echo out the contents of each row into a table
    echo "<tr>" ;
    echo '<td>' . $row['id'] . '</td>';
    echo '<td>' . $row['kategorie'] . '</td>';
    echo '<td>' . $row['titel'] . '</td>';
    echo '<td>' . $row['betroffen'] . '</td>';
    echo '<td style="width:"600px">' . $row['beschreibung'] .  '</td>';
    echo '<td>' . $row['prioritaet'] . '</td>';
    echo '<td>' . $row['status'] . '</td>';
    echo '<td>' . $row['eingereicht'] . '</td>';
    echo '<td>' . $row['umsetzung'] . '</td>';
    echo '<td style="width:"400px">' . $row['kommentar'] . '</td>';
    echo '<td>' . $row['entwickler'] . '</td>';
    echo '<td><a href="edit.php?id=' . $row['id'] . '">bearbeiten</a></td>';
    echo '<td><a href="delete.php?id=' . $row['id'] . '">löschen</a></td>';
    echo "</tr>"; 
} 

// close table>
echo "</table>";

It has outputed properly. Look at your HTML source.

sectus
– sectus

2014-07-09 07:33:31 +00:00
Commented Jul 9, 2014 at 7:33 — sectus
– sectus, Commented Jul 9, 2014 at 7:33
nl2br() ?

Darren
– Darren

2014-07-09 07:34:43 +00:00
Commented Jul 9, 2014 at 7:34 — Darren
– Darren, Commented Jul 9, 2014 at 7:34
How to use nl2br in my code?

user3790450
– user3790450

2014-07-09 07:35:50 +00:00
Commented Jul 9, 2014 at 7:35 — user3790450
– user3790450, Commented Jul 9, 2014 at 7:35
Which column holds the new line...?

Darren
– Darren

2014-07-09 07:37:34 +00:00
Commented Jul 9, 2014 at 7:37 — Darren
– Darren, Commented Jul 9, 2014 at 7:37

Thomas · Accepted Answer · 2014-07-09 07:46:05Z

There are a few ways to do this. One is with str_replace another (more common way) is to use nl2br.

For both you have 2 Options in how you use them. 1.) You use single echo Statements as you currently do. In this case you use the commands on the values themselves.

For using str_replace (be Aware that you Need here to differentate between the OS you are using the code on...some use \n some \n\r ,.....

echo '<td>' . str_replace("\n", "<br>", $row['umsetzung']) . '</td>';

For completeness sake I'll also put in nl2br (although dinesh already has posted that)

echo '<td>' . nl2br($row['umsetzung']) . '</td>';

2.) You gather the Output into a variable and then echo that variable (while using the commands on it).

$myOutput = ""
$myOutput = $myOutput . "<tr>" ;
$myOutput = $myOutput . '<td>' . $row['id'] . '</td>';
$myOutput = $myOutput . '<td>' . $row['kategorie'] . '</td>';
......
$myOutput = $myOutput . '<td><a href="delete.php?id=' . $row['id'] . '">löschen</a></td>';
$myOutput = $myOutput . "</tr>"; 
echo nl2br($myOutput);

This method is also possible with str_replace instead of nl2br.

Dinesh Rawat · Accepted Answer · 2014-07-09 07:42:31Z

0

nl2br($string)

Suppose you want line breaks in title, that is a string. You can do this as follows:-

$trs = '';
while($row = mysql_fetch_array( $result )) {
  extract($rows);
  $trs .= "<tr>$id</td>"
  $trs .= "<tr>$kategorie</td>"
  $trs .= "<tr>nl2br($titel)</td>"
}

echo $trs;

answered Jul 9, 2014 at 7:42

Dinesh Rawat

1,01911 silver badges37 bronze badges

Collectives™ on Stack Overflow

MySQL output with line breaks in php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related