Codice PHP:
// query MySql
$select = "SELECT DISTINCT album, artist FROM song ORDER BY artist";
// Esegui la query
$data = mysql_db_query($sql['data'], $select) or die("uno Failed!");
//meta tags per i motori di ricerca
$uno="<html><head>";
$due="<title>RapTxt 3.0 - solo testi rap hip-hop italiani ::: $artista -- $album :::</title>";
$tre="<META name='robots' content='index,follow'>";
$quattro="<META NAME='DESCRIPTION' CONTENT='Solo testi rap hip-hop italiani. Il più vasto archivio on-line! Tutti i testi di $artista - $album'>";
$cinque="<META NAME='KEYWORDS' CONTENT='$artista, $album, hip, hop, rap, lyrics, testi, testo, italiano, italiani, italiane, caparezza, fish, retnek, club, dogo, gratis, free, articolo, freestyle, cor, veleno, sottotono, bassi, break, mp3, mc'>";
$sei="</head><body>";
$sette="</body></html>";
$fp2 = fopen("indice.htm", 'w');
fwrite($fp2, $output);
fclose($fp2);
while ($row = mysql_fetch_array($data))
{
// Get all the fields
$album = $row['album'];
$artista = $row['artist'];
$alb=addslashes($album);
$artistas=addslashes($artista);
$fp = fopen("$artista-$album.htm", 'w');
$selecta = "SELECT * FROM song WHERE album= '$alb' && artist = '$artistas'";
$data1 = mysql_db_query($sql['data'], $selecta) or die("due Failed!");
echo"[b]$artista-$album.htm
[/b]";
$output="$uno$due$tre$quattro$cinque$sei<center>[url='index.php']Vai al sito[/url]</center>
";
fwrite($fp, $output);
fclose($fp);
$fp2 = fopen("indice.htm", 'a');
$indice="[url='$artista-$album.htm']$artista-$album.htm[/url]
";
fwrite($fp2, $indice);
fclose($fp2);
while ($row1 = mysql_fetch_array($data1))
{
$uid = $row1['uid'];
$titolo = $row1['title'];
$fp = fopen("$artista-$album.htm", 'a');
$output2="[b]$artista[/b] - [url='testo.php?uid=$uid']$titolo[/url] testo dall'album [b]$album[/b]
";
echo"-->$titolo
";
fwrite($fp, $output2);
fclose($fp);
}
$fp = fopen("$artista-$album.htm", 'a');
$fp2 = fopen("indice.htm", 'a');
$output3="$sette";
fwrite($fp, $output3);
fwrite($fp2, $output3);
fclose($fp);
fclose($fp2);
echo"";
}
Permessi di invio
Rispondi quotando