Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. if (isset($_POST['submit'])) {
  2. $allowed = array('csv');
  3. $filename = $_FILES['file']['name'];
  4. $ext = pathinfo($filename, PATHINFO_EXTENSION);
  5. if (!in_array($ext, $allowed)) {
  6. $message = 'Archivo invalido, porfavor usa un archivo .CSV!';
  7. } else {
  8.  
  9. move_uploaded_file($_FILES["file"]["tmp_name"], "files/" . $_FILES['file']['name']);
  10.  
  11. $file = "files/" . $_FILES['file']['name'];
  12.  
  13. $query = <<<eof
  14. LOAD DATA LOCAL INFILE '$file'
  15. INTO TABLE documento
  16. FIELDS TERMINATED BY ';'
  17. LINES TERMINATED BY 'rn'
  18. IGNORE 1 LINES
  19. (titulo_documento,proyecto,estado,idioma,num_documento,version,revision,descripcion,fecha,subcategoria,confidencialidad,tipo_documento,acro_usuario,aprobado_por,autorizado_por,revisor,compania,codigo_proyecto)
  20. eof;
  21. if (!$result = mysqli_query($con, $query)) {
  22. exit(mysqli_error($con));
  23. }
  24. $message = "CSV importado correctamente!";
  25. }
  26. }
  27.  
  28. drwxrwxrwx. 2 apache apache 4096 jul 21 10:34 files
  29.  
  30. Can't find file 'files/Documento2.csv'.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement