<?php
	
	//宣告一個 link 變數，並執行連結資料庫函式，連結結果會帶入 link 當中
	
$link = mysqli_connect("localhost", "study_groupadmin", "wmnlabstudy_group256", "study_group");
	
	
	if (mysqli_connect_errno())
	{
		//有錯誤就代表連線失敗
		echo '無法連線資料庫 :<br/>' . mysqli_connect_errno();
	}
	else
	{
		//設定連線編碼為UTF-8
		mysqli_query($link, "SET NAMES utf8");
		
	}		
	
	$sql = "SELECT * FROM `study_group`";
	$result = mysqli_query($link, $sql);
	$datas = array();
	if(mysqli_num_rows($result) > 0){
		while ($row = mysqli_fetch_assoc($result)) {
			$datas[]= $row;
		}
	}
	
?>

<!DOCTYPE html>
<head>
  <meta charset="utf-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
  <link rel="stylesheet" type="text/css" href="style.css">
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
  <title>Homepage</title>
  <style type="text/css">
  <script src="scripts.js"></script>
</style>
</head>
<div class="container">
  <header>


<nav class="main-nav" role="navigation" style="padding: 0 20px 0 20px;">

  <!-- Mobile menu toggle button (hamburger/x icon) -->
  <input id="main-menu-state" type="checkbox" />
  <label class="main-menu-btn" for="main-menu-state">
    <span class="main-menu-btn-icon"></span> Toggle main menu visibility
  </label>

  <h2 class="nav-brand"><a href="home.html">IEEE 1935</a></h2>

  <!-- Sample menu definition -->
  <ul id="main-menu" class="sm sm-clean">
    <li><a href="about.html">About</a></li>
<li><a href="index.html">Standard</a>
          <ul>
            <li><a href="index.html" target="_blank">Document</a></li>
            <li><a href="index.html#Architechture">Architechture</a></li>
    </ul></li>
      <li><a href="ini.html">System Installation</a>
        <ul>
            <li><a href="ini.html#Installation">Initialization</a></li>
            <li><a href="ini.html#Start">Start the system</a></li>
            <li><a href="https://wmnlabnas.quickconnect.to" target="_blank">Source Code</a></li>
            <li><a href="resource.php">Resources</a></li>
        </ul></li>
      <li><a href="../phpBB3/index.php" target="_blank">Forum</a></li>
      <li><a href="study_group.php">Study Group</a></li>
      <li><a href="pubs.html">Publications</a></li>
      
  </ul>
</nav>
</header>

	<body>
		  <main style="padding: 0 75px 0 20px;">
 <div class="wrapper">
  <div class="Rtable Rtable--5cols Rtable--collapse">
		<div class="Rtable-row Rtable-row--head">
      <div class="Rtable-cell date-cell column-heading">Date</div>
      <div class="Rtable-cell topic-cell column-heading">Topic</div>
      <!--div class="Rtable-cell access-link-cell column-heading">Access Link</div-->
      <div class="Rtable-cell replay-link-cell column-heading">Replay</div>
      <div class="Rtable-cell pdf-cell column-heading">Pdf</div>
    </div>

<?php if(!empty($datas)):?>
<?php foreach($datas as $study_group):?>
    <div class="Rtable-row">
      <div class="Rtable-cell date-cell">
        <div class="Rtable-cell--heading">Date</div>
        <div class="Rtable-cell--content date-content"><span class="webinar-date">
        	
		<?php echo "" . $study_group['date'];?><br /></div>
						
      </div>
      <div class="Rtable-cell topic-cell">
        <div class="Rtable-cell--content title-content">
        	
		<?php echo "" . $study_group['topic'];?><br /></div>
						
      </div>
      <div class="Rtable-cell replay-link-cell">
        <div class="Rtable-cell--heading">Replay</div>
        <div class="Rtable-cell--content replay-link-content">
        <?php if(!empty($study_group['replay'])):?>
        <a href="<?php echo "". $study_group['replay'];?>"><i class='fa fa-video-camera' aria-hidden='true'></i></a><br/><?php endif?>
      </div>
      </div>

      <div class="Rtable-cell Rtable-cell--foot pdf-cell">
        <div class="Rtable-cell--heading">Pdf</div>
        <div class="Rtable-cell--content pdf-content">
        	
		<a href="<?php echo "". $study_group['pdf'];?>"><i class='fa fa-file-text' aria-hidden='true'></i></a><br/>
						
      </div>
      </div>
    </div>
<?php endforeach;?>
<?php endif?>
</div>
</div>
	  </main>
<script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js'></script>
<script src='https://cdn.jsdelivr.net/jquery.slick/1.6.0/slick.min.js'></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js'></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/jquery.smartmenus/1.0.1/jquery.smartmenus.min.js'></script>
<script  src="./script.js"></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/jquery.cycle2/2.1.6/jquery.cycle2.js'></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/jquery.cycle2/2.1.6/jquery.cycle2.carousel.js'></script>
</body>
</div>
</html>
