Need to get a unique record from an array

Question

salibaray 5 Newbie Poster

14 Years Ago

Hi there,

I'am developing a snippet for a website widget that will read/fetch data from an XML file, sort it in array's and then show it back to the user - formated as a sentence.

Example:

XML sample:

<row id="1">
<username>GGR1024</username>
<name>Raymond</name>
<surname>Saliba</surname>
<game>Lotto</game>
<won>5000</won>
</row>
<row id="2">
<username>GGR1111</username>
<name>Isabelle</name>
<surname>Bonnici</surname>
<game>Lotto</game>
<won>1000</won>
</row>
<row id="3">
<username>GGR1024</username>
<name>Raymond</name>
<surname>Saliba</surname>
<game>Lotto</game>
<won>2000</won>
</row>
<row id="4">
<username>GGR1024</username>
<name>Raymond</name>
<surname>Saliba</surname>
<game>Lotto</game>
<won>200</won>
</row>

So... I read that XML file line by line and put the values in an array, do some functions and then show the formatted data back to the user:

Formatted data example:

Raymond Saliba won $5000 from Lotto
Isabelle Bonnici won $1000 from Lotto
Raymond Saliba won $2000 from Lotto
Raymond Saliba won $200 from Lotto

(notice that 'Raymond Saliba' appears 3 times in this example)

now the problem is this -> I need to only show 'Raymond Saliba' once to the user (each person is unique by his username) and the string that I show to the user must be the one that contains the highest ammount won.

Proper output Example:

Raymond Saliba won $5000 from Lotto
Isabelle Bonnici won $1000 from Lotto

So the blueprint behind my explenation is something like this:

Person 1 ------> $5000
                 $2000
                 $200
Person 2 ------> $1000

(each person can have alot of values, and I need to show that user with the highest value - ONCE)

Sounds easy right ? -> not for me... I'am not a professional developer with PHP but I tend to get along just fine, I have tried various methods for this snippet but so far I didn't find any luck :(
I tried multidimensional arrays, array_unique, and some sorting functions but all ended with no luck at all...

Can someone that understands what I need give me some advice/help please ? preferably with example code using the sample data that I gave to you in this post (because it makes me understand it better, sometimes I'm a slow learner sorry)

Thank you very much and I'm awaiting your reply :)
Raymond Saliba

multidimensional php puzzle sorting

4 Contributors
12 Replies
177 Views
2 Days Discussion Span
Latest Post 14 Years Ago Latest Post by salibaray

All 12 Replies

hemgoyal_1990 5 Junior Poster

14 Years Ago

first of my suggestion to you that why not u chose mysql to storing your data because in mysql there are too easy to find only one record of same name in higher value.
i suggest you that first you choose the mysql for your data storing.

hemgoyal_1990 5 Junior Poster

14 Years Ago

but you may also export these data in XML structure from phpmyadmin.
and also inserting and deleting of data in phpmyadmin is too easy and more secure. and also phpmyadmin is already provided with CPanel.

somedude3488 228 Nearly a Posting Virtuoso

14 Years Ago

This is a crude way to do it. The data isn't formatted properly so you will run into problems when people have the same name.

<?php

$xml =<<<XML
<data>
<row id="1">
<username>GGR1024</username>
<name>Raymond</name>
<surname>Saliba</surname>
<game>Lotto</game>
<won>5000</won>
</row>
<row id="2">
<username>GGR1111</username>
<name>Isabelle</name>
<surname>Bonnici</surname>
<game>Lotto</game>
<won>1000</won>
</row>
<row id="3">
<username>GGR1024</username>
<name>Raymond</name>
<surname>Saliba</surname>
<game>Lotto</game>
<won>2000</won>
</row>
<row id="4">
<username>GGR1024</username>
<name>Raymond</name>
<surname>Saliba</surname>
<game>Lotto</game>
<won>200</won>
</row>
</data>
XML;

$xml = simplexml_load_string( $xml );

$data = array();
foreach( $xml->row as $row ) {
	$name = "{$row->name} {$row->surname}";
	if ( !isset( $data[$name] ) ) {
		$data[$name] = array(
			'username' => $row->username,
			'name' => $row->name,
			'surname' => $row->surname,
			'game' => $row->game,
			'won' => $row->won
		);
	}
	elseif ( $row->won > $data[$name]['won'] ) {
		$data[$name]['won'] = $row->won;
	}
}

foreach( $data as $name => $row ) {
	echo "{$name} won \${$row['won']} from {$row['game']}<br />";
}

?>

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

salibaray 5 Newbie Poster · Answer 1 · 2010-01-18T16:00:36+00:00

first of my suggestion to you that why not u chose mysql to storing your data because in mysql there are too easy to find only one record of same name in higher value.
i suggest you that first you choose the mysql for your data storing.

Hi Hemgoyal,

Unfortunatley I cannot use mySQL because the client has specificly told me that he needs to feed it data through XML, this will be fed twice per week approx, and he doesn't want to complicate things with a database....

(just saying what he told me..... I would prefer easier method and if mySQL was the solution and I could make use of it then I definatley would) ;)

Thanks for your suggestion ;)

