Saturday, 11 December 2021

PHP#7 - MySQL#3 - Hiện thông tin Tên, gắn liên kết, sắp xếp ThuTu tăng dần ( $sl="select Ten, Url, ThuTu from lienket order by ThuTu ASC"; ) LÊN BẢNG 

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>

<body>
<?php
	$link=@mysqli_connect("localhost","root","") or die;
	mysqli_select_db($link,"webtintuc") or die;
	$sl="select Ten, Url, ThuTu from lienket order by ThuTu ASC";
	$kq=mysqli_query($link,$sl);
	$d=mysqli_fetch_array($kq)
?>
<table width="200" border="1">
  <tbody>
  
    <tr>
      <th scope="col">Các liên kết</th>
    </tr>
<?php
  	while($d=mysqli_fetch_array($kq))
	{
  	?>
    <tr>
      <td><a href="<?php echo $d['Url']; ?>"><?php echo $d['Ten']; ?></a></td>
    </tr>
    <?php } ?>
  </tbody>
</table>
</body>
</html>

1 comment: