<html><head><title>5 - Mostrare informazioni relative a un album</title><?php //Connessione al DB include "connect.php";$album = $_POST['lista'];?></head><body bgcolor="#EE82FA"><body><h1>5 - Mostrare informazioni relative a un album</h1><td align="center" width="50%"><a href="biblio.php"><h3>home</h3></a></td><h4>Elenco degli Album disponibili:</h4><form name="lstAlbum" action="query5.php" method="post"><select name="lista"><?php //Crea la query $titoloalbum = "select * from Album order by TitoloAlbum;"; $result = mysql_query($titoloalbum, $conn); while($field = mysql_fetch_array($result)) {?> <option><?php echo $field['TitoloAlbum'] ;?></option><?php } ;?></select><input name="invia" type="submit" value="Invia"></form><br /><?php $prequery = "select ArtistaA.IDAlbum from ArtistaA, Album where Album.TitoloAlbum = '$album' and ArtistaA.IDAlbum = Album.IDAlbum"; $resprequery = mysql_query($prequery, $conn); var_dump($resprequery); if (mysql_num_rows($resprequery == 0)) { $query = "SELECT Album.TitoloAlbum, Musicista.Nome, Musicista.Cognome, Musicista.Alias, Album.Etichetta, Album.AnnoAlbum, Album.DurataTot, Album.Formato from Album, Musicista, SolistaA WHERE Album.TitoloAlbum = '$album' AND Album.IDAlbum = SolistaA.IDAlbum AND SolistaA.IDMusicista = Musicista.IDMusicista;"; $resquery = mysql_query($query, $conn) or die ($query . '<br />' . mysql_error()); print "<table border = 1>\n"; //get field names print "<tr>\n"; while ($campo = mysql_fetch_field($resquery)) { print " <th>$campo->name</th>\n"; } // end while print "</tr>\n\n"; //get row data as an associative array while ($row = mysql_fetch_assoc($resquery)) { print "<tr>\n"; //look at each field foreach ($row as $col=>$val){ print " <td>$val</td>\n"; } // end foreach print "</tr>\n\n"; }// end while print "</table>\n"; ?><br /><? $query2 = "SELECT distinct Musicista.Nome, Musicista.Cognome, Musicista.Alias, Brano.Titolo, Brano.Durata, Genere.NomeGenere, Brano.Anno FROM `Brano`, Tracklist, Album, Musicista, SolistaA, Genere, GenereA WHERE Album.TitoloAlbum = '$album' AND Album.IDAlbum = Tracklist.IDAlbum AND Tracklist.IDBrano = Brano.IDBrano AND Musicista.IDMusicista = SolistaA.IDMusicista AND SolistaA.IDAlbum = Album.IDAlbum AND Brano.IDGenere = Genere.IDGenere AND Genere.IDGenere = GenereA.IDGenere AND GenereA.IDAlbum = Album.IDAlbum;"; $resquery2 = mysql_query($query2, $conn) or die ($query2 . '<br />' . mysql_error()); print "<table border = 1>\n"; //get field names print "<tr>\n"; while ($campo = mysql_fetch_field($resquery2)) { print " <th>$campo->name</th>\n"; } // end while print "</tr>\n\n"; //get row data as an associative array while ($row = mysql_fetch_assoc($resquery2)) { print "<tr>\n"; //look at each field foreach ($row as $col=>$val){ print " <td>$val</td>\n"; } // end foreach print "</tr>\n\n"; }// end while print "</table>\n"; ?><br /><? $query3 = "SELECT distinct Nome, Cognome, Alias, NomeRuolo FROM `Musicista`, Album, RuoloMB, Ruolo, Tracklist, Brano WHERE Album.TitoloAlbum = '$album' AND Tracklist.IDAlbum = Album.IDAlbum AND Tracklist.IDBrano = Brano.IDBrano AND RuoloMB.IDBrano = Brano.IDBrano AND RuoloMB.IDMusicista = Musicista.IDMusicista AND RuoloMB.IDRuolo = Ruolo.IDRuolo;"; $resquery3 = mysql_query($query3, $conn) or die ($query3 . '<br />' . mysql_error()); print "<table border = 1>\n"; //get field names print "<tr>\n"; while ($campo = mysql_fetch_field($resquery3)) { print " <th>$campo->name</th>\n"; } // end while print "</tr>\n\n"; //get row data as an associative array while ($row = mysql_fetch_assoc($resquery3)) { print "<tr>\n"; //look at each field foreach ($row as $col=>$val){ print " <td>$val</td>\n"; } // end foreach print "</tr>\n\n"; }// end while print "</table>\n"; } else { $query = "SELECT Album.TitoloAlbum, Gruppo.NomeGruppo, Album.Etichetta, Album.AnnoAlbum, Album.DurataTot, Album.Formato from Album, Gruppo, ArtistaA WHERE Album.TitoloAlbum = '$album' AND Album.IDAlbum = ArtistaA.IDAlbum AND ArtistaA.IDGruppo = Gruppo.IDGruppo;"; $resquery = mysql_query($query, $conn) or die ($query . '<br />' . mysql_error()); print "<table border = 1>\n"; //get field names print "<tr>\n"; while ($campo = mysql_fetch_field($resquery)) { print " <th>$campo->name</th>\n"; } // end while print "</tr>\n\n"; //get row data as an associative array while ($row = mysql_fetch_assoc($resquery)) { print "<tr>\n"; //look at each field foreach ($row as $col=>$val){ print " <td>$val</td>\n"; } // end foreach print "</tr>\n\n"; }// end while print "</table>\n"; ?><br /><? $query2 = "SELECT distinct Gruppo.NomeGruppo, Brano.Titolo, Brano.Durata, Genere.NomeGenere, Brano.Anno FROM `Brano`, Tracklist, Album, Gruppo, ArtistaA, Genere, GenereA WHERE Album.TitoloAlbum = '$album' AND Album.IDAlbum = Tracklist.IDAlbum AND Tracklist.IDBrano = Brano.IDBrano AND Gruppo.IDGruppo = ArtistaA.IDGruppo AND ArtistaA.IDAlbum = Album.IDAlbum AND Brano.IDGenere = Genere.IDGenere AND Genere.IDGenere = GenereA.IDGenere AND GenereA.IDAlbum = Album.IDAlbum;"; $resquery2 = mysql_query($query2, $conn) or die ($query2 . '<br />' . mysql_error()); print "<table border = 1>\n"; //get field names print "<tr>\n"; while ($campo = mysql_fetch_field($resquery2)) { print " <th>$campo->name</th>\n"; } // end while print "</tr>\n\n"; //get row data as an associative array while ($row = mysql_fetch_assoc($resquery2)) { print "<tr>\n"; //look at each field foreach ($row as $col=>$val){ print " <td>$val</td>\n"; } // end foreach print "</tr>\n\n"; }// end while print "</table>\n"; ?><br /><? $query3 = "SELECT Nome, Cognome, Alias, NomeRuolo FROM `Musicista`, Album, ArtistaA, Gruppo, LineUp, Ruolo WHERE Album.TitoloAlbum = '$album' AND ArtistaA.IDAlbum = Album.IDAlbum AND ArtistaA.IDGruppo = Gruppo.IDGruppo AND Gruppo.IDGruppo = LineUp.IDGruppo AND LineUp.IDMusicista = Musicista.IDMusicista AND LineUp.IDRuolo = Ruolo.IDRuolo;"; $resquery3 = mysql_query($query3, $conn) or die ($query3 . '<br />' . mysql_error()); print "<table border = 1>\n"; //get field names print "<tr>\n"; while ($campo = mysql_fetch_field($resquery3)) { print " <th>$campo->name</th>\n"; } // end while print "</tr>\n\n"; //get row data as an associative array while ($row = mysql_fetch_assoc($resquery3)) { print "<tr>\n"; //look at each field foreach ($row as $col=>$val){ print " <td>$val</td>\n"; } // end foreach print "</tr>\n\n"; }// end while print "</table>\n"; } ?></body></html>