Php csv upload error

Question

I am trying to upload a csv file and save it in db. The problem is its returning Notice Error

Notice: Use of undefined constant csv - assumed 'csv' in D:\xampp\htdocs\nag\admin\process\upload_case.php on line 5

Notice: Use of undefined constant size - assumed 'size' in D:\xampp\htdocs\nag\admin\process\upload_case.php on line 5

Notice: Undefined index: csv in D:\xampp\htdocs\nag\admin\process\upload_case.php on line 5

I have stuck with it since 2 hours debugging, can some one please help fix.

Below is the code.

<?php    
include "../config/config.php";

if ($_FILES[csv][size] > 0) { 

    //get the csv file 
    $file = $_FILES[csv][tmp_name]; 
    $handle = fopen($file,"r"); 

    //loop through the csv file and insert into database 
    do { 
        if ($data[0]) { 
            mysql_query("INSERT INTO case_view (
                    courtname, casenumber, year, pfname, plname, 
                    cell, fhearing, cstatus, cdescri
                ) VALUES  (
                    '" . addslashes($data[0]) . "',
                    '" . addslashes($data[1]) . "',
                    '" . addslashes($data[2]) . "',
                    '" . addslashes($data[3]) . "',
                    '" . addslashes($data[4]) . "',
                    '" . addslashes($data[5]) . "',
                    '" . addslashes($data[6]) . "',
                    '" . addslashes($data[7]) . "',
                    '" . addslashes($data[8]) . "'
                )
            "); 
        } 
    } while ($data = fgetcsv($handle, 1000, ",", "'"));
    // 

    //redirect 
    header('Location: import.php?success=1'); die;
   // echo "Import Successfull";
}

?>

You may consider using PDO with prepared statements for performance reasons. — php-dev
– php-dev, Commented Apr 27, 2015 at 4:55

Sougata Bose · Accepted Answer · 2015-04-27 04:46:45Z

4

When you are using $_FILES[csv] without quotes it will assume that csv is a constant, so wrap it up with quotes and try again. Try with -

if ($_FILES['csv']['size'] > 0) { 
    .....
    $file = $_FILES['csv']['tmp_name'];

Add a check for it -

if (!empty($_FILES['csv']['size']) && $_FILES['csv']['size'] > 0) { 
       ..............

edited Apr 27, 2015 at 4:46

answered Apr 27, 2015 at 4:01

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

4 Comments

Shyam Kashyap Over a year ago

Thanks, by adding the Quotes 2 Notice error disappeared but still i get 1 notice error Notice: Undefined index: csv in D:\xampp\htdocs\nag\admin\process\upload_case.php on line 5

Shyam Kashyap Over a year ago

Now i do not see any error but its directly exiting the if loop

Sougata Bose Over a year ago

Add the form structure.

Shyam Kashyap Over a year ago

Ok, i had missed enctype=multipart/form-data now it works great and also save in db, but i get this notice error even though the data is inserted Notice: Undefined variable: data in D:\xampp\htdocs\nag\admin\process\upload_case.php on line 13

V13Axel · Accepted Answer · 2015-04-27 03:29:16Z

0

You have a syntax error. You open an if block on line 5, but never close it after your while loop.

answered Apr 27, 2015 at 3:29

V13Axel

8385 silver badges10 bronze badges

1 Comment

Shyam Kashyap Over a year ago

Thanks, i closed the if loop, but i started getting notice error Notice: Use of undefined constant csv - assumed 'csv' in D:\xampp\htdocs\nag\admin\process\upload_case.php on line 5 Notice: Use of undefined constant size - assumed 'size' in D:\xampp\htdocs\nag\admin\process\upload_case.php on line 5 Notice: Undefined index: csv in D:\xampp\htdocs\nag\admin\process\upload_case.php on line 5

Collectives™ on Stack Overflow

Php csv upload error

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related