[RESOLVED] Need code for counting specific names in flatfile

bx2008bx

I run a soccer website, and for each game I have recorded the line ups with names of all players appearing seperated with the pipe ( | ) symbol. One line for each match.

I would love a code where I can identify how many games each individual players have got.

I already have a code that display all names qith their number og games on a single page, but I would like to have a code that only display one player, after I have specified who in the code, to go with their individual records page.

Anyone up for the challenge?
Thank you!

bradgrafelman

Why store the data in a featureless flatfile format when you could use a SQL database instead?

bx2008bx

Several reasons. First of all, I never had access to a mysql database when I started using the system. Secondly. I find it conveniant to have a copy of the txt file on my own PC, when and if the soccer club decide to move to another host. And third, I know little about such databases.

bradgrafelman

bx2008bx wrote:
I never had access to a mysql database when I started using the system

Ah well that's no excuse - even free web hosts nowadays offer some limited SQL capabilities.

bx2008bx wrote:
find it conveniant to have a copy of the txt file on my own PC, when and if the soccer club decide to move to another host.

So just export the SQL database(s) out to a .sql file that you backup elsewhere. Heck, on a halfway decent host you could even automate all of that.

bx2008bx wrote:
I know little about such databases.

Sounds like you're facing a great opportunity to learn! 🙂

bx2008bx

Found a solution after a couple of weeks try:

<?php
$filename = "games.txt";
$player = "player one";
$games = file_get_contents( $filename );
if( $games !== FALSE )
{$players_games = substr_count( $games, $player );
echo( " " . $players_games );}
?>

bradgrafelman

So what happens if you have players "Dan", "Danny", and "Daniel" and you search for "Dan" ?