apostrophe breaking an insert query from import csv file

[beary]

Hi all,

I have the code:

if(is_uploaded_file($_FILES['file']['tmp_name'])) 
    {
    move_uploaded_file($_FILES['file']['tmp_name'],$_FILES['file']['name']);
    }
 
$fcontents = file ('students.csv'); 
$size=sizeof($fcontents);
for($i=0; $i<sizeof($fcontents); $i++) 
    { 
    $line = trim($fcontents[$i]); 
    $arr = explode(",", $line); 
 
    $sql = "insert into staffcba_students values ('','$user','$pass','$classyear','$classname','$classid','".implode("','",$arr)."')"; 
    mysql_query($sql);
 
    if(mysql_error()) 
        {
        echo mysql_error() ."<br>\n";
              } 
    }
 

The csv file looks like

Peter,Porridge, M
Ethel,Elephant, F

All works perfectly until one of the names has an apostrophe

Eg.
Peter,O'Toole,M

Now I can see why it's breaking it. But I'm not sure how to fix the problem.

I tried addslashes around the trim($fcontents[$i]), but to no avail. Can anyone suggest a simple solution?

[stepterr]

Take a look at the get_magic_quote s_gpc function. I think that may solve your problem. Link