PHP not reading the entire CSV file

Question

I've written a simple bit of code to test two parameters and forward the user to a link.

error_reporting(E_ALL|E_STRICT);
ini_set("display_errors", "On");
$secure_box=$_GET['query'];
$fh = fopen('db.csv', 'r');
$now = date("d.m.Y");
$data=fgetcsv($fh);
$first_name=$data[0];
$date=$data[1];
$url=$data[2];
{
if($secure_box == $first_name AND $date>=$now)
{
   header("Location: $url");
   exit();
}
else
  {
   header("Location: http://localhost/x/delivery_method.html");
  }
    exit;
?>

My problem here is that the entire CSV file is not being read. What can I do ?

Well... you're... only reading one line... Or am I misunderstanding something? — deceze
– deceze ♦, Commented Jun 16, 2011 at 6:56
What is db.csv? Is it a single line, delimited by commas, and with each field optionally enclosed with double quotes? — Matthew
– Matthew, Commented Jun 16, 2011 at 6:58
The answer given on stackoverflow.com/questions/6332686/… shows you how to loop. — Matthew
– Matthew, Commented Jun 16, 2011 at 7:00
possible duplicate of how to extract data from csv file in php — Gordon
– Gordon, Commented Jun 16, 2011 at 7:04

score 8 · Accepted Answer · 2011-06-16 11:08:15Z

8

The entire file isn't being read because you only called fgetcsv once. fgetcsv only reads one line at a time, you need to put the that code in a loop.

Here is an example of how to use fgetcsv in a loop, from the php docs at http://www.php.net/fgetcsv:

<?php
// Example #1 Read and print the entire contents of a CSV file
$row = 1;
if (($handle = fopen("test.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
        echo "<p> $num fields in line $row: <br /></p>\n";
        $row++;
        for ($c=0; $c < $num; $c++) {
            echo $data[$c] . "<br />\n";
        }
    }
    fclose($handle);
}
?>

edited Jun 16, 2011 at 11:08

answered Jun 16, 2011 at 6:58

user456814

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

Comments

score 2 · Accepted Answer · 2011-06-16 20:43:31Z

2

This is what I've been able to come up with..Hope it's right

<?php
error_reporting(E_ALL|E_STRICT);
ini_set("display_errors", "On");
$name_value = $_GET['query'];
$fh = fopen('db.csv', 'r');
$now = date("d.m.Y");
$line = 1;
if (($handle = fopen("db.csv", "r")) !== FALSE)
{
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
    {
        $num = count($data);
        $line++;
        for ($c = 0; $c < $num; $c++)
        {
            if ($name_value == $data[0] AND $data[1] >= $now)
            {
               header("Location: $data[2]");
               exit();
            }
            else
            {
                header("Location: http://localhost/x/client_unauthorized.html");
            }
        }
    }
    fclose($handle);
}   
?>

edited Jun 16, 2011 at 20:43

answered Jun 16, 2011 at 19:14

user707165

Comments

Ignacio Vazquez-Abrams · Accepted Answer · 2011-06-16 06:56:04Z

1

You can loop to read the whole file line by line until EOF, and check each row in turn.

answered Jun 16, 2011 at 6:56

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Collectives™ on Stack Overflow

PHP not reading the entire CSV file

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related