support endonesiahost

ini update-an data yang terbaru, dan sudah bisa seperti tagsclouds

<?
/*
// mulai copy
–
– Struktur dari tabel `berita`
–

CREATE TABLE `berita` (
`id` int(3) NOT NULL auto_increment,
`text` text collate latin1_general_ci NOT NULL,
`tags` varchar(255) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=19 ;

–
– Dumping data untuk tabel `berita`
–

INSERT INTO `berita` VALUES (1, ‘lorem ipsum’, ‘internet,iklan’);
INSERT INTO `berita` VALUES (2, ‘lorem ipsum’, ‘internet,iklan,shop’);
INSERT INTO `berita` VALUES (3, ‘lorem ipsum’, ‘internet,pulsa’);
INSERT INTO `berita` VALUES (4, ‘lorem ipsum’, ‘internet,pulsa,online’);
INSERT INTO `berita` VALUES (5, ‘lorem ipsum’, ‘pulsa,internet,jasa’);
INSERT INTO `berita` VALUES (6, ‘lorem ipsum’, ‘warung internet’);
INSERT INTO `berita` VALUES (7, ‘lorem ipsum’, ‘jaga,internet,halo’);
INSERT INTO `berita` VALUES (8, ‘maulana mandiri, aaguncms’, ‘maulana mandiri, aaguncms’);
INSERT INTO `berita` VALUES (9, ‘maulana mandiri, aaguncms’, ‘maulana mandiri, aaguncms’);
INSERT INTO `berita` VALUES (10, ‘maulana mandiri, aaguncms’, ‘maulana mandiri, aaguncms’);
INSERT INTO `berita` VALUES (11, ‘maulana mandiri, aaguncms’, ‘maulana mandiri, aaguncms’);
INSERT INTO `berita` VALUES (12, ‘maulana mandiri, aaguncms’, ‘maulana mandiri, aaguncms’);
INSERT INTO `berita` VALUES (13, ‘maulana mandiri, aaguncms’, ‘Igun Kasep, Igun Bageur, Igun Ganteng’);
INSERT INTO `berita` VALUES (14, ‘Igun Kasep, Igun Bageur, Igun Ganteng’, ‘Igun Kasep, Igun Bageur, Igun Ganteng’);
INSERT INTO `berita` VALUES (15, ‘Igun Kasep, Igun Bageur, Igun Ganteng’, ‘Igun Kasep, Igun,Bageur, Igun,Ganteng’);
INSERT INTO `berita` VALUES (16, ‘Igun Kasep, Igun Bageur, Igun Ganteng’, ‘Igun Kasep, Igun Bageur, Igun Ganteng’);
INSERT INTO `berita` VALUES (17, ‘Igun Kasep, Igun Bageur, Igun Ganteng’, ‘Igun Kasep, Igun Bageur, Igun Ganteng’);
INSERT INTO `berita` VALUES (18, ‘Igun Kasep, Igun Bageur, Igun Ganteng’, ‘Igun Kasep, Igun Bageur, Igun, Ganteng’);

//akhiri copy
*/
//connect ke database
$host = ‘localhost’;
$username = ‘root’;
$password = ”;
$db = ‘tags’;
$connect = mysql_connect($host,$username,$password) or die(”Gagal konek”);
$pilih_db = mysql_select_db($db) or die(”Database tidak ada”);

//fungsi agar tidak ada array yang sama
function array_unique_compact($a){
$tmparr = array_unique($a);
$i=0;
foreach ($tmparr as $v) {
$newarr[$i] = $v;
$i++;
}
return $newarr;
}

//query tags
$types = array();
$rs = mysql_query(”select tags from berita”);
$row = mysql_num_rows($rs);
if($row>0)
{
while($ftypes = mysql_fetch_array($rs))
{
//ambil tags dari text yang mempunyai tanda koma
$types = array_merge($types, explode(”,”, trim($ftypes[0]) ));
}

$typecount = array_count_values($types);

//BOF hapus jika nilai kosong dan kurang dari 2 karakter
foreach($types as $key => $value)
{
if($value == “” || strlen($value) < 3)
{
unset($types[$key]);
}
}
//EOF hapus

$types = array_unique_compact($types);

$max = max($typecount);
$min = min($typecount);

$x = 18; // 18px
$y = 11; // 11px

$stepvalue = ($max - $min) / ($x - $y);

for($i=0;$i<count($types);$i++)
{
echo ‘<a href=”search.php?tags=’.$types[$i].’”
style=”font-size:’. ( $y + round( ($typecount[$types[$i]]-$min) / $stepvalue ) ).’px;”>’. $types[$i].’</a>’;
if($i<count($types)-1) echo “,\n”;
}
}
?>

• Bookmark aja bro