Advertisement
Guest User

Untitled

a guest
Feb 7th, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. <?php
  2. $databasehost = "localhost";
  3. $databasename = "test2";
  4. $databasetable = "voters";
  5. $databaseusername="root";
  6. $databasepassword = "";
  7. $fieldseparator = ",";
  8. $fieldstartend = '"';
  9. $lineseparator = "\r";
  10. $csvfile = "AllVoters_01122016.csv";
  11.  
  12. if(!file_exists($csvfile)) {
  13. die("File not found. Make sure you specified the correct path.");
  14. }
  15.  
  16. try {
  17. $pdo = new PDO("mysql:host=$databasehost;dbname=$databasename",
  18. $databaseusername, $databasepassword,
  19. array(
  20. PDO::MYSQL_ATTR_LOCAL_INFILE => true,
  21. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
  22. )
  23. );
  24. } catch (PDOException $e) {
  25. die("database connection failed: ".$e->getMessage());
  26. }
  27.  
  28. $affectedRows = $pdo->exec("
  29. LOAD DATA LOCAL INFILE ".$pdo->quote($csvfile)." INTO TABLE `$databasetable`
  30. FIELDS TERMINATED BY ".$pdo->quote($fieldseparator)." ENCLOSED BY ".$pdo->quote($fieldstartend)."
  31. LINES TERMINATED BY ".$pdo->quote($lineseparator));
  32.  
  33. echo "Loaded a total of $affectedRows records from this csv file.\n";
  34.  
  35. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement