<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<table width="700" border=1 cellspacing="0" cellpadding="4">
<tr><td>系統帳號</td><td>註冊帳號</td><td>姓名</td><td>電子郵件</td><td>服務單位</td></tr>
<?
  require_once ("../etc/init.php");
  
  // 連結資料庫
  $link = mysql_connect($mysql_host, $mysql_user, $mysql_password) or die(mysql_error());
  mysql_select_db($mysql_database, $link) or die(mysql_error() );
  mysql_query("SET NAMES 'utf8'");
  $usermail="";
  // 判斷此帳號密碼是否存在
  $str = "SELECT hadoop_reg.user,hadoop_reg.email,hadoop_reg.name,hadoop_owner.hadoop_user,hadoop_reg.department FROM hadoop_reg,hadoop_owner WHERE hadoop_reg.user=hadoop_owner.hadoop_owner AND hadoop_owner.hadoop_owner != ''";
  $result = mysql_query($str , $link) or die(mysql_error() );
  $rows   = mysql_num_rows ($result);
  if($rows !=0)
  {
    echo "<tr><td colspan='5'>共計 $rows 筆註冊紀錄</td></tr>\n";
    for ($i=0 ; $i < $rows ; $i++)
    {
      $col= mysql_fetch_row($result);
      echo "<tr><td>$col[3]</td><td>$col[0]</td><td>$col[2]</td></td><td><a href='mailto:$col[1]'>$col[1]</a></td><td>$col[4]</td></tr>\n";
      if( $i == 0 ) $usermail= $col[1];
      else $usermail=$usermail." ,".$col[1];
    }
  }
  mysql_close($link);
?>
</table>
<? echo "全部使用者 email 清單<p/> <textarea cols='60'>$usermail</textarea>" ?>
</body>
</html>
