fopen() and fgetcsv()

mantrid

I am using fopen() and fgetcsv() to open an excel file and extract data for
upload to mysql database. The doesnt seem to be a parameter in either of
these functions for ommitting the first row of the excel file. I am
currently using While ...... statement to read the rows and do things with
them. Can I ommit the first line without replacing my 'While....' loop with
a 'For......' loop?

Ian

Michael

mantrid wrote:
> I am using fopen() and fgetcsv() to open an excel file and extract data for
> upload to mysql database. The doesnt seem to be a parameter in either of
> these functions for ommitting the first row of the excel file. I am
> currently using While ...... statement to read the rows and do things with
> them. Can I ommit the first line without replacing my 'While....' loop with
> a 'For......' loop?
>
> Ian
>
>

Certainly, take your pick, both should work fine:

$i = 0;
while ($i++ && false !== $data = fgetcsv($fh, 1024)) {
if ($i == 1)
continue;
print_r($data);
}


$firstline = true;
while (false !== $data = fgetcsv($fh, 1024)) {
if ($firstline == true) {
$firstline = false;
continue;
}
print_r($data);
}


- Michael

Olaf Schinkel

mantrid schrieb:
> I am using fopen() and fgetcsv() to open an excel file and extract data for
> upload to mysql database. The doesnt seem to be a parameter in either of
> these functions for ommitting the first row of the excel file. I am
> currently using While ...... statement to read the rows and do things with
> them. Can I ommit the first line without replacing my 'While....' loop with
> a 'For......' loop?
>
> Ian
>
>
Remove the first line....
$fh = fopen(...

fgets($fh); <- only insert this line into your code

while(...


Olaf

C.

On 7 Dec, 13:05, Olaf Schinkel <> wrote:
> mantrid schrieb:> I am using fopen() and fgetcsv() to open an excel file and extract data for
> > upload to mysql database. The doesnt seem to be a parameter in either of
> > these functions for ommitting the first row of the excel file. I am
> > currently using While ...... statement to read the rows and do things with
> > them. Can I ommit the first line without replacing my 'While....' loop with
> > a 'For......' loop?
>
> > Ian
>
> Remove the first line....
> $fh = fopen(...
>
> fgets($fh); <- only insert this line into your code
>
> while(...
>
> Olaf

I suspect if I suggested that validating the record with a regex
instead of using positional information might be more appropriate I'd
just confuse people. So I won't.

C.

mantrid

thank you everyone

"mantrid" <> wrote in message
news:YYY5j.2742$.net...
> I am using fopen() and fgetcsv() to open an excel file and extract data
for
> upload to mysql database. The doesnt seem to be a parameter in either of
> these functions for ommitting the first row of the excel file. I am
> currently using While ...... statement to read the rows and do things
with
> them. Can I ommit the first line without replacing my 'While....' loop
with
> a 'For......' loop?
>
> Ian
>
>