/source code/danhsachdia.php

    <table width="560" border="0" align="center" cellpadding="0" cellspacing="0">

        <tr>

          <td width="280" align="left" valign="top">

          <table width="270" border="0" cellpadding="0" cellspacing="0" class="khungcasy">

            <tr>

              <td width="267" height="28" align="center" valign="top" background="images/Page 1_r6_c4.jpg">

              <img src="images/Page 1_r17_c28.jpg" width="86" height="28" /></td>

            </tr>

            <tr>

            <td class="khoangcachtrong">

            <table width="267" cellpadding="0" cellspacing="0" border="0" class="khungcasy">

            <?php

require("ketnoi.php");

$dong=4;

if(!isset($_GET["tst"]))

{

$truyvan="select * from nhac";

$thtv=mysql_query($truyvan,$link);

$tongtrang=ceil(mysql_num_rows($thtv)/$dong);

}

else

{

$tongtrang=intval($_GET["tst"]);

}

if(!isset($_GET["p"]))

{

$p=1;

}

else

{

$p=intval($_GET["p"]);

}

$x=($p - 1) * $dong;

$s="select * from nhac limit ".$x.",".$dong;

$lienket=mysql_query($s,$link);

while($rows=mysql_fetch_object($lienket))

{

$macasi=$rows->macasi;

$s1=mysql_query("select * from casi where macasi='$macasi'",$link);

$row2=mysql_fetch_object($s1);

?>

<tr>

	<td width="50%" valign="middle" style="font-size:9px; color:#FFFFFF; font-weight:400"><img width="111" height="110" src="anhnhac/<?php echo $rows->hinhanh;?>" /><br /><b>

	  <span >Album</span>: <?php echo $rows->tendianhac;?><br />

	  <span >Ca s?</span>: <?php echo $row2->tencasi;?></b></td>

    <?php

	if($rows=mysql_fetch_object($lienket))

		{

		$macasi=$rows->macasi;

$s2=mysql_query("select * from casi where macasi='$macasi'",$link);

$row3=mysql_fetch_object($s2);

		?>

        <td width="50%" valign="middle" style="font-size:9px; color:#ffffff; font-weight:400"><img src="anhnhac/<?php echo $rows->hinhanh;?>" width="111" height="110" /><br /><b>

           <span >Album:</span> <?php echo $rows->tendianhac;?><br />

           <span>Ca s?:</span> <?php echo $row3->tencasi;?></b></td>

        <?php 

		} 

		else

		{

		?>

        <td width="135" valign="middle">&nbsp; </td>

        <?php

		 } ?>

</tr>

<?php } ?>

</table>

<p align="center"> Trang: 

<?php

for($i=1;$i<=$tongtrang;$i++)

{

	if($i==$p)

		{

			echo $i."&nbsp;"."&nbsp;";

		}

	else

	{

	?>

    <a href="phancot.php?p=<?php echo $i;?>&tst=<?php echo $tongtrang;?>"> <?php echo $i."&nbsp;"."&nbsp;";?> </a>

    <?php

	}

}

mysql_error();

?>

</td>

<td width="1"></tr>

            <tr>

              <td height="28" align="center" valign="middle" background="images/Page 1_r15_c11.jpg">&nbsp;</td>

            </tr>

          </table></td>

          <td width="280" align="right" valign="top"><table width="270" border="0" cellpadding="0" cellspacing="0" class="khungcasy">

            <tr>

              <td height="28" align="center" valign="top" background="images/Page 1_r6_c4.jpg"><img src="images/Page 1_r17_c41.jpg" width="82" height="28" /></td>

            </tr>

            <tr>

                <td align="center" valign="top" class="khoangcachtrong">

                <table width="267" cellpadding="0" cellspacing="0" border="0" class="khungcasy">

				<?php

require("ketnoi.php");

$dong=4;

if(!isset($_GET["tst"]))

{

$truyvan="select * from phim";

$thtv=mysql_query($truyvan,$link);

$tongtrang=ceil(mysql_num_rows($thtv)/$dong);

}

else

{

$tongtrang=intval($_GET["tst"]);

}

if(!isset($_GET["p"]))

{

$p=1;

}

else

{

$p=intval($_GET["p"]);

}

$x=($p - 1) * $dong;

$s="select * from phim limit ".$x.",".$dong;

$lienket=mysql_query($s,$link);

while($rows=mysql_fetch_object($lienket))

{

$madvphim=$rows->madvphim;

$s1=mysql_query("select * from dienvienphim where madvphim='$madvphim'",$link);

$row2=mysql_fetch_object($s1);

?>

<tr>

	<td width="50%" valign="middle" style="font-size:9px; color:#FFFFFF; font-weight:400"><img width="111" height="110" src="anhphim/<?php echo $rows->hinhphim;?>" /><br /><b>

	  <span >Phim</span>: <?php echo $rows->tenphim;?><br />

	  <span >Di?n Vięn:</span> <?php echo $row2->tendvphim;?></b></td>

    <?php

	if($rows=mysql_fetch_object($lienket))

		{

		$macasi=$rows->madvphim;

$s2=mysql_query("select * from phim where madvphim='$macasi'",$link);

$row3=mysql_fetch_object($s2);

		?>

        <td width="50%" valign="middle" style="font-size:9px; color:#ffffff; font-weight:400"><img src="anhphim/<?php echo $rows->hinhphim;?>" width="111" height="110" /><br /><b>

           <span class="style5">Phim:</span> <?php echo $rows->tenphim;?><br />

           <span class="style5">Di?n vięn:</span> <?php echo $row3->tendvphim;?></b></td>

        <?php 

		} 

		else

		{

		?>

        <td width="135" valign="middle">&nbsp; </td>

        <?php

		 } ?>

</tr>

<?php } ?>

</table>

<p align="center"> Trang: 

<?php

for($i=1;$i<=$tongtrang;$i++)

{

	if($i==$p)

		{

			echo $i."&nbsp;"."&nbsp;";

		}

	else

	{

	?>

    <a href="phancot.php?p=<?php echo $i;?>&tst=<?php echo $tongtrang;?>"> <?php echo $i."&nbsp;"."&nbsp;";?> </a>

    <?php

	}

}

mysql_error();

?></p></td>

            <tr>

              <td height="28" align="center" valign="middle" background="images/Page 1_r15_c11.jpg">&nbsp;</td>

            </tr>

          </table></td>

        </tr>

      </table>