Login

[Driver]

I'm having a problem with a news posting thing I set up. It works perfectly, except when you post news with a single or double quote in it.

I was wondering if anyone knew how to get around this.. its really annoying, cause you can't type things like can't due to the single quote.

Any help would be great!
Thanks

[Adl]

str_replace should work, but then you'll also have to make sure that you close the tags...

[Malcolm]

How are you having problems; whats the error?

When trying to enter data into the database does it stop at the first quote?

or

When you're grabbing data from the database do you always see something like this: \" or \' ?

Give an example of the problem, we'll give you better ways to solve it

[Driver]

The prob is that unless you put \' or \" before a quote, then the php script that I wrote doesn't update the database properly, cause it ends at the quote.

I don't know how to tell php to ignore the single or double quote without the slash... or maybe to add the slash so mysql won't mess up ... I'm making this for users who I don't want to have to do much but type...

[Rasmus Lindström]

Post the script that's not working and will be much easier for us to help you.

And welcome to DEVPPL =)

[Malcolm]

The prob is that unless you put \' or " before a quote, then the php script that I wrote doesn't update the database properly, cause it ends at the quote.

I don't know how to tell php to ignore the single or double quote without the slash... or maybe to add the slash so mysql won't mess up ... I'm making this for users who I don't want to have to do much but type...

Try something like this
**NOTE** People should be doing this whenever they enter _ANYTHING_ into the database thats from user input.

Code: Select all

//where $string is the data to be entered into the database

if(get_magic_quotes_gpc()){
   $string = stripslashes($string);
}
$string = mysql_real_escape_string($string);


Now try to enter the variable into the database, you shouldn't have any problems.

[Driver]

ok, thanks a ton!

[Malcolm]

Don't forget to mark this topic as solved