How to import csv file in PHP

Question

I am very new to web development  In fact  I am just starting to learn   Can somebody please give a complete but very simple example on how to import CSV file in PHP  I tried the one I got from the internet but I m very confused because it s complicated for me  I am using the WAMP server with PHP 5 3 5  Apache 2 2 17  and MySQL 5 5 8  Please help   I tried to paste the code but it s messy  Honestly  I am also very new to StackOverflow

User · Answer

row   1       arrResult    array        if    handle   fopen  ifsc code csv    r        FALSE            while    data   fgetcsv  handle  1000            FALSE                 num   count  data               DB  table  banks  - gt insert                  array  bank name    gt   data 1    ifsc    gt   data 2    micr    gt   data 3    branch name    gt   data 4   address    gt   data 5    contact    gt   data 6    city    gt   data 7   district    gt   data 8   state    gt   data 9                                    fclose  handle

User · Answer

I know that this has been asked more than three years ago  But the answer accepted is not extremely useful   The following code is more useful    lt  php  File    loginevents csv     arrResult    array     handle       fopen  File   r    if empty  handle      false        while   data   fgetcsv  handle  1000            FALSE            arrResult      data            fclose  handle     print r  arrResult     gt

User · Answer

If you use composer  you can try CsvFileLoader

User · Answer

PHP   5 3 use fgetcsv   or str getcsv    Couldn t be simpler

User · Answer

From the PHP manual    lt  php  row   1  if    handle   fopen  test csv    r        FALSE        while    data   fgetcsv  handle  1000            FALSE             num   count  data           echo   lt p gt   num fields in line  row   lt br   gt  lt  p gt  n            row            for   c 0   c  lt   num   c                  echo  data  c      lt br   gt  n                       fclose  handle       gt

User · Answer

The simplest way I know   str getcsv    it will import a CSV file into an array    csv   array map  str getcsv   file  data csv

User · Answer

Here is the version to extract the specific columns by name  modified from  coreyward     row   0   headers        filepath    input csv   if    handle   fopen  filepath   r        FALSE        while    data   fgetcsv  handle  1000            FALSE            if     row    1               headers   array flip  data      Get the column names from the header            continue            else              col1    data  headers  Col1Name        Read row by the column name             col2    data  headers  Col2Name               print  Row  row   col1   col2 n                       fclose  handle

User · Answer

filename mktime         FILES  import    name            path  common csv    filename       if move uploaded file   FILES  import    tmp name    path      if mysql query  load data local infile     path    INTO TABLE tbl customer FIELDS TERMINATED BY     enclosed by      LINES TERMINATED BY   n  IGNORE 1 LINES   location    maildropdate   contact number   first name   mname   lastname   suffix   address   city   state   zip                   echo  imported successfully       echo   lt br gt    Uploaded Successfully   path       look here for futher info

[php] How to import csv file in PHP?

Examples related to php

Examples related to csv