0

I'm trying to import data from my students.csv file into mysql using php. The entries in the csv file is in such a way that column (student_number, fname, lname, level) will be inserted into biodata table..

I'm also uploading the student.csv file from my computer.

When I run the page I dont get anything out on the screen.

session_start();
require('includes/dbconnect.php');
require 'includes/header.inc.php';

//check for file upload
if (isset($_FILES['csv_file']) && is_uploaded_file($_FILES['csv_file']['tmp_name'])) {
    //upload directory
    $upload_dir = "C:\Users\DOTMAN\Documents\students.csv";
    //create file name
    $file_path = $upload_dir . $_FILES['csv_file']['name'];
    //move uploaded file to upload dir
    if (!move_uploaded_file($_FILES['csv_file']['tmp_name'], $file_path)) {
        //error moving upload file
        echo "Error moving file upload";
    }
    //open the csv file for reading
    $handle = fopen($file_path, 'r');
    //turn off autocommit and deletethe bio data
    mysql_query("SET AUTOCOMMIT=0");
    mysql_query("BEGIN");
    mysql_query("TRUNCATE TABLE biodata") or die(mysql_error());
    while (($data = fgetcsv($handle, 1000, ',')) !== FALSE) {
        //Access field data in $data array ex.
        $student_number = $data[0];
        $fname = $data[1];
        $lname = $data[2];
        $level = $data[3];
        //Use data to insert into db
        $query = "INSERT INTO biodata (student_number, fname, lname, level)
                  VALUES ('$student_number', '$fname', '$lname', '$level')";
        mysql_query($query) or die (mysql_error());
    }
}
Improve this question
8
  • 2
    is it because it runs without a error?.. try and add some ` echo ` statements and see what happens Commented Feb 3, 2012 at 13:22
  • Any errors in the server log? Commented Feb 3, 2012 at 13:23
  • there are no errors in the server log. Commented Feb 3, 2012 at 13:24
  • 1
    Posting such a code without any attempt to format it shows your disrespect to comunity. Commented Feb 3, 2012 at 13:33
  • 1
    have you tried setting php to display errors with error_reporting(E_ALL & ~E_NOTICE); ini_set('display_errors', 1); ini_set('display_startup_errors', 1); ini_set('output_buffering', 0); Commented Feb 3, 2012 at 13:42

5 Answers 5

Reset to default
1

I'd suggest you to upload CSV-file with LOAD DATA INFILE command. This is fast method.

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

1 Comment

Yes that is a possibility, but i'm planning to deploy to the public very soon. Thanks
0

if you only need to do this once, i would consider using something like: http://csv2sql.com/

Improve this answer

Comments

0

One immediate issue I can see is here:

$upload_dir = "C:\Users\DOTMAN\Documents\students.csv";

//create file name
$file_path = $upload_dir . $_FILES['csv_file']['name'];

You are already assigning the entire path, including the file name, to the $upload_dir variable - and then you're appending the uploaded file name again.

If you think there are errors in your code, start by adding

ini_set('display_errors', 1);
error_reporting(E_ALL);

to the beginning of your PHP code and fix any warnings/errors displayed. You can then turn off printing error messages by changing the second parameter to 0 in the first call.

Improve this answer

Comments

0

Have u debug the $_FILES: 

print_r($_FILES);

before doing any thing

Improve this answer

2 Comments

The file was uploaded. And i got values for Name, Type, Temp-Name, error and size. But the values of the data inside is still not inserted into the database. Please help me.
now check your $file_path path and file is uploaded properly. You have to do debugging also.
0

Solution using PHP

$file = 'path/to.csv'; 

$lines = file($file);
$firstLine = $lines[0];
foreach ($lines as $line_num => $line) {
    if($line_num==0) { continue; } //escape the header column
    $arr = explode(",",$line);
    $column1= $arr[0];
    $column2= $arr[1];
       
    echo $column1.$column2."<br />";
        //put the mysql insert statement here
}
Improve this answer

Comments