Home › Forums › Misc › General PHP Help

Form TextBox Input of HTML to MySQL error

HELP??? I am trying to input HTML code into MySQL from a form Text Box.
Sample Code:
===========

Business Cards

MySQL field ends up like this in the database...
Sample Code:
==========
&&&&Business Cards&&&&&& & &

How do I stop the inclusion of all of the ">&" stuff???

When called from the database the HTML page ends up spread down the screen.

How do I fix this?

Thanks in Advance

Mr Happy

‹ Urgent for Project ! Get FORM text fields array to php page Multiple Functions - CGI via PHP ›
Posted by Anonymous on Mon, 04/05/2004 - 10:24

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Form TextBox Input of HTML to MySQL error

Check to see if you have the function of nl2b anywhere in your script. If you do, backup your script (incase this doesnt work) and then remove the refrences to nl2br.

-Andrew Riley

Posted by Andrew M Riley on Mon, 04/05/2004 - 12:38.

Form TextBox Input of HTML to MySQL error

Andy,

I had no reference to the "function of nl2b" you mentioned but I did have this line of code:

$messagehtml=preg_replace("/(\015\012)|(\015)|(\012)/","&", $messagehtml);

I deleted it and it now works perfectly.

Thanks for helping me out. I REALLY appreciate it.

Mr. Happy

Posted by Anonymous on Tue, 04/06/2004 - 09:00.