What are some common issues that arise when attempting to display line breaks properly in a MySQL database when using PHP?

When attempting to display line breaks properly in a MySQL database when using PHP, common issues include the line breaks not being preserved or displayed correctly on the web page. To solve this issue, you can use the PHP nl2br() function to convert newline characters to HTML line breaks <br> tags before displaying the data on the webpage.

// Retrieve data from MySQL database
$data = "This is a sample text with\nline breaks.";

// Use nl2br() function to convert newline characters to HTML line breaks
$formatted_data = nl2br($data);

// Display the formatted data on the webpage
echo $formatted_data;