Read a blob field line by line

[paulin1]

How can I read a blob field that has been pulled from the database and has formatted text?
I need to be able to read line by line in order to populate a table, basically get the contents from each line. thanks

[Christopher]

Probably the easiest is to split the text on newlines into an array. The simplest would be:

Code: Select all

$lines = explode("\n", $text);     // or \r

If line endings can be mixed then more complicated:

Code: Select all

$lines = preg_split("/((\r?\n)|(\r\n?))/", $text);

Then just

Code: Select all

 foreach($lines as $line) {