<meta http-equiv="refresh" content="1;URL=insertt.php" />

<?php
$servername = "localhost";
$username = "root";
$password = "P@ssw0rdMySQL0";
$dbname = "quiz";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
  die("Connection failed: " . mysqli_connect_error());
}

$name = $_POST["name"];
$email = $_POST["email"];
$tel = $_POST["tel"];
$member = $_POST["member"];
$school = $_POST["school"];
$subject = $_POST["subject"];
$status = $_POST["status"];
$score = $_POST["score"];
$percent = $_POST["percent"];

function DateThai($strDate)
{
  $strYear = date("Y",strtotime($strDate))+543;
  $strMonth= date("n",strtotime($strDate));
  $strDay= date("j",strtotime($strDate));
  $strHour= date("H",strtotime($strDate));
  $strMinute= date("i",strtotime($strDate));
  $strSeconds= date("s",strtotime($strDate));
  $strMonthCut = Array("","มกราคม","กุมภาพันธ์","มีนาคม","เมษายน","พฤษภาคม","มิถุนายน","กรกฎาคม","สิงหาคม","กันยายน","ตุลาคม","พฤศจิกายน","ธันวาคม");
  $strMonthThai=$strMonthCut[$strMonth];
  return "ให้ไว้ ณ วันที่ $strDay $strMonthThai พุทธศักราช $strYear";
}
$date = date("Y-m-d");
$strDate = "$date";
$datethai = DateThai($strDate);

$sql = "INSERT INTO quiz_pass (name, email, tel, member, school, subject, status, score, percent, date)
VALUES ('$name', '$email', '$tel', '$member', '$school', '$subject', '$status', '$score', '$percent', '$datethai')";






if (mysqli_query($conn, $sql)) {
  echo "เรียบร้อยแล้ว";
} else {
  echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);

?>