| Re: function for preserving special characters? [message #186104 is a reply to message #186078] |
Sat, 14 June 2014 00:45   |
Richard Damon
Messages: 58
Registered: August 2011
Karma:
|
Member |
|
|
On 6/13/14, 12:57 AM, richard wrote:
> When attempting to transfer records from one table to another, certain
> records refuse to be.
> Such as those with words like "I'm".
> What's even more confusing is, "It's" won't work, but "Cathy's" is ok?
>
> I know there is a procedure in PHP for dealing with this.
> I just can't find it right now.
> Can anyone help on this?
>
There are several ways to do this.
The first, is to use "Prepared Statements" to write to the database.
When you do this, you build of the command to perform independent of the
data to process (with place holders), and then connect this to the data
when you execute the prepared statement.
The other option is to use something like mysqli_real_escape_string()
function or mysqli::real_escape_string() (there is also
mysql_real_escaple_string() if you are still using the obsolete mysql
routines). You could also do this with a str_replace, but you need to
determine all the cases that need to be escaped (this isn't as simple as
it might first seem, as the manual implies that this may depend on the
character set selected.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]