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
