<?php require_once("header.php"); ?>
<?php

	$servername = "localhost";
	$username = "root";
	$password = "";
	$dbname = "phpbasic";
	$conn = new mysqli($servername, $username, $password,$dbname);
	mysqli_set_charset($conn, "utf8");

	// Check connection
	if ($conn->connect_error) {
		die("Connection failed: " . $conn->connect_error);
	}

	$sql = "SELECT * FROM studenttable4 where id='".$_GET["id"]."'";
	$result = $conn->query($sql);
	$row = $result->fetch_assoc()


?>
    <!-- MAIN SECTION -->
    <section class="mainContent full-width clearfix">
      <div class="container">
            <div class="row">
                  <div class="col-sm-4 col-xs-12">
                    <div class="teachersPhoto">
                      <img src="<?=$row["img"]?>" alt="image" class="img-rounded img-responsive">
                    </div>
                  </div>
                  <div class="col-sm-8 col-xs-12">
                    <div class="teachersInfo">
                          <h3><?=$row["firstname"]?> <?=$row["lastname"]?></h3>
                          <div class="teachersProfession bg-color-1">เพศ</div>
                          <div class="professionDetails"><?=$row["gender"]?></div>
                          <div class="teachersProfession bg-color-2">อายุ</div>
                          <div class="professionDetails"><?=$row["age"]?></div>
                          <div class="teachersProfession bg-color-3">Computer Language</div>
                          <div class="professionDetails"><?=$row["computerLanguage"]?></div>
                          <div class="teachersProfession bg-color-4">รายละเอียด</div>
                          <div class="professionDetails"><?=$row["detail"]?></div>
                    </div>
                  </div>
            </div>
      </div>
    </section>
<?php $conn->close(); ?>
<?php require_once("footer.php"); ?>