salibaray 5 Newbie Poster · Answer 2 · 2010-01-18T16:14:22+00:00

but you may also export these data in XML structure from phpmyadmin.
and also inserting and deleting of data in phpmyadmin is too easy and more secure. and also phpmyadmin is already provided with CPanel.

Hi Hemgoyal

This isn't a one off job, data input would have to be done on a regular basis if I derive to this method, the client needs to just upload an xml file to the system and then the system does all the work for him (cause he doesn't have time to input data to the db or anything, he just wants to upload in the morning and get results.... :( )

and wouldn't the whole process be a bit slower than if we used arrays ? (cause of connection, sorting etc) because the client wants speed as a priority so that his homepage loads fast on mobile phones too.... (its abit complicated this site lol)

Thanks Hemgoyal :)

salibaray 5 Newbie Poster · Answer 3 · 2010-01-18T17:54:16+00:00

This is a crude way to do it. The data isn't formatted properly so you will run into problems when people have the same name.

<?php

$xml =<<<XML
<data>
<row id="1">
<username>GGR1024</username>
<name>Raymond</name>
<surname>Saliba</surname>
<game>Lotto</game>
<won>5000</won>
</row>
<row id="2">
<username>GGR1111</username>
<name>Isabelle</name>
<surname>Bonnici</surname>
<game>Lotto</game>
<won>1000</won>
</row>
<row id="3">
<username>GGR1024</username>
<name>Raymond</name>
<surname>Saliba</surname>
<game>Lotto</game>
<won>2000</won>
</row>
<row id="4">
<username>GGR1024</username>
<name>Raymond</name>
<surname>Saliba</surname>
<game>Lotto</game>
<won>200</won>
</row>
</data>
XML;

$xml = simplexml_load_string( $xml );

$data = array();
foreach( $xml->row as $row ) {
	$name = "{$row->name} {$row->surname}";
	if ( !isset( $data[$name] ) ) {
		$data[$name] = array(
			'username' => $row->username,
			'name' => $row->name,
			'surname' => $row->surname,
			'game' => $row->game,
			'won' => $row->won
		);
	}
	elseif ( $row->won > $data[$name]['won'] ) {
		$data[$name]['won'] = $row->won;
	}
}

foreach( $data as $name => $row ) {
	echo "{$name} won \${$row['won']} from {$row['game']}<br />";
}

?>

----------------------------------------

Hi Kkeith29

Would there be a way to make this work with the username instead of Name and Surname ? cause username is the unique ID.

Thanks

somedude3488 228 Nearly a Posting Virtuoso · Answer 4 · 2010-01-18T17:56:47+00:00

Yeah. I didn't even think of that for some weird reason.

diafol · Answer 5 · 2010-01-18T19:40:51+00:00

How about using xsl to sort and filter your xml data? After all, that's what it's for.

Couple of ideas:

http://msdn.microsoft.com/en-us/library/ms950734.aspx

salibaray 5 Newbie Poster · Answer 6 · 2010-01-19T16:14:39+00:00

salibaray 5 Newbie Poster

14 Years Ago

lol funny how things happen sometimes Keith :)

Edited 14 Years Ago by salibaray because: n/a

salibaray 5 Newbie Poster · Answer 7 · 2010-01-19T16:16:37+00:00

Hi ardav

Hmm never hear of xsl before but sounds interesting, I'll check it out thanks :)

this just came ot my head: but is xsl for Microsoft based technologies only ? (cause th elink you pointed out is at MSDN so I think its for ASP and ASP.NET no )

thanks :)

diafol · Answer 8 · 2010-01-19T17:56:46+00:00

No xsl is independent of server side language - or should be.

salibaray 5 Newbie Poster · Answer 9 · 2010-01-20T14:24:23+00:00

salibaray 5 Newbie Poster

14 Years Ago

ok thanks ardav I'will learn more about it ;)

Need to get a unique record from an array

Recommended Answers Collapse Answers

All 12 Replies

Recommended Answers