Re: [PHP] fgetcsv

You are so right, takes all of 0.122 s to process the whole file with
the fgetcsv inside the while loop.... Guess I need to look up why this
was the problem.

Thanks everyone!


On Wed, 2008-01-09 at 20:59 -0600, Richard Lynch wrote:
6500 rows is chump-change.

You probably don't have the fgetcsv inside the while loop to get past
the first row... :-)

On Wed, January 9, 2008 6:09 pm, Danny Brow wrote:
I need to compare the first field of each row. But this idea is shot
to
hell, i've been running one of the examples on the file and it's been
about an hour+ already... 6500 records have to be checked... I think
MySQL is calling my name right now.

Thanks,
Dan


On Thu, 2008-01-10 at 09:59 +1100, Chris wrote:
Danny Brow wrote:
Hi Everyone,

I'm trying to compare a value to the first field in a csv fILE
(example
of the data below). Using while takes too long and I can't figure
out
how to compare just one row at a time. I've tried some variations
of the
following.

So are you trying to compare the first column or the first row?
You've
said you want to compare both.

To compare the first row:

<?php

$handle = fopen('file.csv', 'r') or die("unable to open file");

$my_row = array('1','2','John Smith');

$data = fgetcsv($handle, 1000, ",");

if ($data === false) {
echo "Unable to get anything from the file.";
}

if (is_array($data)) {
if ($data == $my_row) {
echo "The first row matched\n";
} else {
echo "The first row didnt match\n";
}
}

fclose($handle);


If you really do want to compare the first column, then the time to
do
it will be based on how big the csv file is. If you have a big file,
it's going to take a long time to go through each row and then look
at
the first field.

<?php

$handle = fopen('file.csv', 'r') or die("unable to open file");

$my_value = '1';

$row_count = 0;
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$row_count++;
if ($data[0] == $my_value) {
echo "Found my_value on row ", $row_count, "\n";
} else {
echo "Did not find my_value on row ", $row_count, "\n";
}
}

fclose($handle);

--
Postgresql & php tutorials
http://www.designmagick.com/



--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




--
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/from/lynch
Yeah, I get a buck. So?




--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
.

Relevant Pages

  • Re: [PHP] fgetcsv
    ... I'm trying to compare a value to the first field in a csv fILE (example ... So are you trying to compare the first column or the first row? ... "Some men are born to greatness, some achieve greatness, ...
    (php.general)
  • Re: How to set up a sub-total routine?
    ... off the cuff. ... > My first thought is to build a string consisting of all the text ... > values in the first row, drop a row and build a similar string, and ... > compare. ...
    (microsoft.public.excel.programming)
  • Re: Using mysql_result() Deletes Row From Result
    ... Here's my tables setup: ... Write header of table for displaying data, ... So it's like for some reason, reading the Category name from the first row causes the last row from the result to be deleted. ...
    (comp.lang.php)
  • Re: [PHP] fgetcsv
    ... I'm trying to compare a value to the first field in a csv fILE (example ... So are you trying to compare the first column or the first row? ... If you really do want to compare the first column, then the time to do it will be based on how big the csv file is. ... If you have a big file, it's going to take a long time to go through each row and then look at the first field. ...
    (php.general)
  • problem in my php code
    ... I have a problem in my php code. ... global $obj; ... global $ind; ... First Row: ...
    (Fedora)