Database/Text File Parse Help

cmccomas

I'm running a sports site for a NBA team and was curious about a fast/easy way to update stats from the previous game, which occur almost nightly.

I can get a box score that looks like this for my team after each game.

So, if I went and just copied and paste to to a .txt file like game1.txt, game2.txt. Could I have my database read that, split the fields up in the right places, and then compute stats for the entire season?

How hard would this be to do?

HalfaBee

If you mean the information below
it would be easy enoug to parse into a DB.

// Get data
$data = file( 'box.txt' );

// First remove all the spacing and leave 1 space.

$data = preg_replace( '/ +/',' ',$data );

// now go thru each row and do what ever with the data
foreach( $data as $line )
{
$linearray = explode ( ' ' , $line );
// test data and insert into DB
}

Hope this gets you started.
HalfaBee

box.txt

SAN ANTONIO (76)

                      fg    ft    rb             
               min   m-a   m-a   o-t   a  pf   tp

B Bowen 40 2-9 0-0 1-7 1 2 5
T Duncan 39 10-23 3-3 8-17 2 4 23
D Robinson 24 4-5 6-7 3-7 1 6 14
S Jackson 28 1-9 2-3 2-4 3 3 5
T Parker 31 1-12 1-2 0-4 3 3 3
M Rose 15 0-9 0-0 1-4 0 3 0
E Ginobili 28 3-10 2-3 1-2 1 1 10
S Claxton 17 3-6 4-4 1-3 2 1 10
K Willis 16 2-7 2-2 5-5 0 3 6
D Ferry 1 0-0 0-0 0-0 0 0 0
S Kerr 1 0-0 0-0 0-0 1 1 0
S Smith DNP - COACH'S DECISION

cmccomas

Thanks.

// now go thru each row and do what ever with the data
foreach( $data as $line )

What do I need to do here? The player name should match a player in my roster table. Thus I should be able to generate that players most up-to-date stats on his player.php?pid=1 page? So, I'd have to save the space where the name is as a text, and the rest as an integer to figure out formulas for points per game, etc.

HalfaBee

I know nothing about basketBall ( a nerd )
$linedata[0] has the initial
$linedata[1] has the name
....

If you do
echo "<pre>";
print_r( $linedata );

you will see what the array contains.

You will have to organise your table to correspond with the data and insert a row for every game.

data like 10-23 will probably have to be split up into two columns.
explode( '-','10-23' );

HalfaBee

cmccomas

$linedata[0] has the initial
$linedata[1] has the name

Got that, but how does it parse it? How does it know there's a space, do the next $linedata?

HalfaBee

The explode( ' ',$.....) explodes the string into an array of values that are seperated by a space.

so $linedata has all the values that seperated by spaces.

You can tell the invalid lines because count($linedata) will not be 9.

Halfabee

cmccomas

So, is this my first bit of code, or do I need to change it:

// Get data
$data = file( 'box.txt' );

// First remove all the spacing and leave 1 space.

$data = preg_replace( '/ +/',' ',$data );

// now go thru each row and do what ever with the data
foreach( $data as $line )
{
$linearray = explode ( ' ' , $line );
// test data and insert into DB
}

HalfaBee

That will be the start of the code.

put

echo "<PRE>";
print_r( $linedata );

inside the foreach loop and you will see what is being parsed.

HalfaBee

cmccomas

You will have to organise your table to correspond with the data and insert a row for every game.

I thought about naming each game game1.txt, game2.txt, game3.txt.

Say here is the box for game 1
You will have to organise your table to correspond with the data B Bowen 40 2-9 0-0 1-7 1 2 5
T Duncan 39 10-23 3-3 8-17 2 4 23
D Robinson 24 4-5 6-7 3-7 1 6 14
S Jackson 28 1-9 2-3 2-4 3 3 5
T Parker 31 1-12 1-2 0-4 3 3 3
M Rose 15 0-9 0-0 1-4 0 3 0
E Ginobili 28 3-10 2-3 1-2 1 1 10
S Claxton 17 3-6 4-4 1-3 2 1 10
K Willis 16 2-7 2-2 5-5 0 3 6
D Ferry 1 0-0 0-0 0-0 0 0 0
S Kerr 1 0-0 0-0 0-0 1 1 0
S Smith DNP - COACH'S DECISION

