Trying to parse a text file to input into mysql

[Luvac_Zantor]

but the text file isn't in any special format. It has several different areas, that I want to parse seperately for different databases....

Below is a little clip of the text file showing the different spacings.

PASSING                        CMP  ATT  YDS  PCT   YPA SACK   TD  INT LONG RATING
Wally Davis                     22   43  254   51   5.9    9    2    2   25   65.4

RUSHING                        ATT  YDS   AVG LONG   TD  FUM
Darnell Cobb                    25   68   2.7   12    0    1
Tyrone Banks                     1    8   8.0    8    0    0

Below is the current code I've started with, but have run into a wall.

<?php

$host = "localhost";
$username = "******";
$password = "******";
$database = "******";
$server = mysql_connect($host, $username, $password) or die(mysql_error());
$connection = mysql_select_db($database, $server);

$open = fopen("gamelog.txt","r");
$x=0;
$contents = fgets($open);
while($contents = fgets($open))
{
$x++;
$line_array[$x] = $contents;
$stats = explode(" ",$line_array[$x]);
// print $stats[0] . " " . $stats[1] . "<br>";

if ($stats[0] == "PASSING")
	{
    print $x . "<br>";
    $x++;
    print $x . "<br>";
    print "Here is the Array for Passing<br>" . $line_array[$x] . "<br>";
    $stats = explode(" ",$line_array[$x]);
    print "Name?<br>" . $stats[0] . "<br>";
    }

}


?>

I've spent over 12 hours with different things, and am completely lost now on what to do..... Obviously there isn't code for inputting into the database, because I can't even get it to ECHO the lines I want..... suggestions would be great, thanks!

[Luvac_Zantor]

More failure tying something different....

$file="gamelog.txt";
$open = fopen($file,"r");
$lines=file($file);

while($x<count($lines))
{
$data = explode("\n",$lines[$x]);

echo "Entries" . $data[0] . " " . $data[1] . "<br>";


}

All this does is repeat Entries for quite sometime, til I have to stop the webpage......

I guess try something else now....

[Luvac_Zantor]

by the way, the text file I need to parse will be dynamic each time, meaning it's not every "specific line" (ie. line 40 will always be the quarterback), so I have to be able to pick out based on the "header" or line above the actual stats. (ie. PASSING ..etc.. is above the quarterbacks)

btw, there are two sets, so further down this file is ANOTHER set of passing,, rushing,, ,receiving,, etc...

[Luvac_Zantor]

ok this is REALLY wierd..

the code below will output numbers which makes sense....

$file="gamelog.txt";
$lines=file($file);
echo "HEY i'm changed 4";

while($x<count($lines))
{
$data = explode("\n",$lines[$x]);

// echo "Entries" . $data[0] . " " . $data[1] . "<br>";

echo " " .$x . "  :   ";
$x++;

}

but, if I add the line echo " " . $lines[$x] . "<br>; it now displays ABSOLUTELY nothing..

$file="gamelog.txt";
$lines=file($file);
echo "HEY i'm changed 4";

while($x<count($lines))
{
$data = explode("\n",$lines[$x]);

// echo "Entries" . $data[0] . " " . $data[1] . "<br>";

echo " " .$x . "  :   ";
echo " " . $lines[$x] . "<br>;
$x++;

}

[Luvac_Zantor]

I'm a moron,, i forgot a " in the last bit....

ok so it displays everything nicely..... proves that it's capturing each line into an array.

but now,, the if statement that will tell my "code" to record specific data.....