webmaster@0: <?php
webmaster@0: class DataAccess {
webmaster@0:   var $host;
webmaster@0:   var $user;
webmaster@0:   var $pass;
webmaster@0:   var $db;
webmaster@54:   var $link;
webmaster@0:   var $connOpen;
webmaster@53:   var $results;
webmaster@53:   var $queries;
webmaster@0:   var $_nbQueries;
webmaster@0:   
webmaster@53:   function DataAccess($host=DB_HOST, $user=DB_USER, $pass=DB_PASSWORD, $db=DB_NAME) {
webmaster@0:    $this->host=$host;
webmaster@0:    $this->user=$user;
webmaster@0:    $this->pass=$pass;
webmaster@53:    $this->db = $db;
webmaster@53:    $this->connOpen = 0;
webmaster@0:    $this->_nbQueries = 0;
webmaster@53:    $this->queries = array();
webmaster@53:    $this->results = array();
webmaster@0:    $this->Connect();
webmaster@0:  }
webmaster@0:  
webmaster@53:   function Connect() {
webmaster@53:    if($this->connOpen == 0) {
webmaster@54:      $this->link = mysql_connect($this->host, $this->user, $this->pass);
webmaster@54:      mysql_select_db($this->db, $this->link);
webmaster@53:    }
webmaster@53:    $this->connOpen++;
webmaster@0:   }
webmaster@0:   
webmaster@0:   function Query($query, $id=0) {
webmaster@53:    $this->_nbQueries++;
webmaster@53:    $this->queries[$id]=$query;
webmaster@53:    $this->Connect();
webmaster@54:    $this->results[$id]=mysql_query($this->queries[$id], $this->link);
webmaster@53:    $this->Close();
webmaster@53:    if(@$num_rows=mysql_num_rows($this->results[$id]))
webmaster@0: 	return $num_rows;
webmaster@53:    return 0;
webmaster@0:   }
webmaster@0:   
webmaster@0:   function debugQuery($query, $id=0) {
webmaster@0:   $rv = $this->Query($query, $id);
webmaster@0:   if(mysql_errno() !== 0)
webmaster@0: 	echo("<span class='menu'>\n Query : {$query}<br />\n MySQL Answer : " . mysql_error() . "</span>");
webmaster@0:   return $rv;
webmaster@0:   }
webmaster@0:   
webmaster@0:   function GetRow($id=0) {
webmaster@53:    if(@$row=mysql_fetch_array($this->results[$id])) {
webmaster@0:     return $row;
webmaster@0:    }
webmaster@0:    return 0;    
webmaster@0:   }
webmaster@0:   
webmaster@0:   function Close() {
webmaster@53:    $this->connOpen--;
webmaster@53:    if($this->connOpen == 0) {
webmaster@54:     mysql_close($this->link);
webmaster@53:    }
webmaster@0:   }
webmaster@0:   
webmaster@0:   function getNbQueries() {
webmaster@0: 	return $this->_nbQueries;
webmaster@0:   }
webmaster@0:   
webmaster@0:   function formatDate($timestamp, $decallage=2, $pattern='d/m/Y H:i:s') {
webmaster@0:    return gmdate($pattern, $timestamp + $decallage * 3600);
webmaster@0:   }
webmaster@0: }
webmaster@0: ?>