problems using the nl2br function

bloomoon

i am trying to include line breaks when pulling the contents of a database blob field onto a PHP page. I am using this code:

while ($row = ibase_fetch_object ($result)) {
$notes=$row->NOTES;
$notes = ereg_replace("(\r\n|\n|\r)", "",$notes);
$notes=nl2br($notes);
ibase_blob_echo($notes);
...

it's not working. i cant get it to work despite trying the combinations suggested on the manual reference page. The database and PHP is held on a Linux box but I am trying to display the info on a Windows XP machine. Is there something wrong with my code or is it the fact it is held on a Linux box that is causing the problems?

many thanks

corsc

I may be wrong, but I believe that you do not need the ereg_replace line.

It looks like you are removing all of the new line characters before trying to converting them.

This would explain why the nl2br function is not working, as after the ereg_replace function call there will be no NL to replace.

Weedpacket

$notes = ereg_replace("(\r\n|\n|\r)", "",$notes);
$notes=nl2br($notes);

If you're going to turn newlines into break tags, don't take the newlines out first.

$notes=nl2br($notes);
$notes = ereg_replace("(\r\n|\n|\r)", "",$notes);

This might be faster:

$notes=nl2br($notes);
$notes = str_replace("\r", "",$notes);
$notes = str_replace("\n", "",$notes);

bloomoon

i have just tried both of these suggestions and am getting the following error message:

Warning: ibase_blob_echo(): Invalid blob id in this line:

ibase_blob_echo($prognotes);

...? is it because the code is held on a linux box?

Weedpacket

Well the documentation is a bit sparse on this topic, I've never used Interbase, and never actually stored text in a blob, but I note that one thing the documentation does suggest is that the string passed to ibase_blob_echo is supposed to be some sort of identifier for the blob - this is presumably a different thing from the blob's contents.
If you're trying to echo a $string, why not just go "echo $string;"? At least you'll see what the "identifier" ibase_blob_echo is complaining about looks like.