Help with fgetcsv

RTAdams89

I have a CSV file as follows:


"player1",5'11,150,R,R,10,OF,17
"player2",5'6,119,R,R,10,2B,13

I am trying to create a PHP page which will look for a specified name in the first "column", and upon finding it, return the rest of the info in that line as separate variables. So, for example, if i specified the name as "player1", the script would store "5'11" as $height, "150" as $weight, etc. I tried playing around with fgetcsv, but I don't know enough PHP to get it working right. Any help would be greatly appreciated.

cmxflash

Here's an example how to split the data into an array:

<?php
$playerdata = file("your_file.csv");
foreach($playerdata as $void => $d) {
	$array[] = explode(",", $d);
}

print_r($array);

?>

The above would output the following array:

Array
(
[0] => Array
(
[0] => "player1"
[1] => 5'11
[2] => 150
[3] => R
[4] => R
[5] => 10
[6] => OF
[7] => 17
)
[1] => Array
(
[0] => "player2"
[1] => 5'6
[2] => 119
[3] => R
[4] => R
[5] => 10
[6] => 2B
[7] => 13
)
)

If you'd like to make a list of all player, you could use a foreach loop:

foreach($array as $number => $data) {
	echo $data[0]; // $data[0] is for the players name. You could change it to [1] instead if you'd like to output 5'11 instead.
}

If you just want to find one player, use the following code:

<?php
$playerdata = file("your_file.csv");
foreach($playerdata as $void => $d) {
	$array[] = explode(",", $d);
}

foreach($array as $number => $data) {
	if ($data[0] == "\"player1\"") {
		$info1 = $data[1];
		$info2 = $data[2];
		$info3 = $data[3];
		//etc...
	}
}

?>

RTAdams89

That is semi-working now. Is there a way I can use PHP to search the CSV file for a particular value (a player's name) and return which line that that value appears in?

RTAdams89

Is there a way I can use PHP to search the CSV file for a particular value (a player's name) and return which line that that value appears in?

aprelium

RTAdams89 wrote
Is there a way I can use PHP to search the CSV file for a particular value (a player's name) and return which line that that value appears in?

We don't think so. You'll have to read the file and fill a table with the information then lookup for the player name in that table.