//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'"); ?>
//theloaibh.php
<!doctype html> <html> <head> <meta charset="utf-8"> <title>theloaibh.php</title> </head> <body> <?php include("connect.php"); $sl="select * from webnhac_theloai"; $kq=mysqli_query($link,$sl); while($d=mysqli_fetch_array($kq)) { ?> <p><a href="dsbh.php?idTL=<?php echo $d['idTL'];?>"><?php echo $d['TenTL'];?></a></p> <?php } ?> </body> </html>//dsbh.php<!doctype html> <html> <head> <meta charset="utf-8"> <title>dsbh.php</title> </head> <body> <?php if(isset($_GET['idTL'])) { $idTL=$_GET['idTL']; include("connect.php"); $sl="select idTL, TenBH from webnhac_baihat where idTL=$idTL"; $kq=mysqli_query($link,$sl); while($d=mysqli_fetch_array($kq)){ ?> <p><?php echo $d['TenBH']; ?></p> <?php }}?> </body>
0 comments:
Post a Comment