php uploading a csv file into a mysql table

Question

I'm trying to create a script where a user can upload a csv file into a table. I got the tutorial from shotdev.com, I'm getting the following errors, what am I doing wrong?

**The following command is not allowed: copy

The following command is not allowed: fopen**

Page1.php

<form action="page2.php" method="post" enctype="multipart/form-data" name="form1">
      <input name="fileCSV" type="file" id="fileCSV">
      <input name="btnSubmit" type="submit" id="btnSubmit" value="Submit">
    </form>

Page2.php

<?
    copy($_FILES["fileCSV"]["tmp_name"],"shotdev/".$_FILES["fileCSV"]["name"]); // Copy/Upload CSV

include 'datalogin.php';

    $objCSV = fopen("shotdev/".$_FILES["fileCSV"]["name"], "r");
    while (($objArr = fgetcsv($objCSV, 1000, ",")) !== FALSE) {
        $strSQL = "INSERT INTO customer ";
        $strSQL .="(CustomerID,Name,Email,CountryCode,Budget,Used) ";
        $strSQL .="VALUES ";
        $strSQL .="('".$objArr[0]."','".$objArr[1]."','".$objArr[2]."' ";
        $strSQL .=",'".$objArr[3]."','".$objArr[4]."','".$objArr[5]."') ";
        $objQuery = mysql_query($strSQL);
    }
    fclose($objCSV);

    echo "Import completed.";
?>

Tak · Accepted Answer · 2011-12-08 10:19:34Z

1

It looks like you're running PHP in safe mode or with certain functions disabled. For security reasons web hosts often disable file commands.

You could discuss your requirements with your web host - some are flexible enough to enable the functions for you if you ask nicely.

Otherwise you'll have to achieve it without using the disabled file commands. One way would be to create a textarea in an HTML form in which you paste the CSV. SUbmit it to your PHP script which then runs the MySQL import.

Hope that helps

answered Dec 8, 2011 at 10:19

Tak

11.8k5 gold badges33 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Marc Over a year ago

btw, it's propably the setting disable_functions (php.net/manual/en/ini.core.php)

Pekka · Accepted Answer · 2011-12-08 10:20:21Z

0

This seems to be a limitation imposed by the hosting provider (they seem to have put fopen() and copy() on the list of disabled functions, which is rather silly), in which case you probably can't do anything about it except ask the provider to relax the restriction.

Generally though, you're not handling the uploaded files properly using move_uploaded_file(). Use it as shown in the example in the manual link.

answered Dec 8, 2011 at 10:20

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

Collectives™ on Stack Overflow

php uploading a csv file into a mysql table

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related