OR

see the current tag cloud here

///////////////////////////////////////////////////////////////////////////////////////////////////////
/**
* this function will update the mysql database table to reflect the new count of the keyword
* i.e. the sum of current count in the mysql database & current count in the input.
*/
function update_database_entry($connection,$table,$keyword,$weight){

 $string=$_POST['tag_input'];
 $connection = mysql_connect("localhost", "root", "");
 /**
 * now comes the main part of generating the tag cloud
 * we would use a css styling for deciding the size of the tag according to its weight,
 * both of which would be fetched from mysql database.
 */

 $query="select * from `tagcloud_db`.`tags` where keyword like '%$keyword%'";
 $resultset=mysql_query($query,$connection);

 if(!$resultset){
  die('Invalid query: ' . mysql_error());
 } else {
  while($row=mysql_fetch_array($resultset)){
  $query="UPDATE `tagcloud_db`.`tags` SET weight=".($row[2]+$weight)." where tag_id=".$row[0].";";
  mysql_query($query,$connection);
 }
}
}
?>
/*
* get the input string from the post and then tokenize it to get each word, save the words in an array
* in case the word is repeated add '1' to the existing words counter
*/
 $count=0;
 $tok = strtok($string, " t,;.'"!&-`nr");//considering line-return,line-feed,white space,comma,ampersand,tab,etc... as word separator
 if(strlen($tok)>0) $tok=strtolower($tok);
 $words=array();
 $words[$tok]=1;
 while ($tok !== false) {
  echo "Word=$tok
";
  $tok = strtok(" t,;.'"!&-`nr");
  if(strlen($tok)>0) {
  $tok=strtolower($tok);
  if($words[$tok]>=1){
   $words[$tok]=$words[$tok] + 1;
  } else {
   $words[$tok]=1;
  }
 }
}
print_r($words);
echo '

';
/**
* now enter the above array of word and corresponding count values into the database table
* in case the keyword already exist in the table then update the database table using the function 'update_database_entry(...)'
*/
$table="tagcloud_db";
mysql_select_db($table,$connection);
foreach($words as $keyword=>$weight){
 $query="INSERT INTO `tagcloud_db`.`tags` (keyword,weight,link) values ('".$keyword."',".$weight.",'NA')";
 if(!mysql_query($query,$connection)){
  if(mysql_errno($connection)==1062){
   update_database_entry($connection,$table,$keyword,$weight);
  }
 }
}
mysql_close($connection);
?>

HTML, BODY
{
padding: 0;
border: 0px none;
font-family: Verdana;
font-weight: none;
}
.tags_div
{
padding: 3px;
border: 1px solid #A8A8C3;
background-color: white;
width: 500px;
-moz-border-radius: 5px;
}
H1
{
font-size: 16px;
font-weight: none;
}
A:link
{
color: #676F9D;
text-decoration: none;
}
A:hover
{
text-decoration: none;
background-color: #4F5AA1;
color: white;
}

 $connection = mysql_connect("localhost", "root", "");
 $table="tagcloud_db";
 $words=array();
 $words_link=array();
 mysql_select_db($table,$connection);
 $query="SELECT keyword,weight,link FROM `tagcloud_db`.`tags`;";

 if($resultset=mysql_query($query,$connection)){
  while($row=mysql_fetch_row($resultset)){
   $words[$row[0]]=$row[1];
   $words_link[$row[0]]=$row[2];
  }
 }
// Incresing this number will make the words bigger; Decreasing will do reverse
$factor = 0.5;

// Smallest font size possible
$starting_font_size = 12;

// Tag Separator
$tag_separator = '     ';
$max_count = array_sum($words);

?>