gave very good starting concept

Awesome, thank you very much, the tag cloud script is really cool.

Great job! This was really helpful! Keep on!

Great script - a couple of suggestions though:

* Most tag clouds are sorted alphabetically, you can do this by changing the shuffle() to a sort().
* This should probably be outputted as an ordered list ( with 's for the terms), then CSS used to make it look like a tagcloud.

Jason, I agree with your suggestions, however I wonder, how could you make an ordered list replicate a tag cloud? I'm sure its possible however i'm no wizz when it comes to css.

Gr8 work, keep it up

Dear

I m just jusing the code on my site and it works very fine, thx for it!

Got a problem, i want to put a 3th option in my arry, for example category. How can i put a third option in the array and how do i have to take out of the array?

So here i have to put the third option :
while ($row = mysql_fetch_array($query))
{
$term = $row['term'];
$counter = $row['counter'];
$terms[] = array($term => $counter);
}

And hiere i have to take out :
foreach ($terms as $k => $v)
{
foreach($v as $k2 => $v2)
{
$percent = floor(($v2 / $maximum) * 100);

if ($percent = 20 and $percent = 40 and $percent = 60 and $percent $k2 ";
}
}

So i can put him into the url (a href as a parameter)

Great thanks for the help / feedback.
Pieter

PS : sorry for my english but it s a little be difficult

Good thought, had the exact same thought myself

Hey thanks for the code. I used this idea to make something similar in Java.

Very nice tutorial. thanks

Hye men !

Thx very much. It id very useful. I've just changed it with a link in the database in order to keep traffic on my site.

See you soon

Jul'

this tag cloud seems to simple and is constrained by specific sizes that are defined in your css. why not develop a better algorithm that calculates a font percentage between ranges of 75%-250%.

chris thats a fair point i'm sure it would look better with more font size variation. Any suggestions for such an algorithm? Obviously it would revolve around refactoring the current percentage that is calculated in the loop. and embedding the style in the tag

Nice tut, I always wandered how this stuff worked. Not as hard as I thought it would be.

Was just researching tagging to incorporate in a new web site I am building. I never thought of utilising search statistics to affect the ranking of tags. Very nice, I will use it to supplement how I intend to do this myself.

@ Steve [re: css formatting ordered list]
just set the display type of the li's to 'inline' and they'll act like span's

@ Chirs [re: font percentage calculation]
its quite simple - you use the percentage to calculate where it should be placed within your font percentage boundaries then add the lower bound:

// tag font size ranges (in percent)
$minSize = 75;
$maxSize = 250;

$tagSize = (floor($v2 / $maximum) * ($maxSize - $minSize)) + $minSize

good script, i have try

Thanks a lot!

Thank you for this very helpful tutorial.

Thanks a lot Steve,
this is what I call the nice looking functional code,
I'll use it in my upcoming free cms (Aikicms),
if you allow me

thank you, this has been very useful

Great post, nice concise outline, well formatted code - good work.

Had just been asked by a client to include a cloud in their site, came across this method and had one up in less than an hour, including css formatting and rewriting some of the code for percentage based resizes and to pass along a third parameter (url).

There was a comment before asking how to add the url in, so i'll just paste the change I made:


while($row = mysql_fetch_array($articleRow))
{
$title = $articleRow["Title"];
$score = $articleRow["Score"];
$id = $articleRow["ArticleID"];
$titles[] = array( Title => $title, Score => $score, Id => $id );
}


This way you can remove the second foreach loop, and can call the desired attribute through $v["Title"], or however you name your variables.

That was a great post. Thank you, Steve.
I am a newbie to web development. I have a small doubt.
Can we somehow control the tag cloud. I mean, if I have a university search page, and someone wants to deface it, he/she could enter an obscene search term a 1000 times and it will always remain the largest tag in the cloud.

great article. an improvement I made was to use a database call to set the maximum field rather than hard coding it

$query = "SELECT max(counter) as maxcounter from searches order by date desc, counter desc;";
$result = $db1->Query($query);
$arr_result = $db1->FetchArray($result);
return $arr_result[0]['maxcounter'];

Thanks

Great tutorial for a beginner. Thank you very much Mr. Steve

Nice stuff you put together. However, I can't stop wondering if the term "tag" is appropriate, since none of your elements in the cloud are tags. They are search words, and thus the term "search cloud" is more appropriate. Anyways, I'm only being pedantic because I would have loved to had seen an implementation of actual tags.

If you execute the query:

SELECT term, counter FROM search ORDER BY counter DESC LIMIT 30

you can be sure that maximum counter is in the first row of your result, so just read it

Inspite of shuffle, I use this SQL

select * from
(select term, count(term) as cnt
from tbl_search_terms
group by term
order by cnt desc
limit 25
) subqTerms
order by term asc

Nice Post... I'm thinking of implementing such a tag cloud for various artists on my lyrics page. It would be interesting, if someone knew how to tell google or some other search engine bot the relevance of some certain tag. I know it's possible using sitemaps and the priority tag... does google parse the css?

regards
dominik

I have to add a tags searcher on one of my sites. I do not know ( now) how to make the sql. It is a nice article about usual cloud tags.