<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<?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!");
$sl="select idUser, HoTen, Username, Email from user";
$kq=mysqli_query($link,$sl);
?>
<table width="500" border="1" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<th width="64" scope="col">idUser</th>
<th width="159" scope="col">Họ tên</th>
<th width="135" scope="col">Username</th>
<th width="132" scope="col">Email</th>
</tr>
<?php
while($d=mysqli_fetch_array($kq))
{
?>
<tr>
<td><?php echo $d['idUser'];?></td>
<td><?php echo $d['HoTen'];?></td>
<td><?php echo $d['Username'];?></td>
<td><?php echo $d['Email'];?></td>
</tr>
<?php }?>
</tbody>
</table>
</body>
</html>
0 comments:
Post a Comment