Re: Slightly OT: MySQL + PHP and escaping data to output to a web page

[Daniel Kasak]

Mark Susol | Ultimate Creative Media wrote:

On 4/15/04 11:49 PM, "Daniel Kasak" <[EMAIL PROTECTED]> wrote:

 

I'm currently using:

replace(replace(NoteText, '<', '&#060'), '>', '&#062') as NoteText

to replace the offending characters with HTML escape codes. Is there a
cleaner way of doing this?
   

You can try the php command:

htmlspecialchars($NoteText, ENT_NOQUOTES);

ref: http://us3.php.net/htmlspecialchars

Best place for php questions is www.sitepoint.com

 

Coooooool. Thanks!
I'll check out sitepoint as well.
Dan

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]