How to upload and parse a CSV file in php

Question

I want to upload a csv file with php   After the file is uploaded  I want to display the data of the CSV file   I would like an example how to accomplish this task

User · Accepted Answer

Although you could easily find a tutorial how to handle file uploads with php, and there are functions (manual) to handle CSVs, I will post some code because just a few days ago I worked on a project, including a bit of code you could use...

HTML:

<table width="600">
<form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post" enctype="multipart/form-data">

<tr>
<td width="20%">Select file</td>
<td width="80%"><input type="file" name="file" id="file" /></td>
</tr>

<tr>
<td>Submit</td>
<td><input type="submit" name="submit" /></td>
</tr>

</form>
</table>

PHP:

if ( isset($_POST["submit"]) ) {

   if ( isset($_FILES["file"])) {

            //if there was an error uploading the file
        if ($_FILES["file"]["error"] > 0) {
            echo "Return Code: " . $_FILES["file"]["error"] . "<br />";

        }
        else {
                 //Print file details
             echo "Upload: " . $_FILES["file"]["name"] . "<br />";
             echo "Type: " . $_FILES["file"]["type"] . "<br />";
             echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
             echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";

                 //if file already exists
             if (file_exists("upload/" . $_FILES["file"]["name"])) {
            echo $_FILES["file"]["name"] . " already exists. ";
             }
             else {
                    //Store file in directory "upload" with the name of "uploaded_file.txt"
            $storagename = "uploaded_file.txt";
            move_uploaded_file($_FILES["file"]["tmp_name"], "upload/" . $storagename);
            echo "Stored in: " . "upload/" . $_FILES["file"]["name"] . "<br />";
            }
        }
     } else {
             echo "No file selected <br />";
     }
}

I know there must be an easier way to do this, but I read the CSV file and store the single cells of every record in an two dimensional array.

if ( isset($storagename) && $file = fopen( "upload/" . $storagename , r ) ) {

    echo "File opened.<br />";

    $firstline = fgets ($file, 4096 );
        //Gets the number of fields, in CSV-files the names of the fields are mostly given in the first line
    $num = strlen($firstline) - strlen(str_replace(";", "", $firstline));

        //save the different fields of the firstline in an array called fields
    $fields = array();
    $fields = explode( ";", $firstline, ($num+1) );

    $line = array();
    $i = 0;

        //CSV: one line is one record and the cells/fields are seperated by ";"
        //so $dsatz is an two dimensional array saving the records like this: $dsatz[number of record][number of cell]
    while ( $line[$i] = fgets ($file, 4096) ) {

        $dsatz[$i] = array();
        $dsatz[$i] = explode( ";", $line[$i], ($num+1) );

        $i++;
    }

        echo "<table>";
        echo "<tr>";
    for ( $k = 0; $k != ($num+1); $k++ ) {
        echo "<td>" . $fields[$k] . "</td>";
    }
        echo "</tr>";

    foreach ($dsatz as $key => $number) {
                //new table row for every record
        echo "<tr>";
        foreach ($number as $k => $content) {
                        //new table cell for every field of the record
            echo "<td>" . $content . "</td>";
        }
    }

    echo "</table>";
}

So I hope this will help, it is just a small snippet of code and I have not tested it, because I used it slightly different. The comments should explain everything.

User · Answer

Hi I feel str getcsv     Parse a CSV string into an array  is the best option for you    You need to upload the file to sever  parse the file using str getcsv  run through the array and align as per u need in your website

User · Answer

function doParseCSVFile  filesArray                if   file exists  filesArray  frmUpload    name      amp  amp   is readable  filesArray  frmUpload    name                       strFilePath    filesArray  frmUpload    tmp name                   strFileHandle   fopen  strFilePath  r                 line of text   fgetcsv  strFileHandle 1024                         line of text   fgetcsv  strFileHandle 1024                         do                    if   line of text 0                           strInsertSql    INSERT INTO tbl employee employee name  employee code  employee email  employee designation  employee number VALUES    addslashes  line of text 0           line of text 1         addslashes  line of text 2           line of text 3          line of text 4                            ExecuteQry  strInsertSql                                                  while    line of text   fgetcsv  strFileHandle 1024              FALSE              else               return FALSE

User · Answer

You can try with this   function doParseCSVFile  filesArray        if   file exists  filesArray  frmUpload    name      amp  amp   is readable  filesArray  frmUpload    name                   strFilePath    filesArray  frmUpload    tmp name               strFileHandle   fopen  strFilePath  r             line of text   fgetcsv  strFileHandle 1024                     line of text   fgetcsv  strFileHandle 1024                     do                if   line of text 0                       strInsertSql    INSERT INTO tbl employee employee name  employee code  employee email  employee designation  employee number VALUES    addslashes  line of text 0           line of text 1         addslashes  line of text 2           line of text 3          line of text 4                        ExecuteQry  strInsertSql                                          while    line of text   fgetcsv  strFileHandle 1024              FALSE          else           return FALSE

User · Answer

untested but should give you the idea  the view    lt form action  upload php  method  post  enctype  multipart form-data  gt   lt input type  file  name  csv  value      gt   lt input type  submit  name  submit  value  Save    gt  lt  form gt    upload php controller     csv   array        check there are no errors if   FILES  csv    error      0        name     FILES  csv    name         ext   strtolower end explode        FILES  csv    name            type     FILES  csv    type         tmpName     FILES  csv    tmp name            check the file is a csv     if  ext      csv            if   handle   fopen  tmpName   r        FALSE                   necessary if a large csv file             set time limit 0                 row   0               while   data   fgetcsv  handle  1000            FALSE                       number of fields in the csv                  col count   count  data                       get the values from the csv                  csv  row   col1      data 0                    csv  row   col2      data 1                       inc the row                  row                              fclose  handle

User · Answer

You want the handling file uploads section of the PHP manual  and you would also do well to look at fgetcsv   and explode

User · Answer

This can be done in a much simpler manner now    tmpName     FILES  csv    tmp name     csvAsArray   array map  str getcsv   file  tmpName      This will return you a parsed array of your CSV data  Then you can just loop through it using a foreach statement

[php] How to upload and parse a CSV file in php

Examples related to php

Examples related to csv