Tuesday, 14 December 2021

casi.php - PHP#8MySQL#4 - Lấy các bài hát theo idCS

 <!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