Geeklog Forums

i am trying to add additional fields via custom form registrtion. I realized when i was testing that if i use a single quote...in the data..anything after the single quote disappears when it is entered into mysql....
does anyone have a suggestion???

I have applied addslashes and com_applyfilter functions..but they did not work....I do not have anything else to try..thanks

COM_applyFilter is actually the function that will cut off your input at the first quote.

If you need content that contains quotes, you have to carefully filter it yourself. Applying addslashes before writing it into the database is a good start, but depending on what sort of content it is, you may also need to filter for HTML, for example.

bye, Dirk

thanks for the quick reply.
I was curious, do you have any examples ?
If I should use addslashes when entering data into geeklog db, do I have to use anything when i am bring it out of the db ???

Further, did you know that if i create a user account with single quote..i get an sql error?? I have to remove the single quote to create the account.