What is the best practice for handling line breaks in text when inserting into a MySQL table using PHP?

When inserting text containing line breaks into a MySQL table using PHP, it is important to properly handle the line breaks to avoid any formatting issues or errors. One common approach is to use the PHP function mysqli_real_escape_string() to escape special characters, including line breaks, before inserting the text into the database. This function will ensure that the text is properly formatted and does not cause any SQL injection vulnerabilities.

// Assuming $text contains the text with line breaks that needs to be inserted into the database
$escaped_text = mysqli_real_escape_string($connection, $text);

// Construct and execute the SQL query to insert the escaped text into the database
$query = "INSERT INTO table_name (column_name) VALUES ('$escaped_text')";
mysqli_query($connection, $query);