<?php
session_start(); 
ob_start();
echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />';                                       
include("../connect.php");     
//$username = $_POST['username'];
//$password = $_POST['password'];

//สมัคร
if ($_POST['submit']=='save'){
	$meSQL = "SELECT * FROM tb_member WHERE username = '".trim($_POST['txtUsername'])."' ";
	$meQuery = $conn->query($meSQL);
	$meResult = mysqli_fetch_array($meQuery,MYSQLI_ASSOC);
	if($meResult)
	{
			echo "<script>alert('ชื่อผู้ใช้นี้ มีในระบบแล้ว');window.history.back();</script>";
	}else{
		$create_date = date('Y-m-d H:i:s');
		$meSQL = "INSERT INTO tb_member (username,password,ntitle,firstname,surname,position,phone,email,status,active,create_date) VALUES ('".$_POST["txtUsername"]."','".$_POST["txtPassword"]."','".$_POST["title"]."','".$_POST["txtfirstname"]."','".$_POST["txtsurname"]."','".$_POST["position"]."','".$_POST["phone"]."','".$_POST["txtemail"]."','".$_POST["status"]."'
		,'".$_POST["active"]."','".$create_date."')";
		$meQuery = $conn->query($meSQL);		
		
		if ($meQuery == TRUE) {
			echo "<script>alert('สมัครเสร็จเรียบร้อยแล้ว'); window.location ='../index.php';</script>";
        } else {
			echo "<script>alert('มีปัญหาการบันทึกข้อมูล กรุณากลับไปบันทึกใหม่');history.back(-1);</script>";
			exit();
        }
	}		
}
ob_end_flush();
$conn->close();
?>