How to import csv file to mysql

[eluser]Near[/eluser]
Hi thanks for the help. i managed to insert the contents of csv files into mySQL using this query.

Code:

$fcontents = file('./uploads/'.$filename);
for($i=0;$i<sizeof($fcontents); $i++)
{
$line = trim($fcontents[$i]);
$arr = explode(",",$line);
$sql = "INSERT INTO user(name,id) VALUES ('".implode("','",$arr)."')";
$result = mysql_query($sql);
                                    
if(mysql_error())
                        
{
$flag = 2;
return $flag;
return $filename;
die('upload failed');
                            
}
    
}
else
{
$flag = 2;
return $flag;
}