Addslashes()

Ruby
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.” [email protected] 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.