/source code/danhsachdia.php
PHP | 175 lines | 174 code | 1 blank | 0 comment | 10 complexity | 01bfa719ac0b58e76464df6e0edf1734 MD5 | raw file
-
- <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"> </td>
- <?php
- } ?>
- </tr>
- <?php } ?>
- </table>
- <p align="center"> Trang:
- <?php
- for($i=1;$i<=$tongtrang;$i++)
- {
- if($i==$p)
- {
- echo $i." "." ";
- }
- else
- {
- ?>
- <a href="phancot.php?p=<?php echo $i;?>&tst=<?php echo $tongtrang;?>"> <?php echo $i." "." ";?> </a>
- <?php
- }
- }
- mysql_error();
- ?>
- </td>
- <td width="1"></tr>
- <tr>
- <td height="28" align="center" valign="middle" background="images/Page 1_r15_c11.jpg"> </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"> </td>
- <?php
- } ?>
- </tr>
- <?php } ?>
- </table>
- <p align="center"> Trang:
- <?php
- for($i=1;$i<=$tongtrang;$i++)
- {
- if($i==$p)
- {
- echo $i." "." ";
- }
- else
- {
- ?>
- <a href="phancot.php?p=<?php echo $i;?>&tst=<?php echo $tongtrang;?>"> <?php echo $i." "." ";?> </a>
- <?php
- }
- }
- mysql_error();
- ?></p></td>
- <tr>
- <td height="28" align="center" valign="middle" background="images/Page 1_r15_c11.jpg"> </td>
- </tr>
- </table></td>
- </tr>
- </table>