<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml";>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head> <body>
<?php
$link = mysql_connect("localhost","root","haifeng")or die("不能连接到服务器".mysql_error());
$db_selected=mysql_select_db("haifeng",$link);
mysql_query("set names gb2312"); $sql= mysql_query("select * from testhaifeng");
$info= mysql_fetch_array($sql);
if($info==false){
echo"<div align='center' style='color:#FFoooo;font-size:12px'>对不起,暂时还没有会员</div>";
} ?>
<?php
do{
?>
<tr align="center" bgcolor="#FFFFFF">
<td height="20" align="center"><?php echo $info['Id']; ?></td>
<td> <?php echo $info['username']; ?></td>
<td> <?php echo $info['passworda']; ?></td>
<td> <?php echo $info['type']; ?></td>
</tr>
<?php
}while($info=mysql_fetch_array($sql));
?>
</body>
</html>
|