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@68:   var $_inError;
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;
franck@81:    $this->_inError = false;
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) {
franck@81:      $this->link = mysqli_connect($this->host, $this->user, $this->pass, $this->db);
webmaster@68:      if($this->link === false)
franck@81:        $this->_inError = true;
webmaster@68:      else
franck@81:        mysqli_set_charset($this->link, 'utf8');
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();
franck@81:    $this->results[$id]=mysqli_query($this->link, $this->queries[$id]);
webmaster@53:    $this->Close();
franck@81:    if(@$num_rows=mysqli_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) {
franck@83:     $rv = $this->Query($query, $id);
franck@83:     if(mysqli_errno($this->link) !== 0)
franck@83:   	echo("<span class='menu'>\n Query : {$query}<br />\n MySQL Answer : " . mysql_error() . "</span>");
franck@83:     return $rv;
webmaster@0:   }
webmaster@0:   
webmaster@0:   function GetRow($id=0) {
franck@81:    if(@$row=mysqli_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) {
franck@81:     mysqli_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:   }
franck@87: 
franck@87:   function escapeString($string) {
franck@87:     return mysqli_escape_string($this->link, $string);
franck@87:   }
webmaster@68:   
webmaster@68:   function isInError()
webmaster@68:   {
webmaster@68:     return $this->_inError;
webmaster@68:   }
webmaster@0: }
webmaster@0: ?>