php：使用google csv，删除列中填充的重复值

Question

I am a newbie to php and have been searching tirelessly for a solution to this problem (i'll bet its a super simple solve too *sigh).

I am importing a .csv feed from a google doc. It is pulling in 2 columns, one for "name" and the other "location". I would like to remove duplicate "locations". since i am using fgetcsv, my understanding is that it is already sorting the data into an array. Ideally, it would omit the "location" duplicates so that the "names" look as though they are listed under the "location" they correspond to.

Here is what i have:

    $url = "https://docs.google.com/spreadsheet/pub?key=0AsMT_AMlRR9TdE44QmlGd1FwTmhRRkFHMzFTeTZhS3c&output=csv";
    $handle = fopen($url, "r");
    while (($data = fgetcsv($handle, 5000, ",")) !== FALSE) {
    echo "<li>
";
    echo $data[1];
    echo "<br/>
";
    echo $data[2];
    echo "</li>
";
    }
    fclose($handle);

ideally i would be able to use something like this:

    $url = "https://docs.google.com/spreadsheet/pub?key=0AsMT_AMlRR9TdE44QmlGd1FwTmhRRkFHMzFTeTZhS3c&output=csv";
    $handle = fopen($url, "r");
    while (($data = fgetcsv($handle, 5000, ",")) !== FALSE) {
    echo "<li>
";
    echo array_unique($data[1]);
    echo "<br/>
";
    echo $data[2];
    echo "</li>
";
    }
    fclose($handle);

Many thanks in advance for any help! :o)

Answer 1

This may work, assuming that the items in the array are grouped by location. It stores the last data item (location) and compares whether each item has that location. If it does, it prints it, otherwise it creates a new list item with the new location, and then prints the name underneath (I haven't tested it though):

$url = "the-url-to-my-csv-feed";
$handle = fopen($url, "r");
$lastdata = '';
while (($data = fgetcsv($handle, 5000, ",")) !== FALSE) {
    if ($lastdata == '') {
        echo "<li><strong>" . $data[1] . "</strong>
";
        echo "<br/>
";
        $lastdata = $data[1];
    }

    if ($lastdata != $data[1]) {
        echo "</li>
";
        echo "<li><strong>" . $data[1] . "</strong>
";
        echo "<br/>
";
        $lastdata == $data[1];
    }
    echo $data[2] . "<br/>
";
}
fclose($handle);