Location: PHPKode > scripts > GafDb > gafdb/GafDb.inc.php
<?
class mydb{
	var $debug=0;
	var $host="teste.com.br";
	var $user="username";
	var $pass="passwrod";
	var $database="tablename";
	var $error;
	var $msgerror;
	var $ConId=NULL;
	var $recordcount=-1;
	
	var $MESSAGE["CONNECTIG"] = "Conectando...";
	var $MESSAGE["CONNECTED"] = "Conectado.";	
	var $MESSAGE["CONECTIONERROR"] = "Erro ao estabelecer a conexão com o Servidor";
	var $MESSAGE["DATABASEERROR"] = "Erro ao selecionar o database";
	var $MESSAGE["COMMANDERROR"] = "Erro no comando : ";			
	var $MESSAGE["QUERYERROR"] = "Erro na consulta : ";
					

	function GafDb( $host , $user , $pass , $database ){
	$this->host = $host;
	$this->user = $user;
	$this->pass = $pass;
	$this->database = $database;
				
	if ($this->debug<>0) echo $MESSAGE["CONNECTIG"];  // debug
		$con=mysql_connect($this->host ,$this->user ,$this->pass );
		if(!$con){ 
			$this->error = mysql_error();
			$this->msgerror = $MESSAGE["CONECTIONERROR"] ;				
			if ($this->debug<>0) mysql_error();  // debug
		} 
		else{
			$database = mysql_select_db($this->database,$con);
			if(!$database){ 
				$this->error = mysql_error();
				$this->msgerror = $MESSAGE["DATABASEERROR"] ;								
				if ($this->debug<>0) mysql_error();// debug			
			}
			else{
				$this->ConId = $con;		
			}
		}	
 	if ($this->debug<>0) echo $MESSAGE["CONNECTED"] ;  // debug
	if ($this->error>0) echo $this->msgerror; 
	} // final da função connect



   # executa uma consulta a base de dados MySQL ################################################ Revisão 26/08/2002 #
   function select( $sql ) {
   
		if (preg_match("/delete/i", $sql)) { Exit; } 
		if (preg_match("/update/i", $sql)) { Exit; } 
		if (preg_match("/insert/i", $sql)) { Exit; } 
		
		
   			
			$res = @mysql_query($sql, $this->ConId );
			if(!$res){
				echo  $MESSAGE["QUERYERROR"] . mysql_error();
				$this->msgerror = mysql_error();
			}
			else{
				$this->recordcount = mysql_num_rows($res);
				return $res;
			}

   }

		
	
	
	
	   # executa um comando em uma base de dadosMySQL ################################################ Revisão 26/08/2002 #
   function Execute( $sql ) {
			$res = @mysql_query($sql, $this->ConId );
			if(!$res){
				echo $MESSAGE["COMMANDERROR"] . mysql_error();
				$this->msgerror = mysql_error();
			}
			else{
				$this->recordcount = 0;
				return $res;
			}

   }

	
	


}// final da classe


?>
Return current item: GafDb