How to read Multiple CSV file data in php

Question

I am trying to import 6 files which are in zip files. First I extract those files after that I want to get all the data in these files. But currently I am getting only the first file data. The script had not read the second file. I don't understand how to get rid from this problem.

Here is my code.

<?php

if ($_FILES) {
    $filename       = $_FILES["zip_file"]["name"];
    $source         = $_FILES["zip_file"]["tmp_name"];
    $type           = $_FILES["zip_file"]["type"];
    $name           = explode(".", $filename);
    $accepted_types = array(
        'application/zip',
        'application/x-zip-compressed',
        'multipart/x-zip',
        'application/x-compressed'
    );
    foreach ($accepted_types as $mime_type) {
        if ($mime_type == $type) {
            $okay = true;
            break;
        }
    }

    $continue = strtolower($name[1]) == 'zip' ? true : false;
    if (!$continue) {
        $message = "The file you are trying to upload is not a .zip file. Please try again.";
    }
    $target_path = "zip/" . $filename;

    if (move_uploaded_file($source, $target_path)) {
        $zip = new ZipArchive();
        $x   = $zip->open($target_path);
        $col = array();
        if ($x === true) {
            for ($x = 0; $x < $zip->numFiles; $x++) {

                $csv = $zip->getNameIndex($x);

                $zip->extractTo("zip/");

                $csv_path = "zip/" . $csv;

                if (($handle = fopen($csv_path, "r")) !== FALSE) {
                    fgetcsv($handle);
                    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

                        $num = count($data);

                        for ($c = 0; $c < $num; $c++) {
                            $col[$c] = $data[$c];

                        }
                        echo "<pre>";
                        print_r($col);
                    }

                    fclose($handle);

                }

            }


            $zip->close();
            unlink($target_path);
            exit;
        }
        $message = "Your .zip file was uploaded and unpacked.";
    } else {
        $message = "There was a problem with the upload. Please try again.";
    }
}
?>

Any help would be Highly appreciated.

If my answer helped, can you mark it as correct? Or can you tell me how it didn't work? — HoldOffHunger
– HoldOffHunger, Commented Oct 27, 2016 at 22:15

HoldOffHunger · Accepted Answer · 2016-10-22 15:13:46Z

1

Look at this part of your code...

<?php
    // ...code...
    $zip->extractTo("zip/");

    $csv_path = "zip/" . $csv;

    if (($handle = fopen($csv_path, "r")) !== FALSE) {
        fgetcsv($handle);
        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        // ...code...
?>

extractTo() extracts the files. There are six files, you said. Then you do fopen(), and you do it once. You want to do that fopen() on each of the files.

What you'll want is...

<?php
    // ...code... (files are extracted at this point)
        $files = files('zip/');
        for($i = 0; i < count($files); $i++) {
            $file = $files[$i];
            // ...do csv stuff here for $file
        }
    // ...code...
?>

answered Oct 22, 2016 at 15:13

HoldOffHunger

21.3k11 gold badges123 silver badges147 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to read Multiple CSV file data in php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related