Dynamically display a CSV file as an HTML table on a web page

Question

I d like to take a CSV file living server-side and display it dynamically as an html table  E g   this   Name  Age  Sex  Cantor  Georg   163  M   should become this    lt html gt  lt body gt  lt table gt   lt tr gt   lt td gt Name lt  td gt   lt td gt Age lt  td gt   lt td gt Sex lt  td gt   lt  tr gt   lt tr gt   lt td gt Cantor  Georg lt  td gt   lt td gt 163 lt  td gt   lt td gt M lt  td gt   lt  td gt   lt  table gt  lt  body gt  lt  html gt    Solutions in any language are welcome

User · Answer

define  display it dynamically     that implies the table is being built via javascript and some sort of Ajax-y update    if you just want to build the table using PHP that s really not what I would call  dynamic

User · Answer

XmlGrid net has tool to convert csv to html table  Here is the link  http   xmlgrid net csvToHtml html  I used your sample data  and got the following html table    lt table gt   lt  --Created with XmlGrid Free Online XML Editor  http   xmlgrid net -- gt   lt tr gt     lt td gt Name lt  td gt     lt td gt  Age lt  td gt     lt td gt  Sex lt  td gt   lt  tr gt   lt tr gt     lt td gt Cantor  Georg lt  td gt     lt td gt  163 lt  td gt     lt td gt  M lt  td gt   lt  tr gt   lt  table gt

User · Answer

Just improved phihag s code because it runs into a infinite loop if file not exists    lt  php   filename    so-csv csv    echo   lt html gt  lt body gt  lt table gt  n n    if  file exists  filename      f   fopen  filename   r    while    line   fgetcsv  f       false            echo   lt tr gt            foreach   line as  cell                    echo   lt td gt     htmlspecialchars  cell      lt  td gt                      echo   lt  tr gt  n     fclose  f      else  echo   lt tr gt  lt td gt No file exists    lt  td gt  lt  tr gt      echo   n lt  table gt  lt  body gt  lt  html gt      gt

User · Answer

phihag s answer puts each row in a single cell  while you are asking for each value to be in a separate cell  This seems to do it    lt  php    Create a table from a csv file  echo   lt html gt  lt body gt  lt table gt  n n    f   fopen  so-csv csv    r    while    line   fgetcsv  f       false             row    line 0         We need to get the actual row  it is the first element in a 1-element array           cells   explode      row           echo   lt tr gt            foreach   cells as  cell                echo   lt td gt     htmlspecialchars  cell      lt  td gt                      echo   lt  tr gt  n     fclose  f   echo   n lt  table gt  lt  body gt  lt  html gt      gt

User · Answer

The previously linked solution is a horrible piece of code  nearly every line contains a bug  Use fgetcsv instead    lt  php echo   lt html gt  lt body gt  lt table gt  n n    f   fopen  so-csv csv    r    while    line   fgetcsv  f       false            echo   lt tr gt            foreach   line as  cell                    echo   lt td gt     htmlspecialchars  cell      lt  td gt                      echo   lt  tr gt  n     fclose  f   echo   n lt  table gt  lt  body gt  lt  html gt

User · Answer

Here is a simple function to convert csv to html table using php   function jj readcsv  filename   header false     handle   fopen  filename   r    echo   lt table gt      display header row if true if   header         csvcontents   fgetcsv  handle       echo   lt tr gt        foreach   csvcontents as  headercolumn            echo   lt th gt  headercolumn lt  th gt              echo   lt  tr gt         displaying contents while   csvcontents   fgetcsv  handle         echo   lt tr gt        foreach   csvcontents as  column            echo   lt td gt  column lt  td gt              echo   lt  tr gt      echo   lt  table gt    fclose  handle       One can call this function like jj readcsv  image links csv  true    if second parameter is true then the first row of csv will be taken as header title   Hope this helps somebody  Please comment for any flaws in this code

User · Answer

HTML     tag can do that itself i e  no PHP or java   or see this post for complete detail on the above  with all options       http   www linuxquestions org questions programming-9 how-to-show-csv-data-as-html-in-internet-explorer-with-filter-buttons-4175443612

User · Answer

Does it work if you escape the quoted commas with          Name  Age  Sex        Cantor   Georg   163 M   Most delimited formats require that their delimiter be escaped in order to properly parse     A rough Java example   import java util Iterator   public class CsvTest        public static void main String   args            String   lines      Name  Age  Sex      Cantor  Georg    163  M              StringBuilder result   new StringBuilder             for  String head   iterator lines 0                  result append String format   lt tr gt  s lt  tr gt  n   head                       for  int i 1  i  lt  lines length  i                  for  String row   iterator lines i                      result append String format   lt td gt  s lt  td gt  n   row                                     System out println String format   lt table gt  n s lt  table gt    result toString                 public static Iterable lt String gt  iterator final String line            return new Iterable lt String gt                  public Iterator lt String gt  iterator                     return new Iterator lt String gt                          private int position   0                       public boolean hasNext                             return position  lt  line length                                               public String next                             boolean inquote   false                          StringBuilder buffer   new StringBuilder                            for    position  lt  line length    position                                  char c   line charAt position                               if  c                                           inquote    inquote                                                            if  c         amp  amp   inquote                                    position                                    break                                else                                   buffer append c                                                                                   return buffer toString   trim                                               public void remove                             throw new UnsupportedOperationException

[php] Dynamically display a CSV file as an HTML table on a web page

Examples related to php

Examples related to html

Examples related to csv