how to store " " ' ' characters in a field?
Posted 08 July 2006 - 05:53 AM
because in the " " is very sensitive, how do we store into mysql field? do we have to replace the " with something else first and when called back, we replace back again? any examples on the functions?
Posted 08 July 2006 - 09:10 AM
then do an insert query and it should put - this is \"quoted\" text into the db for you
8Baller.co.uk : Free Multiplayer Pool [url=http://8Baller.co.uk]
Posted 08 July 2006 - 04:20 PM
Yea, probably. So you could just do:
Won't that variable declaration throw a parsing error in PHP? Regardless, addslashes() to escape these special characters in what you need.
$var = addslashes("This is "quoted" text");
Posted 09 July 2006 - 06:56 AM
Posted 10 July 2006 - 10:15 AM
But how do you actually "strip" (or essentially reverse) what this function does, or does the replacement of the extra characters only occur in mysql, and when the value stored in the database is returned, these are returned as normal - allowing you to just use stripslashes?
You could also use mysql_real_escape_string.
Furthermore I note some saying check whether your gpc_quotes or whatever is on (the thing that automatically addslashes to your POST/GEt/COOKIES before running an addslashes - to ensure you don't escape things twice - but when you run stripslashes it appears to remove ALL "\" characters, and not just doubled up ones. Presents a problem of also how to preserve a "\" character in the event that it is supposed to be in there too!
Any help with my understanding here would be greatly appreciated, as I am suddenly having to swap a DB from mssql to mysql, and am trying to ensure that I won't stuff it up too badly in MSSQL you just did a str_replace("'", "''", $var) - and when it was returned, well - it automatically "lost" the extra ' that was inserted, meaning no formatting required
Posted 10 July 2006 - 04:50 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users