Advertisement
Guest User

Untitled

a guest
Dec 8th, 2016
262
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 7890 Can't find file
  2.  
  3. $csv_upload_status = "none";
  4. $sec_pass = "4220334";
  5.  
  6. $databasehost = "127.0.0.3";
  7. $databasename = "database_name";
  8. $databasetable = "table_name";
  9. $databaseusername="database_user";
  10. $databasepassword = "XXXXXXXXXXXX";
  11. $fieldseparator = ",";
  12. $lineseparator = "r";
  13.  
  14.  
  15. if(isset($_POST["submit"])) {
  16.  
  17. $valid = 1;
  18. $target_dir = "schedule-uploads/";
  19. $target_file = $target_dir . basename($_FILES["csv"]["name"]);
  20. $FileType = pathinfo($target_file,PATHINFO_EXTENSION);
  21.  
  22. if ($valid == 1) {
  23.  
  24. move_uploaded_file($_FILES["csv"]["tmp_name"], $target_file);
  25.  
  26. $csvfile = basename( $_FILES["csv"]["name"]);
  27.  
  28.  
  29. try {
  30. $pdo = new PDO("mysql:host=$databasehost;dbname=$databasename",
  31. $databaseusername, $databasepassword,
  32. array(
  33. PDO::MYSQL_ATTR_LOCAL_INFILE => true,
  34. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
  35. )
  36. );
  37. } catch (PDOException $e) {
  38. die("database connection failed: ".$e->getMessage());
  39. }
  40.  
  41. $affectedRows = $pdo->exec("
  42. LOAD DATA LOCAL INFILE ".$pdo->quote($csvfile)." INTO TABLE `$databasetable`
  43. FIELDS TERMINATED BY ".$pdo->quote($fieldseparator)."
  44. LINES TERMINATED BY ".$pdo->quote($lineseparator)."
  45. (@date, show_time, show_title, show_plot)
  46. SET show_date = STR_TO_DATE(@date, '%m/%d/%Y');");
  47.  
  48. $csv_upload_status = "success";
  49.  
  50. }
  51.  
  52. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement