List:General Discussion« Previous MessageNext Message »
From:Jasper Bryant-Greene Date:September 23 2005 1:18am
Subject:Re: mysql_real_escape_string question
View as plain text  
bruce wrote:
> from the docs... it appears the the mysql_real_escape_string function (from
> php) is used to backslash a set of chars in the string for insertion into
> the mysql db...
> 
> however, given that the '/' is mysql, vs ansi, i was wondering if there's a
> way to force it to use the ansi standard "'" instead of the "/".
> 
> this is in a php app, and i'd like to be as standard as possible in the
> event i need to change dbs..

Assuming you're using a database abstraction layer if you're worried 
about needing to change DBs, it should handle the different quoting 
formats between DBs.

i.e. when you are using MySQL the layer should use 
mysql_real_escape_string; if you are using another DB it should use that 
DB's function.

This was answered for you on the PHP list.

-- 
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/
Thread
mysql_real_escape_string questionbruce23 Sep
  • Re: mysql_real_escape_string questionJasper Bryant-Greene23 Sep
  • Re: mysql_real_escape_string questionSGreen23 Sep