<?php

class connect {
	
	public $rdbms      = DB_RDBMS;
    // Database Host Address/IP
    public $dbhost     = DB_HOST;
    // Database Name
    public $dbname     = DB_NAME;
    // Database User Name
    public $dbuser     = DB_USER;
    // Database Password
    public $dbpass     = DB_PASS;

	public $connect;/////// PHP7 ////////

	public function __construct (){//PHP7
		// connect server
			
		$this->connect = mysql_connectx($this->dbhost, $this->dbuser, $this->dbpass);
		// connect database
		mysql_select_dbx($this -> dbname, $this->connect);
		mysql_queryx("SET NAMES UTF8");

		if(!$this->connect)
		{
			echo "<h3>ERROR : ไม่สามารถติดต่อฐานข้อมูลได้</h3>";
			exit();
		}
			
	} //End connect


	function execute($sql){
			$result = mysql_queryx($sql)or die(mysql_error());
			return $result;
	}//End query
	
	function fecth($result){
			return mysql_fetch_arrayx($result);
	}//End fecth
	
	function numRows($result = NULL){
			return mysql_num_rowsx($result);
	}//End numRows
	
	function maxDB($field,$table){
			$sql = sprintf("select max(%s) from %s",$field,$table);
            $result = mysql_queryx($sql)or die(mysql_error());
			$max = mysql_result($result,0);
			return $max;
	     
	}//End maxDB
	
	function minDB($field,$table){
			$sql = sprintf("select min(%s) from %s",$field,$table);
            $result = mysql_queryx($sql)or die(mysql_error());
			$min = mysql_result($result,0);
			return $min;
	     
	}//End minDB
	
	function get_memID($email){
			$sql ="SELECT * FROM aq_member where email='$email'"; 
	 		$result = mysql_queryx($sql)or die(mysql_error());
			$rsmem = mysql_fetch_arrayx($result);;
			$mem_id =$rsmem["mem_id"];
			
			return $mem_id;
	     
	}//End minDB	

	function lastInsertedId()
    {
      return mysql_insert_idx();
    }

	function disconnect(){
		    mysql_closex($connect);
	}//End disconnect
	
	/////// PHP7 ////////
	function mysql_connectx($ServerName, $User, $Password)
	{
		if( function_exists('mysql_connect') )
			return mysql_connect($this->dbhost, $this->dbuser, $this->dbpass) or die (mysql_error());
		else
			return mysqli_connect($this->dbhost, $this->dbuser, $this->dbpass, $this->dbname) or die (mysqli_error());
	}
	
	function mysql_select_dbx($dbname, $cn)
	{
		if( function_exists('mysql_select_db') )
			return mysql_select_db($dbname, $cn);	
		else
			return true;
	}
	
	function mysql_queryx($query)
	{
		if( function_exists('mysql_query') )
			return mysql_query($query);
		else
			return mysqli_query($this->connect, $query);
	}	
	
	function mysql_fetch_arrayx($result)
	{
		if( function_exists('mysql_fetch_array') )
			return mysql_fetch_array($result);
		else
			return mysqli_fetch_array($result);
	}

	function mysql_num_rowsx($result)
	{
		if( function_exists('mysql_num_rows') )
			return mysql_num_rows($result);
		else
			return mysqli_num_rows($result);
	}

	function mysql_insert_idx()
	{
		if( function_exists('mysql_insert_id') )
			return mysql_insert_id();
		else
			return mysqli_insert_id($this->connect);
	}

	function mysql_closex($conn)
	{
		if( function_exists('mysql_close') )
			return mysql_close($conn);
		else
			return mysqli_close($conn);
	}
	
	function mysql_real_escape_stringx($value)
	{
		$value = str_replace(' ', '', $value);

		if( function_exists('mysql_real_escape_string') )
			return mysql_real_escape_string($value);
		else
			return mysqli_real_escape_string($this->connect, $value);
	}
	/////// PHP7 ////////	

} //End Class DB	
	
	


?>