Well, your immediate problem is because you're only removing the first apostrophe from the string. You need to use the /g operator on the substitution operator.

But, like Joost says, the real solution is to use the DBI quote method or placeholders.