and for game 2
B BOWEN F 29 1-4 2-2 0 1 1 1 4 0 0 4
T DUNCAN F 46 10-18 9-10 3 14 17 4 3 1 6 29
D ROBINSON C 20 2-4 2-2 1 2 3 0 6 3 1 6
S JACKSON G 32 2-7 0-0 1 6 7 3 2 0 4 5
T PARKER G 33 5-13 3-5 0 2 2 4 3 1 2 14
E GINOBILI 26 4-8 4-4 0 3 3 0 5 2 1 12
M ROSE 29 6-9 2-2 2 1 3 1 2 0 1 14
S CLAXTON 15 1-4 1-2 0 1 1 2 4 2 0 3
K WILLIS 1 0-0 0-0 0 1 1 0 0 0 0 0
S KERR 9 2-2 1-2 1 0 1 0 0 1 0 6
S SMITH DNP - COACH'S DECISION

D FERRY DNP - COACH'S DECISION

What I need it to do is:
a) parse and post the most recent stats on each individuals page
b) parse and add up total most of the stat categories and find the average per game (total/gamesplayed)
c) sort by highest points per game, rebounds per game, steals per game, assists per game, and show up on the front page.

I can do the $queries and prints for each page, just not sure how to parse it, store it somewhere, and then add up totals, divided, etc.

Thanks

cmccomas

So, it can be done? Those 3 things?

HalfaBee

Why not create a table in mysql to store the each days game stats.

Create a SQL statement using the parsed data.

$sql = "INSERT into stats_table VALUES ( ";

$sql .= "'{$linedata[0]} {$linedata[1]}'; // name
for( $i=0;$i<count($linedata);$i++ )
{
$sql .= ",'{$linedata[$i]}'";
}
$sql .= ")";

mysql_query($sql);

Not knowing what the figures with dashes in mean may cause a few problems with the additions and may need to be seperated out into their own fields.
Also there is a different number of fields in game 1 and 2.

This should get you started.
HalfaBee

maxrisc

I have a similar problem like this and can't seem to get it to work. I have been banging my head on this for over a week and no one seems to know the answer.

I followed the example here but it didn't work. I got an empty delimiter error when trying to run the script on line 16.

Here is the data

I need to be able to index the first line
Drop the second line.
Single space everything into an array
Do an IF/ELSE to check for DNS and resort if DNS ==True (this part is done already)
Insert it into a mysql databse table.

Looks easy enough but I can't figure out the spacing part as everything has 1,2,3+ spaces and multiple blank lines.

(Severe Headache)

I tried a preformatted txt file that I made by hand using the code below so I know that this part works once everything is single spaced.

<?php 
// Open the file 

$i=0; 
$loc = fopen("test.txt","r"); 

while ($line = fgets($loc,4096)) { 

   $parts = preg_split("!\\s!",$line, -1, PREG_SPLIT_NO_EMPTY); 

   if ($parts[3]=="DNS")  {

	$parts[4] = $parts[5];
	$parts[5] = $parts[6];

  	echo "Position: " . $parts[0] . "<br />"; 
	echo "Car #: " . $parts[1] . "<br />"; 
	echo "Laps: " . $parts[2] . "<br />"; 
	echo "Time: " . $parts[3] . "<br />"; 
	echo "First Name: " . $parts[4] . "<br />"; 
	echo "Last Name: " . $parts[5] . "<br><br />";
   } else {
     	echo "Position: " . $parts[0] . "<br />"; 
  		echo "Car #: " . $parts[1] . "<br />"; 
  		echo "Laps: " . $parts[2] . "<br />"; 
  		echo "Time: " . $parts[3] . "<br />"; 
  		echo "First Name: " . $parts[4] . "<br />"; 
  		echo "Last Name: " . $parts[5] . "<br><br />"; 
   }
$i++;}
?>

Any help would be appreciated.
Thanks,
Dave

maxrisc

Well that was easy enough to fix. Out of frustration I changed a couple of things.

This stuff MUST have a space:

$linearray = explode(' ',$line);

and

echo "<PRE>";
print_r($linedata);

should have been:

echo "<PRE>";
print_r($line);

This is the final code I came up with to get the results to display:

<?php

   $data = file('mains.txt');  

   $parts = preg_split("!\\s!",$line, -1, PREG_SPLIT_NO_EMPTY); 
   $parts = preg_split("!\n!",$line, -1, PREG_SPLIT_NO_EMPTY);
   $data = preg_replace('/ +/',' ',$data);
   foreach ($data as $line)
   {
   $linearray = explode(' ',$line);

   echo "<PRE>";
   print_r($line);
   }

?>

You can see the example here.

My question is now. If I were to test $linearray[0] == "pos"
then how would I drop that line and move on to the next one without printing it?

HalfaBee

Put these lines in the loop.

if( $linearray[0] == "pos" )
continue;

HalfaBee