PHP CSV Upload to Database

Here is the simplest way I know of to take a CSV (comma separated value) file and upload it through a form, catch it with PHP and slam all the records into a database table. This should only be used "as is" in a controlled environment, as there is no input validation whatsoever, but it is enough to get the point across if you have never done this before.

PLAIN TEXT

PHP:

<?php
//CHECK THAT THE FILE WAS UPLOADED
if (is_uploaded_file($_FILES['file']['tmp_name'])){
//THIS WILL HELP IF ANY CSV FILES CREATED BY A MAC
ini_set('auto_detect_line_endings',1);
//SPIN THROUGH THE RECORDS
$handle = fopen($_FILES['file']['tmp_name'], "r");
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
//INSERT A RCORD TO THE DATABASE
mysql_query("INSERT INTO `table` (`field1`,`field2`,`field3`) VALUES ('{$data[0]}','{$data[1]}','{$data[2]}')");
}
}
?>