PHP資料庫操作執行個體

<?
     
 ?>

 <>
 <>
 <="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>