Is there an equivalent of PHP's mysql_real_escape_string() for Perl's DBI?

perl dbi mysql-real-escape-string
Phil Jackson picture Phil Jackson · Feb 5, 2010 · Viewed 10.8k times · Source

Could some tell me if there is a function which works the same as PHP's mysql_real_escape_string() for Perl from the DBI module?

Answer

Sinan Ünür picture Sinan Ünür · Feb 5, 2010

You should use placeholders and bind values.

Related questions

How do I know how many rows a Perl DBI query returns?

I'm trying to basically do a search through the database with Perl to tell if there is an item with a certain ID. This search can return no rows, but it can also return one. I have the following code: …

Read More
How do I connect with Perl to SQL Server?

I have a user id, password, database name and datasource details. I want to connect with Perl to a MSSQL server. I just used the following snippet, but I am getting an error. #!/usr/bin/perl -w use strict; use …

Read More
Fetch all records using Perl DBI

I have a Perl script that uses a DBI connection. I open and read the SQL script file using a sub routine. I am printing only one record, where I should have two more (three records total). How do I …

Read More