<?php

class db{
		//we may want to do more than connect via mysql;
		var $type="mysql";

		// mysql vars;
		var $db_link;
		var $hostname;
		var $schema;
		var $dbuser;
		var $dbpass;
		var $pconnect=false;

		var $showError=false;
		var $logError=true;
		var $stopOnError=true;
		var $errorFormat="xhtml";

		var $error = NULL;

		function db($connect = true, $hostname = NULL, $schema = NULL, $user = NULL, $pass = NULL, $pconnect = NULL, $type = "mysql"){

			if($type!="mysql")
			$this->type=$type;

			switch($this->type){
				default:
				case "mysql":
					if(defined("MYSQL_SERVER"))
						$this->hostname = MYSQL_SERVER;
					if($hostname!=NULL)
						$this->hostname = $hostname;

					if(defined("MYSQL_DATABASE"))
						$this->schema = MYSQL_DATABASE;
					if($schema!=NULL)
						$this->schema = $schema;

					if(defined("MYSQL_USER"))
						$this->dbuser = MYSQL_USER;
					if($schema!=NULL)
						$this->dbuser = $user;

					if(defined("MYSQL_USERPASS"))
						$this->dbpass = MYSQL_USERPASS;
					if($schema!=NULL)
						$this->dbpass = $pass;

					if(defined("MYSQL_PCONNECT"))
						$this->pconnect = MYSQL_PCONNECT;
					if($pconnect!=NULL)
						$this->pconnect = $pconnect;
				break;
			}

			if($connect){
				if($this->connect()){
					if($this->selectSchema())
						return $this->db_link;
					else
						return false;
				} else
					return false;
			} else return true;
		}//end function


		function connect(){
			// This functions connects to the database.  It uses pconnect if the variable is set;

			if($this->pconnect) {
				$this->db_link = @ mysql_pconnect($this->hostname,$this->dbuser,$this->dbpass);
			} else {
				$this->db_link = @ mysql_connect($this->hostname,$this->dbuser,$this->dbpass);
			}
			if(!$this->db_link){
				$error = new appError(-400,"Could not connect to database server.\n\n".mysql_error(),"",$this->showError,$this->stopOnError,false,$this->errorFormat);
				return false;
			} else
				return $this->db_link;
		}


		function selectSchema($schema=NULL){
			if($schema!=NULL)
				$this->schema=$schema;

			if(! @ mysql_select_db($this->schema,$this->db_link)){
				$error = new appError(-410,"Could not open schema ".$this->schema,"",$this->showError,$this->stopOnError,false,$this->errorFormat);
				return false;
			} else
				return true;
		}


		function query($sqlstatement){
			switch($this->type){
				case "mysql":
					if(!isset($this->db_link))
						if(!$this->dataB()) die($this->error);
					$queryresult=  @ mysql_query($sqlstatement,$this->db_link);
					if(!$queryresult){
						$this->error = mysql_error($this->db_link);
						$error = new appError(-420,mysql_error($this->db_link)."\n\nStatement: ".$sqlstatement,"",$this->showError,$this->stopOnError,$this->logError,$this->errorFormat);
						return false;
					}
				break;
			}//end case

			$this->error=NULL;
			return $queryresult;
		}//end function


		function setEncoding($encoding = "utf8"){
			switch($this->type){
				case "mysql":
					@ mysql_query("SET NAMES ".$encoding, $this->db_link);
					break;

			}//endswitch

		}//end method


		function numRows($queryresult){
			switch($this->type){
				case "mysql":
					$numrows=@ mysql_num_rows($queryresult);
					if(!is_numeric($numrows)){
						$error= new appError(-430,"","Could Not Retrieve Rows.","",$this->showError,$this->stopOnError,$this->logError,$this->errorFormat);
						return false;
					}
				break;
			}//end case
			$this->error=NULL;
			return $numrows;
		}//end function


		function fetchArray($queryresult){
			//Fetches associative array of current row
			switch($this->type){
				case "mysql":
					$row=@ mysql_fetch_assoc($queryresult);
				break;
			}//end case
			return $row;
		}//end function

		function freeResult($queryresult){
			//free result
			switch($this->type){
				case "mysql":
					$thereturn=@ mysql_free_result($queryresult);
				break;
			}//end case
			return $thereturn;
		}//end function

		function Close(){
			//free result
			switch($this->type){
				case "mysql":
					$thereturn=@ mysql_close($this->db_link);
				break;
			}//end case
			return $thereturn;
		}//end function

		function seek($queryresult,$rownum){
			switch($this->type){
				case "mysql":
					$thereturn=@ mysql_data_seek($queryresult,$rownum);
				break;
			}//end case
			return $thereturn;
		}//end function


		function numFields($queryresult){
			switch($this->type){
				case "mysql":
					$thereturn=@ mysql_num_fields($queryresult);
				break;
			}//end case
			return $thereturn;
		}//end function


		function fieldTable($queryresult,$offset){
			switch($this->type){
				case "mysql":
					$thereturn=@ mysql_field_table($queryresult,$offset);
				break;
			}//end case
			return $thereturn;
		}//end function


		function fieldName($queryresult,$offset){
			switch($this->type){
				case "mysql":
					$thereturn=@ mysql_field_name($queryresult,$offset);
				break;
			}//end case
			return $thereturn;
		}//end function


		function tableInfo($tablename){
			//this function returns a multi-dimensional array describing the fields in a given table
			$thereturn = false;
			switch($this->type){
				case "mysql":
					$queryresult = @ mysql_list_fields($this->schema,$tablename);
					if($queryresult){
						for($offset = 0; $offset < mysql_num_fields($queryresult); ++$offset){
							$name = $this->fieldName($queryresult,$offset);
							$thereturn[$name]["type"] = @ mysql_field_type($queryresult,$offset);
							$thereturn[$name]["length"] = mysql_field_len($queryresult,$offset);
							$thereturn[$name]["flags"] = mysql_field_flags($queryresult,$offset);
						}
					}
				break;
			}//end case
			return $thereturn;
		}


		function insertId(){
			$thereturn = false;
			switch($this->type){
				case "mysql":
					$thereturn = @ mysql_insert_id($this->db_link);
				break;
			}

			return $thereturn;
		}

		function affectedRows(){
			$thereturn = false;
			switch($this->type){
				case "mysql":
					$thereturn = @ mysql_affected_rows($this->db_link);
				break;
			}

			return $thereturn;
		}

}//end db class


$querystatement = "
		SELECT
			invoices.id,
			clients.name as clientname,
			subclients.name as subclientname,
			invoices.groupid
		FROM
			invoices
		LEFT JOIN clients ON clients.id = invoices.parentid
		LEFT JOIN subclients ON subclients.id = invoices.clientid and invoices.clienttype=1
		WHERE
			invoices.groupid='".$_POST["groupid"]."' or invoices.groupid='".(int)$_POST["groupid"]."'";

	$queryresult = $db->query($querystatement);
	if($db->numRows($queryresult)!=0){
		$therecord = $db->fetchArray($queryresult);
		echo "<center><h1 style=\"color: green;\">Pedido OK:</h1><br>
		".$therecord["clientname"]." <br>".$therecord["subclientname"]."
		<hr>";
	} else {
		echo "<center><h1 style=\"color: red;\">".$_POST["groupid"]." n existe</h1><br>";

	}


$db->close();
?>