PHP数据库操作实例_F_hawk189

<?
     
 ?>

 <>
 <>
 <="GENERATOR" Content="Microsoft Visual Studio 6.0">
 <="text/css">
 <!--
 input { font-size:9pt;}
 A:link {text-decoration: underline; font-size:9pt;color:000059}
 A:visited {text-decoration: underline; font-size:9pt;color:000059}
 A:active {text-decoration: none; font-size:9pt}
 A:hover {text-decoration:underline;color:red}
 body,table {font-size: 9pt}
 tr,td{font-size:9pt}
 -->
 </style>
 <>注册会员列表 - 读取mysql的测试</title>
 </HEAD>
 <="#FF0000" link="#000099" vlink="#CC6600" topmargin="8" leftmargin="0" bgColor="#FFFFFF">
 <><><><=green size=3><>注 册 会 员 列 表</b></font></center>
 <>
 <=0 bordercolordark=#FFFFFF width="95%" bordercolorlight=#000000 border=1 align="center" cellpadding="2">
<="#6b8ba8" style="color:FFFFFF">
     <="5%" align="center" valign="bottom" height="19">ＩＤ</td>
     <="10%" align="center" valign="bottom">姓名</td>
     <="5%" align="center" valign="bottom">性别</td>
     <="5%" align="center" valign="bottom">年龄</td>
     <="20%" align="center" valign="bottom">联系电话</td>
     <="20%" align="center" valign="bottom">电子邮件</td>
     <="20%" align="center" valign="bottom">家庭住址</td>
 </tr>
 <?
     //连接到本地mysql数据库
    $myconn=mysql_connect("localhost","root","root");
     //选择test为操作库
    mysql_query("set names 'gbk'"); // //这就是指定数据库字符集，一般放在连接数据库后面就系了
    mysql_select_db("test",$myconn);
     $strSql="select * from user";
     //用mysql_query函数从user表里读取数据
    $result=mysql_query($strSql,$myconn);
     while($row=mysql_fetch_array($result))//通过循环读取数据内容
    {
 ?>
 <>
     <="center" height="19"><?echo $row["id"]?></td>
     <="center"><?echo $row["userid"]?></td>
     <="center"><?echo $row["sex"]?></td>
     <="center"><?echo $row["age"]?></td>
     <="center"><?echo $row["tel"]?></td>
     <="center"><?echo $row["email"]?></td>
     <="center"><?echo $row["address"]?></td>
 </tr>
 <?
     }
     //关闭对数据库的连接
    mysql_close($myconn);
 ?>
 </table>
 </BODY>
 </HTML>