Posted by Erwin Moller on 02/03/06 15:36

johnny wrote:

> hi all,
>
> I wonder why this little script doesn't work, maybe it's the provider
> not allowing the use of load data infile ( I know some don't let users
> to run some tasks ), could you please tell me if the script it's right
> before I ask the provider ?
> I can insert data into the table using fgetcsv as well with no
> problems,but I would like to understand.
>
> TIA
>
> johnny

Hi Johnny,

>
> <?php
>
> $table = "name of table here";
> $file = "absolute path to file uploaded /" ;
> $new_name = "list.csv"; // new name of the file uploaded
>
>
> $file_name = ($new_name) ? $new_name : $_FILES["upfile"]["name"];

I do not understand the reason for this line/test.
It always evalute to true, so $file_name will always be $new_name.

Did you copy it from another file that needs this test?


>
>
> $path = $file.$file_name ;

OK, so path is now:absolute path to file uploaded/list.csv


>
>
> if (copy($upfile, $path))

What is $upfile?
Udefined as far as I can see.

> {
> echo "upload Ok";
>
> } else {
> echo "upload failed";
> }
>
>
> $sql = "LOAD DATA INFILE '$path' FIELDS INTO TABLE $table
> (field1,field2) TERMINATED BY ';' LINES TERMINATED BY '\r\n' IGNORE 1
> LINES " or die();

You just create a string here.
Why add or die(); ???

I would advise you to put a few echo's in your script to check if the values
you use contain what you expect them to contain.
For starters: The name of an uploaded file in the tempdirectory is not the
filename specified by the sender.

Regards,
Erwin Moller

[Back to original message]