userdetail.php

来自「一个PHP的购物系统源代码」· PHP 代码 · 共 95 行

PHP
95
字号
<?
  //从数据库中取得用户的详细信息
  $connect=mysql_connect("127.0.0.1","root","root");
  mysql_select_db("ebusiness");
  $query="Select * from User where UserID='.$id.'";
  $result=mysql_query($query);
  $res=mysql_fetch_array($result);
  mysql_close($connect);
  
  //按格式输出
  echo'<html>
       <head>
       <title>用户详细数据</title>
       <meta http-equiv="Content-Type" content="text/html;charset=gb2312">
       </head>';
       
  echo'<body bgcolor="#ffffff">
          <table width="760" border="1" cellspacing="5" cellpadding="0">
            <tr align="center">
              <td width="121">用户编号</td>
              <td width="616">';
  echo $res["UserID"];
  echo'</td>
          </tr>
          <tr align="center">
          <td width="121">用户名</td>
          <td width="616">';
  echo $res["UserName"];
  echo'</td>
          </tr>
          <tr align="center">
          <td width="121">密码提示问题</td>
          <td width="616">';
  echo $res["UserPWdA"];
  echo'</td>
          </tr>
          <tr align="center">
          <td width="121">密码提示问题答案</td>
          <td width="616">';
echo $res["UserPWdA"];
  echo'</td>
          </tr>
          <tr align="center">
          <td width="121">帐号创建时间</td>
          <td width="616">';
          echo $res["ACreatedate"];
  echo'</td>
          </tr>
          <tr align="center">
          <td width="121">用户E-mail</td>
          <td width="616">';
          echo $res["UserEmail"];
  echo'</td>
          </tr>
          <tr align="center">
          <td width="121">用户电话</td>
          <td width="616">';
          echo $res["UserEmail"];
  echo'</td>
          </tr>
          <tr align="center">
          <td width="121">用户电话</td>
          <td width="616">';
          echo $res["UserTel"];
  echo'</td>
          </tr>
          <tr align="center">
          <td width="121">住址</td>
          <td width="616">';
          echo $res["ADDress"];
  echo'</td>
          </tr>
          <tr align="center">
          <td width="121">用户积分</td>
          <td width="616">';
  echo $res["UserCredit"];
  echo'</td>
          </tr>
          <tr align="center">
          <td width="121">上次访问时间</td>
          <td width="616">';
  echo $res["CLoginTime"];
  echo '</td>
        </tr>
        <tr align="center">
          <td width="121">访问本站次数</td>
          <td width="616">';
  echo $res["LoginCount"];
  echo '</td>
        </tr>
        </table>
        </body>
        </html>';
?>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?