Connexio.php

<?php

class Connexio {
    
    private $usr;
    private $pwd;
    private $ip;
    
    public function __construct($usr='pau',$pwd='pau',$ip='localhost')  				  
    {
          $this->ip = $ip;
          $this->usr = $usr;
          $this->pwd = $pwd;
          
          $this->connectar();
          $this->selectdb("socialtravel");
    }
    
    // Realitzem la connexio a la base de dades
    function connectar(){
        if( mysql_set_charset('utf8', mysql_connect($this->ip,$this->usr,$this->pwd)) ) return true;
	  return false;    
    }
    // Seleccionem la Base de dades
    function selectdb($bd)  
    {   
        if( mysql_select_db($bd) ) return true;
        return false;
    }
    // Consulta SQL
    function query($query) 
    { 
        $result = mysql_query($query); 
        if (!$result) { 
            echo 'Could not run query: ' . mysql_error(); 
            exit; 
        } 
        return $result;
    } 
}

?>