CSV into MySQL using PHP

[addybo]

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.\[code\]session_start();require('includes/dbconnect.php');require 'includes/header.inc.php';//check for file uploadif (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 = http://stackoverflow.com/questions/9129302/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()); }}\[/code\]