MySQL Forums
Forum List  »  Newbie

Re: "#" symbol inside text of databse
Posted by: Rick James
Date: March 08, 2010 11:07PM

Forgot a nasty... urlencode() should be applied to each key and value that makes up the url. That is, to a, b, c, d, but not after building the url (otherwise the ?, =, & would be messed up):
foo.com/x/y?a=b&c=d

Echo the url as is to email, htmlencode it before echoing to a web page. (Think about what needs to happen to "&".)

The whole thing is messy and not well thought out. Nor have I found a clean explanation of it all.

Note that url encoding is rather forgiving. You can often get away without escaping (turning into hex) many punctuation marks. And some have multiple encodings (space can be '+' or '%20').

Options: ReplyQuote


Subject
Written By
Posted
Re: "#" symbol inside text of databse
March 08, 2010 11:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.