PHP PDO Import CSV file into MySQL Database

PHP
67

This is being used as a form, so it will have to be a file upload. Here is my code implemented with my form code:

<?php

include('dbconnect.php');

if(isset($_POST['btn_upload'])){
	$file = fopen("demo.csv","r");


	// Read and throw away the header row
	fgetcsv($file);

	$stmt = $pdo->prepare("INSERT INTO test_import (name, residential_address, mailing_address, precinct, age, ethnicity, gender, party, race, phone) VALUES (:name, :residential_address, :mailing_address, :precinct, :age, :ethnicity, :gender, :party, :race, :phone)");

	while (! feof($file)) {
  		$row = fgetcsv($file);
  		$stmt->bindParam(':name', $row[0]);
  		$stmt->bindParam(':residential_address', $row[1]);
  		$stmt->bindParam(':mailing_address', $row[2]);
  		$stmt->bindParam(':precinct', $row[3]);
  		$stmt->bindParam(':age', $row[4]);
  		$stmt->bindParam(':ethnicity', $row[5]);
  		$stmt->bindParam(':gender', $row[6]);
  		$stmt->bindParam(':party', $row[7]);
  		$stmt->bindParam(':race', $row[8]);
  		$stmt->bindParam(':phone', $row[9]);
  		$stmt->execute();
}

	fclose($file);
	header("Location: ../members_list.php");
}

if(isset($_POST['btn_back'])) {
	header("Location: ../members_list.php");
}

?>