<?php
class User extends Connect
{
	public function cus_user($table,$user)
	{
		$con = $this->setconnect();
		$query = 'SELECT COUNT(id) AS count_id  FROM '.$table.' WHERE '.$user;
		$result = mysqli_query($con,$query);
		$row = mysqli_fetch_assoc($result);
		return $row['count_id'];

	}

	public function cus_pass($pass)
	{

		$pass_md5 = md5($pass."Blue");

		return $pass_md5;

	}

	public function log_Admin($id_admin,$name_admin,$page,$management)
	{
		$con = $this->setconnect();
		$datetime = date("Y-m-d H:i:s");
		$sql = " INSERT INTO log_admin (id_admin,name_admin,page,management,date_time) VALUES ('".$id_admin."','".$name_admin."','".$page."','".$management."','".$datetime."');";
		$result = mysqli_query($con,$sql);
		if($result){
			$data['suc']=1;//สำเร็จ
		}else{
			$data['suc']=2;	//ไม่สำเร็จ
		}
		$data['sql']=$sql;

		return $data;
	}

	public function log_Admin2($id_admin,$name_admin,$page,$management)
	{
		$con = $this->setconnect();
		$datetime = date("Y-m-d H:i:s");
		$sql = " INSERT INTO wal_log_admin (id_admin,name_admin,page,management,date_time) VALUES ('".$id_admin."','".$name_admin."','".$page."','".$management."','".$datetime."');";
		$result = mysqli_query($con,$sql);
		if($result){
			$data['suc']=1;//สำเร็จ
		}else{
			$data['suc']=2;	//ไม่สำเร็จ
		}
		$data['sql']=$sql;

		return $data;
	}

}
?>