importing a csv into the db

[eluser]alberto24[/eluser]
[quote author="ray73864" date="1225857031"]as i said before, you need to copy the file to a temporary directory, php can copy to /tmp/ so create an upload script that uploads the file to /tmp/ then use that in the load data infile and when the import is complete have php 'unlink' the file.[/quote]

same error with the tmp file

here's the full error:

Code:

A Database Error Occurred
Error Number: 1045

Access denied for user '369706_cloud1'@'%' (using password: YES)

LOAD DATA INFILE "/tmp/moo.csv" REPLACE INTO TABLE csvtest FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' (f_name, l_name, country, @dummy, phone)

and full code

Code:

function index ()
    {  
    if ( !copy("/mnt/target03/fullpath/csv/test1.csv", "/tmp/moo_item.csv") )
            $data['message'] = "Could not copy CSV file to temporary directory ready for importing.";

        $query = $this->db->query("LOAD DATA INFILE \"/tmp/moo_item.csv\" REPLACE INTO TABLE csvtest FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\\n' (f_name, l_name, country, @dummy, phone)",array('/tmp/moo_item.csv'));
        
        if ($query) {
            $data['message'] = "All items imported successfully.";
        } else {
            $data['message'] = "Import failed.";
        }
        
        unlink ("/tmp/moo_item.csv");

    }