<meta http-equiv="Content-Type" content="text/html; charset=windows-874">

<?
include("dbconfig.php");

/* ป้องกันการกรอกแท็ก HTML จากผู้ใช
		$name = htmlspecialchars($name);
		$place = htmlspecialchars($place);
		$pwd = htmlspecialchars($pwd);
// ป้อนกันการเกิด error ของ sql เมื่อ user ป้อน เครื่องหมาย "-" และ '-'
		$name = addslashes($name);
		$place = addslashes($place);
		$pwd = addslashes($pwd);
*/
function th_month($m)
{
//setlocale("LC_TIME","th");	//ใช้เวลาแบบไทย 
//$th = strftime("%B");	 // เดือนเต็ม
    switch ($m)
    { 
		case "01" ;
		{	$m = "มกราคม" ;
			break ; }
		case "02" ;
		{	$m = "กุมภาพันธ์" ;
			break ; }
		case "03" ;
		{	$m = "มีนาคม" ;
			break ; }
		case "04" ;
		{	$m = "เมษายน" ;
			break ; }	
     case "05" ;
		{	$m = "พฤษภาคม" ;
			break ; }
	 case "06" ;
		{	$m = "มิถุนายน" ;
			break ; }
	 case "07" ;
		{	$m = "กรกฏาคม" ;
			break ; }
	case "08" ;
		{	$m = "สิงหาคม" ;
			break ; }
	case "09" ;
		{	$m = "กันยายน" ;
			break ; }
	case "10" ;
		{	$m = "ตุลาคม" ;
			break ; }
	case "11" ;
		{	$m = "พฤศจิกายน" ;
			break ; }
	case "12" ;
		{	$m = "ธันวาคม" ;
			break ; }
	}
	 return $m ;
}
//	$c = strftime("%Y")+543;	 // ปี พ.ศ.
//	$d = date("H:i:s");	 // เวลา

/*
function decode($user_id)
{
 @$fdb = mysql_connect("localhost","root","") or die("can't connect");
						if (!$db)
							{
								echo "ติดต่อฐานข้อมูลไม่ได้";
								exit;
							}
						mysql_select_db("wp");
//mysql_select_db("hkm10_wp");
mysql_query(" SET NAMES 'tis620'; "); 
						$query="select  id,name  form  user where id = '$user_id' ";
						$result=mysql_query($query);
						while ($object = mysql_fetch_object($result))
		  				{
		  				$user_id = $object ->user_id ;
						}
						return $user_name;
 }
 */
	function formatDateDB($date)
	{
		$data = explode("/", $date);
		$newdata = sprintf("%04d%02d%02d", $data[2], $data[1], $data[0]); 
		return $newdata;
	}
//	$tdate = formatDateDB($date);
	
	function formatDateshow($date) 
	{
		$data = explode("-", $date);
		//$newdata = sprintf("%02d%02d%04d", $data[2], $data[1], $data[0]);
		$newdata = $data[2]."-".$data[1]."-".$data[0];
		return $newdata;
	}
	//$date_rq = formatDateshow($date);
	
	function formatDateshow1($date) 
	{
		$data = explode("-", $date);
		//$newdata = sprintf("%02d%02d%04d", $data[2], $data[1], $data[0]);
		$newdata2 = $data[2]."/".$data[1]."/".$data[0];
		return $newdata2;
	}

//sumit 	$date_rq = formatDateshow($date);

/* function ChkLogin( $email, $password )
	{
		global $conn;
		$strSQL = "SELECT * FROM customer ";
		$strSQL = $strSQL . "WHERE cus_email='$email' ";
		$strSQL = $strSQL . "AND cus_password='$password' ";
		$result = mysql_query( $strSQL );
		if ( ! $result )
			die ( "SELECT มีข้อผิดพลาด" . mysql_error() );
		$num = mysql_num_rows( $result );
		$rs = mysql_fetch_array( $result );
		if ( empty( $num ) )
			return false;
		else
			return $rs[cus_id];
	}
*/
/*	Function right()
{
global $right ;
	$file = fopen("wwwroot/CAR/right.php","w") ;
	$name = fread($file,20) ;
	if  (trim($name) == "LINUX_MIT" )
		{
		echo "<title>ระบบขอใช้รถยนต์ส่วนกลาง</title>" ;
		}
		else
		{
		echo "<title>ลงทะเบียนไม่ถูกต้อง  กรุณาติดต่อ ลงทะเบียนใช้โปรแกรม  สุรัติ เกิดในมงคล   tel .06-3178045</title>" ;
		}	 
	fclose($file);

}
right();*/

function date_diff2($from, $to) {
	if ($from > $to) {
		$t = $to;
		$to = $from;
		$from = $t;
	}
	$day1 = substr($from,0,2);
	$month1 = substr($from,3,2) ;
	$year1 = substr($from,6,4) -543;
	$day2 = substr($to,0,2);
	$month2 = substr($to,3,2) ;
	$year2 = substr($to,6,4) -543;
	
/*	$year1 = date("Y", $from);
	$year2 = date("Y", $to);
	$month1 = date("n", $from);
	$month2 = date("n", $to);
	$day1 = date("j", $from);
	$day2 = date("j", $to);
	*/
	if ($day2 < $day1) {
		if (($month2 - 1) == 4 || ($month2 - 1) == 6 || ($month2 - 1) == 9 || ($month2 - 1) == 11) {
			$day2 += 30;
			$month2 --;
		} else if (($month2 - 1) == 2) {
			if (date("L", $to)) {
				$day2 += 29;
				$month2 --;
			} else {
				$day2 += 28;
				$month2 --;
			}
		} else {
			$day2 += 31;
			$month2 --;
		}
	}
	$days = $day2 - $day1;

	if ($month2 < $month1) {
		$month2 += 12;
		$year2 --;
	}
	$months = $month2 - $month1;
	$years = $year2 - $year1;

	// return "$years years, $months months, $days days";
	 return "$days";
}
function formatDateDB2($date) 
	{
		$data = explode("/", $date);
		//$newdata = sprintf("%02d%02d%04d", $data[2], $data[1], $data[0]);
		$newdata3 = $data[2]."-".$data[1]."-".$data[0];
		return $newdata3;
	}

function  decodeuser($user_id) 
{

mysql_select_db($__dbwp__);
mysql_query(" SET NAMES 'tis620'; ");
						$sqll="select  distinct id,name  from user  where id = '$user_id' ";
		   				 $lresult=mysql_query($sqll);
		   					while (@$objectl = mysql_fetch_object($lresult))
	  						{
				 				return $objectl -> name ;
				 			}

}
?>