MySQL Forums
Forum List  »  PHP

Re: single quote in data breaks file load
Posted by: Steve Szmidt
Date: July 26, 2005 02:35PM

Roland Bouman wrote:
> Just want to add that it might be necessary to use
> some user defined function as the second argument
> for array_walk. I dont know how
> mysql_real_escape_string will react to getting 2
> args passed, so:
> function my_mysql_real_escape_string($val,$key){
> return mysql_real_escape_string($val);
> }
> ..
> ..
> array_walk($data,'my_mysql_real_escape_string');

Thanks. I take it we are saying that since mysql is choking on the ' we are going to create a function which doesn't. So we insert this function after fgetcsv(). Could you please elaborate on the new function though? (I'm extra thick this pm.)

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.