Addslashes()


#1

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Is there a built-in function in Ruby similar to PHP’s addslashes()
function?
MySQL keeps breaking…
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQFGf+p/2vy7v+d+psQRAqeDAKCLHdMotVW85fMMrBTKAezUHxQdRACfXsDb
gB5LfblLO7n3Gy+1kgo8mI4=
=YLAI
-----END PGP SIGNATURE-----


#2

“Fred P.” removed_email_address@domain.invalid writes:

Is there a built-in function in Ruby similar to PHP’s addslashes() function?
MySQL keeps breaking…

Well, this probably indicates that you’re doing sql by dynamically
building statements, which is generally a frowned-upon practice in
favor of using prepared statements with ? placeholders. However, if
you’re absolutely determined to do this:

def addslashes(str)
str.gsub(/[’"\\x0]/,’\\\0’)
end

def stripslashes(str)
str.gsub(/\(.)/,’\1’)
end


#3

Fred P. wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Is there a built-in function in Ruby similar to PHP’s addslashes()
function?
MySQL keeps breaking…

There should be a #escape_str or #quote method on the connection object
that will do what you’re after.