<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<?php
error_reporting(0); //hide error
//Demo 4: GuessingA.php set cookies to avoid many submit times
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 altar.cName, nickName FROM `altar` WHERE id<2000 AND NOT EXISTS (SELECT 1 FROM `enrol_20170527` WHERE nickName = name)") or die("no data");//all table in contact db
?>
  <title>e-Enrollment System</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>Online Enrollment</h1>
</div>

<form name"enrolForm" method="post" action="enrol_complete.php" onsubmit="return confirm('Are you sure to submit?\nName:'+document.getElementById('nickName').value+'\nAttend:'+document.getElementById('attend').value+'\nRemark:'+document.getElementById('remark').value);">
<div class="w3-content w3-container w3-padding-64">
    
      <p>Details:</p>
      <p>甘修女發願25年銀禧紀念彌撒</p>
      <p>日期: 5月27日 星期六</p>
      <p>時間: 2:30pm集合, 3:00pm彌撒</p>
      <p>&#28858;&#32113;&#35336;&#20154;&#25976;, &#35531;&#22635;&#22949;&#19979;&#21015;&#31354;&#26684;&#24460;&#36865;&#20986;. Complete the form below.</p>
      <div class="w3-row-padding" style="margin:0 -16px 8px -16px">
        <div class="w3-half">
          <p>Name: 
		  <select class="w3-input w3-border w3-hover-light-grey" name="nickName" id="nickName" required>
				<option disabled selected value> -- select an option -- </option>
		  <?php
				if (!$data)  die ("");
					else {
					while ($row=mysqli_fetch_array($data,MYSQLI_ASSOC))  {
						print("<option value=" . $row["nickName"] . ">" . $row["cName"] . "</option>");
					}
					}
					
					mysqli_close($conn);
					?>
			</select>		
			</p>
		  </div>
        <div class="w3-half">
		  <p>Attendance:
			<select class="w3-input w3-border w3-hover-light-grey" name="attend" id="attend" required>
				<option disabled selected value> -- select an option -- </option>
		        <option value="1">&#20986;&#24109;</option>
                <option value="0">&#19981;&#20986;&#24109;</option>
			</select>
            
		  </div>
      </div>
	  <p> Remarks:<input class="w3-input w3-border w3-hover-light-grey" type="text" name="remark" id="remark" placeholder="Reason"> </p>
	  <button class="w3-btn w3-section w3-blue w3-right">Send</button>
    
</div>
</form>
</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>