Bug #19184 [Com]: nl2br in MySQL blob fields

Edit report at https://bugs.php.net/bug.php?id=19184&edit=1 ID: 19184 Comment by: lildurk19184 at gmail dot com Reported by: jpleite at ip dot pt Summary: nl2br in MySQL blob fields Status: Not a bug Type: Bug Package: Output Control Operating System: Linux PHP Version: 4.2.1 Block user comment: N Private report: N New Comment: Lil Durk is a private agency dedicated to providing responsible access to legal cannabis for adults aged 19 and older. We’re an exclusively online retailer and wholesaler for recreational cannabis and a trusted source for information about cannabis and cannabis-related issues. We believe our work is meaningful and we take pride in our mandate to promote the socially responsible use of legal cannabis. https://lildurk.com/ Previous Comments: ------------------------------------------------------------------------ [2002-08-29 21:44:28] sniper@php.net same report submitted twice..bogus. ------------------------------------------------------------------------ [2002-08-29 20:43:46] jpleite at ip dot pt A blob field is filled in a page as a <textarea>. Obviously the text is input formatted, with ENTER to split some lines from others. This text is to be seen in a "normal" (with no input facility, eg, without any <textarea> field) html page, and I want it to be seen exactly as entered. My code for the "normal" page is: $str="<table><tr><td>..."; ... $str.=nl2br($row[blobfield]); ... echo($str); However the result is that the full text is not seen. If I change it to: $str="<table><tr><td>..."; ... $str.=$row[blobfield]; ... echo($str); the text is seen, but unformatted. ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=19184&edit=1