Ignoring First 6 Lines

[cwb]

I am trying to create script that will import data into my database from a URL. It is working but I need it to ignore the first 6 lines. I am not sure how to do that so if anyone could help I would appreciate it...

Here is what I got so far.
(I am not that advanced in PHP so details would be helpful )

<?

$data=file("http://www.blah-blah-blah.com/file.txt");
foreach($data as $value)
 {
  $fields=explode("\t",$value);
  $num=count($fields);
  for ($n=0;$n<$num;$n++)
   {
    $null="";
    print ($n==0) ? "<b><font face=arial size=1>IMPORTING...></font></b><BR>" : $null;
   }

include("../config.php");
//set_time_limit(0); - not needed yet

// Insert into categories table here
mysql_query("INSERT into products2 (name,keywords) VALUES ('$fields[0]','$fields[1]')");

}

?>

Thank You

[Martin63]

Just try this:

$data=file(http://www.blah-blah-blah.com/file.txt); 
$skipped = 0;
foreach($data as $value) 
{ 
  $skipped++;
  if ($skipped > 6) 
    {
     $fields=explode("\t",$value); 
     $num=count($fields); 
     for ($n=0;$n<$num;$n++) 
     { 
        $null=""; 
        print ($n==0) ? "<b><font face=arial size=1>IMPORTING...></font></b><BR>" : $null; 
     } 
 
    include_once("../config.php"); 
    //set_time_limit(0); - not needed yet 
 
    // Insert into categories table here 
    mysql_query("INSERT into products2 (name,keywords) VALUES ('$fields [0]','$fields[1]')"); 
    }
} 

Hope it will solve your prob.

[GeorgeB.]

Instead of skipping the first few lines after you've grabbed the data, skip the lines while you're grabbing the data using start/stop points.

[Daijoubu]

\t is a tab, I think you're looking for \n (UNIX) or \r\n (DOS) or even \r (MAC)

[Young Twig]

 $data=file(http://www.blah-blah-blah.com/file.txt); 

Might just want to change that to:

 $data=file('http://www.blah-blah-blah.com/file.txt'); 

[Daijoubu]

Wait, hold a sec...
file() return an array and each element is a line of the file
I though you were splitting the file into lines by tabs, my bad!

So all you have to do is to trim the first 6 or do what GeorgeB. said, fopen, skip the first 6 fread? (from my previous experience, it reads line by line if the lenght is big enough)