php - unable to split a string by new lines from database

Question

I'm receiving data from a MSSQL database with PHP (using PDO sqlsrv driver).

I need to split the string by new line.

In the DB the string looks like this:

I tried the following with no success:

$text = explode("\n\n",$text);
$text = preg_split("/\n\n/",$text);

Or

$text = explode("\n",$text);
$text = preg_split("/\n/",$text);

When i debug the code and when i print the text to the browser the string appears as one line.

But if i inspect the element in chrome, it is displayed exactly like in the database:

I copied the text from the inspector to a regex tester and the newlines were found successfully! But the "echoed" text was in one line.

Answer 1

Try replacing new line character with comma (,) or something other special char.

preg_replace("/((\r?\n)|(\r\n?))/", ',', $input);

Then try to explode like this explode(',', $input);

or if result set is file go through this post

explode(PHP_EOL, $input);

https://stackoverflow.com/a/29471912/4895810