Skip to main content

Posts

in HoTenCS từ database ra màn hình - Tiếp theo in thêm TenBH dưới HoTenCS - Tiếp theo chỉ hiện những ca sĩ có bài hát. CUỐI CÙNG in ra lời bài hát từ liên kết đến trang chitietbh.php

By Duc Nguyen
  <!doctype html> <html> <head> <meta charset="utf-8"> <title>Ca si Duc 4</title> </head> <body> <?php include("connect_duc.php"); $sl="select * from webnhac_casi"; $kq=mysqli_query($link,$sl); ?> <ul> <?php while($d=mysqli_fetch_array($kq)) { $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="chitiet_duc.php?idbh=<?php echo $dbh['idBH']; ?>"><?php echo $dbh['TenBH']; ?></a></li> <?php } ?> </ul> </li> <?php } } ?> </ul> </body> </html> //connect_duc.php <?php $link...
Post a Comment
Read more

in HoTenCS từ database ra màn hình - Tiếp theo in thêm TenBH dưới HoTenCS - Tiếp theo chỉ hiện những ca sĩ có bài hát

By Duc Nguyen
  <!doctype html> <html> <head> <meta charset="utf-8"> <title>Ca sĩ Duc</title> </head> <body> <?php $link=@mysqli_connect("localhost","root","") or die("Không tìm thấy Sever"); mysqli_select_db($link,"webtintuc") or die("Không tìm thấy DB"); mysqli_query($link, "set names 'utf8'"); $sl="select * from webnhac_casi"; $kq=mysqli_query($link,$sl); ?> <ul> <?php while($d=mysqli_fetch_array($kq)) { $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><?php echo $dbh['TenBH']; ?></li> ...
Post a Comment
Read more

in HoTenCS từ database ra màn hình - Tiếp theo in thêm TenBH dưới HoTenCS

By Duc Nguyen
<!doctype html> <html> <head> <meta charset="utf-8"> <title>Ca sĩ Duc</title> </head> <body> <?php $link=@mysqli_connect("localhost","root","") or die("Không tìm thấy Sever"); mysqli_select_db($link,"webtintuc") or die("Không tìm thấy DB"); mysqli_query($link, "set names 'utf8'"); $sl="select * from webnhac_casi"; $kq=mysqli_query($link,$sl); ?> <ul> <?php while($d=mysqli_fetch_array($kq)) { ?> <li><?php echo $d['HoTenCS']; $slbh="select idBH, TenBH from webnhac_baihat where idCS=".$d['idCS']; $kqbh=mysqli_query($link,$slbh); ?> <ul> <?php while($dbh=mysqli_fetch_array($kqbh)){ ?> <li><?php echo $dbh['TenBH']; ?></li> <?php } ?> ...
Post a Comment
Read more

in HoTenCS từ database ra màn hình

By Duc Nguyen
<!doctype html> <html> <head> <meta charset="utf-8"> <title>Ca sĩ Duc</title> </head> <body> <?php $link=@mysqli_connect("localhost","root","") or die("Không tìm thấy Sever"); mysqli_select_db($link,"webtintuc") or die("Không tìm thấy DB"); mysqli_query($link, "set names 'utf8'"); $sl="select * from webnhac_casi"; $kq=mysqli_query($link,$sl); ?> <ul> <?php while($d=mysqli_fetch_array($kq)) { ?> <li><?php echo $d['HoTenCS']; ?></li> <?php } ?> </ul> </body> </html>
Post a Comment
Read more

Database webtintuc.sql

By Duc Nguyen
  -- phpMyAdmin SQL Dump -- version 2.10.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 11, 2008 at 12:03 AM -- Server version: 5.0.18 -- PHP Version: 5.2.3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `ajax` -- -- -------------------------------------------------------- -- -- Table structure for table `bandocykien` -- CREATE TABLE `bandocykien` ( `idYKien` int(11) NOT NULL auto_increment, `idTin` int(11) NOT NULL default '0', `Ngay` date NOT NULL default '0000-00-00', `NoiDung` text NOT NULL, `Email` varchar(255) default NULL, `HoTen` varchar(255) default NULL, `DiaChi` varchar(255) default NULL, PRIMARY KEY (`idYKien`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Dumping data for table `bandocykien` -- -- -------------------------------------------------------- -- -- Table structure for table `binhchon` -- CREATE TABLE `binhchon` ( `idBC` int(11) NOT NULL auto_increment, `MoTa` varc...
Post a Comment
Read more