Re: RE: [PHP] special characters with perl,mysql,php

2001-02-24 Thread Christian Reiniger
On Saturday 24 February 2001 07:49, Mitchell Hagerty wrote: > The special character I'm concerned with at the moment is the back tick > ` which mysql doesn't like on an insert. I was looking for a way not to > parse the entire file evertime I inserted or extracted them from the > database. Its sim

Re: RE: [PHP] special characters with perl,mysql,php

2001-02-23 Thread Mitchell Hagerty
The special character I'm concerned with at the moment is the back tick ` which mysql doesn't like on an insert. I was looking for a way not to parse the entire file evertime I inserted or extracted them from the database. Its simple enough todo in perl and php just seems like it would burn al

RE: [PHP] special characters with perl,mysql,php

2001-02-23 Thread ..s.c.o.t.t..
i use a regexp to slash-out single quotes for inclusion into an SQL query: // quote a value to make it appropriate for inclusion in an SQL string function db_quote($value) { return ereg_replace("'","\\'",$value); } > -Original Message- > From: Mitchell Hagerty [mailto:[EMAIL PROTECTE

Re: [PHP] special characters with perl,mysql,php

2001-02-23 Thread Kyndig
If your refering to: ' or " just use: addslashes($value); to escape special characters. On Fri, 23 Feb 2001, Mitchell Hagerty wrote: > Hey All, > > What would be a good method for inserting data into a blob field > that contained special characters using perl then retrieving that > data

Re: [PHP] special characters with perl,mysql,php

2001-02-23 Thread Joe Stump
What type of special characters? --Joe On Fri, Feb 23, 2001 at 08:54:09PM -0600, Mitchell Hagerty wrote: > Hey All, > > What would be a good method for inserting data into a blob field > that contained special characters using perl then retrieving that > data with php? > > URI::Escape has work