Extracting unique values ??

[jerryyang_la1@yahoo.com]

I'm reading in a CSV and displaying using the code below:

$users = file("text.txt" );
echo "<table border='1' width='75%' align='center'> ";
echo "<tr>";
echo "<td width='33%' align='center'> <b>Username</b></td>";
echo "<td width='33%' align='center'> <b>Domain Name</b></td>";
echo "<td width='34%' align='center'> <b>Date & Time</b></td>";
echo "</tr>";
foreach ($users as $user) {
list($name, $domain, $date) = explode(",", $user);
echo "<tr>";
$result = count($users);
if ($domain == " test.com"){
echo "<td width='33%' align='center'> $font2$name</td>";
echo "<td width='33%' align='center'> $font2$domain</td>";
echo "<td width='34%' align='center'> $font2$date</td>";
} else {
echo "<td width='33%' align='center'> $font$name</td>";
echo "<td width='33%' align='center'> $font$domain</td>";
echo "<td width='34%' align='center'> $font$date</td>";
}
echo "</tr>";
}

This works fine, except I would like to return the unique value for
$name, can some one help ?

The CSV is:

username, domain, date
user1, test.com, 01/02/2007


Thanks

[Tyno Gendo]

Re: Extracting unique values ??

jerryyang_la1@y ahoo.com wrote:

I'm reading in a CSV and displaying using the code below:
>
$users = file("text.txt" );
echo "<table border='1' width='75%' align='center'> ";
echo "<tr>";
echo "<td width='33%' align='center'> <b>Username</b></td>";
echo "<td width='33%' align='center'> <b>Domain Name</b></td>";
echo "<td width='34%' align='center'> <b>Date & Time</b></td>";
echo "</tr>";
foreach ($users as $user) {
list($name, $domain, $date) = explode(",", $user);
echo "<tr>";
$result = count($users);
if ($domain == " test.com"){
echo "<td width='33%' align='center'> $font2$name</td>";
echo "<td width='33%' align='center'> $font2$domain</td>";
echo "<td width='34%' align='center'> $font2$date</td>";
} else {
echo "<td width='33%' align='center'> $font$name</td>";
echo "<td width='33%' align='center'> $font$domain</td>";
echo "<td width='34%' align='center'> $font$date</td>";
}
echo "</tr>";
}
>
This works fine, except I would like to return the unique value for
$name, can some one help ?
>
The CSV is:
>
username, domain, date
user1, test.com, 01/02/2007
>
>
Thanks
>

How big is this CSV going to get? If its going to get big you'd be
better with a database as you're reading the entire file into memory.

Anyhow, not quite sure if I'm on the right lines for what you want, but
I think you want to group the data for a user together even though the
entries may be in a random order in the file?

I'm pretty new to PHP myself so don't have a grasp of all the functions,
so here is a version of what I think you want to do, but there may be a
much better way ;-)

<?php
$users = file("text.txt" );
echo "<table style='border: 1px solid #000;' width='75%'
align='center'> ";
echo "<tr>";
echo "<td width='50%' align='center'> <b>Domain Name</b></td>";
echo "<td width='50%' align='center'> <b>Date & Time</b></td>";
echo "</tr>";

// initial CSV parse into usable array
$user_array = array();
foreach ($users as $user) {
list($name, $domain, $date) = explode(",", $user);
if(!isset($user _array[$name]["accesses"])){
$user_array[$name]["accesses"]=array();
}
array_push($use r_array[$name]["accesses"],
array("domain"= >$domain, "date"=>$date)) ;
}

// output array details
foreach ($user_array as $username=>$det ails) {
echo "<tr>";
echo "<td colspan='2' align='left' style='font-weight: bold;
background-color: #fafafa'>$usern ame</td>";
echo "</tr>";
foreach($detail s["accesses"] as $accesses) {
echo "<tr>";
echo "<td width='50%'
align='center'> {$accesses["domain"]}</td>";
echo "<td width='50%' align='center'> {$accesses["date"]}</td>";
echo "</tr>";
}
}

unset($user_arr ay);
?>