SQL search with names like O'

[ThunderAI]

Just how do I do that?

 

Here is a typical sql statement:

 

$nsql = '(`fieldname` LIKE CONVERT(_utf8 \'%'.$arr[0].'%\' USING latin1) COLLATE latin1_swedish_ci ';

 

a name like O'Reily would go in the array $arr[0]. If I try to put two ''s in name then the program crashes.  What am I missing?

[revraz]

Are you adding slashes when you insert into the DB?

[ThunderAI]

Are you adding slashes when you insert into the DB?

 

The information comes from a CSV file. If I manualy add the slashes into the CSV file it works. I suppose I could do a search of the column see if there is a ' in it and add a \ right before it.  What would that code even look like?

[revraz]

How are you bringing the contents of the CSV file into the DB?  You should be able to use addslashes when you insert.

[ThunderAI]

How are you bringing the contents of the CSV file into the DB?  You should be able to use addslashes when you insert.

 

It never is brought into a DB, its read into an array and then pared against something already in a DB.  The CSV file never is imported. I could add the slahes when I read the data into the array.  But how?

 

Here is the code to explode the line of the CSV file into an array

 

$line = trim($fcontents[$i],',');

$arr = explode(",",$line);