<body bgcolor="#969696">
<?php
$db=mysql_connect('localhost','root','')or die ("error connexion base");
$base=mysql_select_db('movies',$db)or die ("error connect database");
$nbrow=0;
$cont = 0; //Para el checkbox
print "<form action ='borrardatos1.php' method='post'>";
$result = mysql_query("SELECT * FROM pelis order by titulo asc");
if (!$result) {
die('Invalid query: ' . mysql_error());
}
echo "<table CELLSPACING=2 CELLPADDING=1 width='99%' border='5' align='center'> \n";
echo "<tr><tr bgcolor='#FFFF00'><td><center><font color='#FF0000'><b>LISTADO PELICULAS
DESCARGADAS</td></tr> \n";
echo "<div align=\"center\"><b></b></div><p><br><p>\n";
echo "<table CELLSPACING=2 CELLPADDING=1 width='99%' border='5' align='center'> \n";
echo "<tr><tr bgcolor='#FFFFFF'>
<td><center><b>Titulo Estreno</td>
<td><center><b>Categoria</td>
<td><center><b>Fecha Alta</td>
<td><center><b>Año</td>
<td><center><b>Duracion</td>
<td><center><b>Tamaño</td>
<td><center><b>Caratula</td>
<td><center><b>Informacion</td></tr> \n";
while($row=mysql_fetch_array($result))
{
$año=$row["año"];
$categoria=$row["categoria"];
$fecha=$row["fecha"];
$titulo=$row["titulo"];
$sinopsis=$row["sinopsis"];
$duracion=$row["duracion"];
$peso=$row["peso"];
$foto=$row["foto"];
$jpg= "<img src=\"http://localhost/upload-pelis/upload/galeria/$foto.jpg\" border=\"0\"
width=\"100%\">";
print "<tr bgcolor='#DDDDDD'> ";
print "<td> <div align=\"center\"><font color=\"#000000\"><font size=\"3\"><font
face=\"Verdana\"><b>$titulo</font></font></div></td>";
print "<td> <div align=\"center\"><font color=\"#000000\"><font size=\"1\"><font
face=\"Verdana\">$categoria</font></font></div></td>";
print "<td> <div align=\"center\"><font color=\"#000000\"><font size=\"1\"><font
face=\"Verdana\">$fecha</font></font></div></td>";
print "<td> <div align=\"center\"><font color=\"#000000\"><font size=\"1\"><font
face=\"Verdana\">$año</font></font></div></td>";
print "<td> <div align=\"center\"><font color=\"#000000\"><font size=\"1\"><font
face=\"Verdana\">$duracion</font></font></div></td>";
print "<td> <div align=\"center\"><font color=\"#000000\"><font size=\"1\"><font
face=\"Verdana\">$peso</font></font></div></td>";
print "<td> <div align=\"center\"><font color=\"#000000\"><font size=\"1\">
<font face=\"Verdana\">$jpg</font></font></div></td>";
print "<td> <div align=\"center\"><font color=\"#000000\"><font size=\"2\"><font
face=\"Verdana\">$sinopsis</font></font></div></td>";
print "</tr>";
}
print "</form> \n";
echo "</table> \n <p><br><p>";
//imprime número de registros
//print "<b><font size=\"1\"><font face=\"Verdana\">$nbrow </font></b>";
?>
<form action="lista1.php" target = ""><center>
<input type="submit" value = "Actualizar Listado">
</form>
<form action="alta1.php" target = ""><center>
<input type="submit" value = "Añadir Pelicula">
</form><br>
<form action="../../index2.html" target = ""><center>
<input type="submit" value = "Inicio">
</form><br>