<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<?php
error_reporting(0); //hide error
header("Content-Type:text/html; charset=utf-8");
$servername = "localhost";
$username = "id21593489_id17615458_tangb";
$password = "c5t9QN19L(W6EPRq";
$database = "id21593489_id17615458_zadmin_website";

$conn = mysqli_connect($servername,$username,$password)or die("cannot connect to the db");//connect server
mysqli_select_db($conn,$database)or die("cannot open the selected db");//select db
mysqli_query($conn,"set names utf8");//utf8 to select data, allow show chinese
$data=mysqli_query($conn,"SELECT * FROM `enrol_20170527` WHERE attend = 1;") or die("no data");//all table in contact db
$data2=mysqli_query($conn,"SELECT * FROM `enrol_20170527` WHERE attend = 0;") or die("no data");//all table in contact db
$data3=mysqli_query($conn,"SELECT nickName FROM `altar` WHERE id<2000 AND NOT EXISTS (SELECT 1 FROM `enrol_20170527` WHERE nickName = name)") or die("no data");//not exist in second table
?>
  <title>Enrollment list</title>
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<link rel="icon" type="image/png" href="/images/favicon/favicon-32x32.png" sizes="32x32">
    <link rel="icon" type="image/png" href="/images/favicon/favicon-16x16.png" sizes="16x16">
	<link rel="stylesheet" href="css/style.css">
    <link rel="stylesheet" href="css/w3.css">

</head>


<body>
	<div id="wrapper">
	<div id="main" class="clearfix">
	<div class="w3-center w3-blue w3-padding-48">
	<h1>Enrollment list</h1>
	</div>
	
	<div class="w3-content w3-container w3-padding-64">
		<div class="w3-row">
			<div class="w3-container w3-third">
			Attendance List:<p><textarea rows="10" cols="30"><?php
				//echo"test" ; //input value
				
				if (!$data)  die ("");
					else {
					while ($row=mysqli_fetch_array($data,MYSQLI_ASSOC))  {
					   echo $row["name"]. " : " . $row["remark"]. "\n" ;
					}
					}
			?>
			</textarea></p>
			</div>
			<div class="w3-container w3-third">	
			Unable List:<p><textarea rows="10" cols="30"><?php
				if (!$data2)  die ("");
					else {
					while ($row=mysqli_fetch_array($data2,MYSQLI_ASSOC))  {
					   echo $row["name"]. " : " . $row["remark"]. "\n" ;
					}
					}
			?>
			</textarea></p>
			</div>
			<div class="w3-container w3-third">	
			Not enrolled:<p><textarea rows="10" cols="30"><?php
				if (!$data3)  die ("");
					else {
					while ($row=mysqli_fetch_array($data3,MYSQLI_ASSOC))  {
					   echo $row["nickName"]. "\n" ;
					}
					}
			?>
			</textarea></p>
			</div>
		</div>
	</div>	
	</div>	
	</div>
	
<div id="footer" class="w3-center w3-dark-grey w3-padding-48 w3-hover-text-black">
	 &copy; 2016
	 <script>new Date().getFullYear()>2016&&document.write("-"+new Date().getFullYear()); </script>
	 , <a href="/">tangb.tk</a>, 
	 All Rights Reserved
     &middot; 
</div>
	
</body>
</html>