<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Ca si</title>
</head>
<body>
<?php
include("connect.php");
$sl="select * from webnhac_casi";
$kq=mysqli_query($link,$sl);
?>
<ul>
<?php
while($d=mysqli_fetch_array($kq))
{
//Lấy các bài hát theo idCS:
$slbh="select idBH, TenBH from webnhac_baihat where idCS=".$d['idCS'];
$kqbh=mysqli_query($link,$slbh);
if(mysqli_num_rows($kqbh)>0){
?>
<li><?php echo $d['HoTenCS'];?>
<ul>
<?php
while($dbh=mysqli_fetch_array($kqbh)){
?>
<li><a href="chitietbh.php?idbh=<?php echo $dbh['idBH'];?>"><?php echo $dbh['TenBH'];?></a></li>
<?php }?>
</ul>
</li>
<?php } }?>
</ul>
</body>
</html>
//connect.php
<?php
//Kết nối đến server DB:
$link=@mysqli_connect("localhost","root","") or die("Không thể kết nối đến Server!");
//Chọn database cần thao tác:
mysqli_select_db($link,"webtintuc") or die("Không tồn tại DB này!");
mysqli_query($link,"set names 'utf8'");
?>
//chitiet.php
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<?php
if(isset($_GET['idbh']))
{
$idbh=$_GET['idbh'];
include("connect.php");
$sl="select TenBH, LoiBH from webnhac_baihat where idBH=$idbh";
$kq=mysqli_query($link,$sl);
$d=mysqli_fetch_array($kq);
?>
<h1 align="center"><?php echo $d['TenBH'];?></h1>
<div><?php echo $d['LoiBH'];?></div>
<?php
}?>
</body>
</html>
0 comments:
Post a Comment