<?php

include "../admin/connect.php";

$tblname = "member";



$username = trim($_POST["username"]);



	if(trim($username) == "")

	{

		echo "<img src='../images/false.png'>กรุณาใส่ Username ด้วยนะคะ";

		exit();

	}





	$strSQL = "SELECT * FROM member WHERE username = '".$username."' ";

	$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");

	$objResult = mysql_fetch_array($objQuery);

	if($objResult)

	{

		echo "<img src='../images/false.png'> username ซ้ำค่ะกรุณาใส่ใหม่นะคะ" ;

	}

	else

	{

		echo "<img src='../images/true.png'> username ใช้ได้ค่ะ";

	}



if(isset($_POST['username'])){

	$username=($_POST["username"]); 

	$password=($_POST["password"]); 

	$name=($_POST["name"]); 

	$surname=($_POST["surname"]); 

	$nickname=($_POST["nickname"]); 

	$rdoSex=$_POST["rdoSex"]; 

	$email=($_POST["email"]); 

	$address=($_POST["address"]); 

	$province=($_POST["province"]); 

	$telephone=($_POST["telephone"]); 

	$fax=($_POST["fax"]); 

	$mobile=($_POST["mobile"]);

	$r=($_POST["r"]);

	

if(trim($_FILES["fileUpload"]["tmp_name"]) != "")

	{

		$images = $_FILES["fileUpload"]["tmp_name"];

		$new_images = "Thumbnails_".$_FILES["fileUpload"]["name"];

		copy($_FILES["fileUpload"]["tmp_name"],"../images/member/".$_FILES["fileUpload"]["name"]);

		$width=100; //*** Fix Width & Heigh (Autu caculate) ***//

		$size=GetimageSize($images);

		$height=round($width*$size[1]/$size[0]);

		$images_orig = ImageCreateFromJPEG($images);

		$photoX = ImagesX($images_orig);

		$photoY = ImagesY($images_orig);

		$images_fin = ImageCreateTrueColor($width, $height);

		ImageCopyResampled($images_fin, $images_orig, 0, 0, 0, 0, $width+1, $height+1, $photoX, $photoY);

		ImageJPEG($images_fin,"../images/member/".$new_images);

		ImageDestroy($images_orig);

		ImageDestroy($images_fin);

$sql = "INSERT INTO $tblname (username,password,name,surname,nickname,sex,email,address,province,telephone,fax,mobile,status,Thumbnails,FilesName) 

            VALUES ('$username','$password','$name','$surname','$nickname','$rdoSex', '$email', '$address', '$province', '$telephone', '$fax', '$mobile','$r','".$new_images."','".$_FILES["fileUpload"]["name"]."')"; 

$dbquery = mysql_db_query($dbname, $sql);

	

	}else{

	

	$sql = "INSERT INTO $tblname

	(username,password,name,surname,nickname,sex,email,address,province,telephone,fax,mobile,status,Thumbnails,FilesName)

		VALUES ('$username','$password','$name','$surname','$nickname','$rdoSex','$email','$address','$province','$telephone','$fax','$mobile','$r','Null','Null')";

$dbquery = mysql_db_query($dbname, $sql);

	}

}

//mysql_close();

echo"<script>window.open('Newmember.php','','scrollbars=no,resizable=no,width=420,height=200');</script>";

?>