Mercurial > defr > DualBlog

annotate includes/class.dataaccess.php @ 29:750613da68ec

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Ajout d'un fallback en cas d'absence de TreeWalker. Ca devrait permettre de faire fonctionner l'administration dans la plupart des navigateurs (modulo la vérification de validité XML éventuellement).
author Franck Deroche <webmaster@defr.org>
date Thu, 01 Nov 2007 17:44:43 +0100
parents e4e880f786d4
children ec0c926a78a6
rev   line source
webmaster@0 1 <?php
webmaster@0 2 class DataAccess {
webmaster@0 3 var $host;
webmaster@0 4 var $user;
webmaster@0 5 var $pass;
webmaster@0 6 var $db;
webmaster@0 7 var $arResult;
webmaster@0 8 var $query;
webmaster@0 9 var $connOpen;
webmaster@0 10 var $_nbQueries;
webmaster@0 11
webmaster@0 12 var $infos; // Cache contenant les informations sur le visiteur
webmaster@0 13
webmaster@7 14 function DataAccess($host=DB_HOST, $user=DB_USER, $pass=DB_PASSWORD) {
webmaster@0 15 $this->host=$host;
webmaster@0 16 $this->user=$user;
webmaster@0 17 $this->pass=$pass;
webmaster@0 18 $this->_nbQueries = 0;
webmaster@0 19 $this->Connect();
webmaster@0 20 }
webmaster@0 21
webmaster@0 22 function Connect($db=DB_NAME) {
webmaster@0 23 if($this->connOpen == 1) return;
webmaster@0 24 $this->db=$db;
webmaster@0 25 $this->connOpen=1;
webmaster@0 26 mysql_connect($this->host, $this->user, $this->pass);
webmaster@0 27 mysql_select_db($this->db);
webmaster@0 28 }
webmaster@0 29
webmaster@0 30 function Query($query, $id=0) {
webmaster@0 31 $this->query=$query;
webmaster@0 32 if($this->connOpen != 1) $this->Connect();
webmaster@0 33 $this->arResult[$id]=mysql_query($this->query);
webmaster@0 34 if($this->connOpen != 1) $this->Close();
webmaster@0 35 if(@$num_rows=mysql_num_rows($this->arResult[$id]))
webmaster@0 36 return $num_rows;
webmaster@0 37 else
webmaster@0 38 return 0;
webmaster@0 39 }
webmaster@0 40
webmaster@0 41 function debugQuery($query, $id=0) {
webmaster@0 42 $rv = $this->Query($query, $id);
webmaster@0 43 if(mysql_errno() !== 0)
webmaster@0 44 echo("<span class='menu'>\n Query : {$query}<br />\n MySQL Answer : " . mysql_error() . "</span>");
webmaster@0 45 return $rv;
webmaster@0 46 }
webmaster@0 47
webmaster@0 48 function GetRow($id=0) {
webmaster@0 49 if(@$row=mysql_fetch_assoc($this->arResult[$id])) {
webmaster@0 50 foreach($row as $key => $value)
webmaster@0 51 $row_utf[$key]=$this->utf8_ensure($value);
webmaster@0 52 return $row_utf;
webmaster@0 53 }
webmaster@0 54 return 0;
webmaster@0 55 }
webmaster@0 56
webmaster@0 57 function GetRawRow($id=0) {
webmaster@0 58 if(@$row=mysql_fetch_array($this->arResult[$id])) {
webmaster@0 59 return $row;
webmaster@0 60 }
webmaster@0 61 return 0;
webmaster@0 62 }
webmaster@0 63
webmaster@0 64 function Close() {
webmaster@0 65 $this->connOpen=0;
webmaster@0 66 mysql_close();
webmaster@0 67 }
webmaster@0 68
webmaster@0 69 function getNbQueries() {
webmaster@0 70 return $this->_nbQueries;
webmaster@0 71 }
webmaster@0 72
webmaster@0 73 function formatDate($timestamp, $decallage=2, $pattern='d/m/Y H:i:s') {
webmaster@0 74 return gmdate($pattern, $timestamp + $decallage * 3600);
webmaster@0 75 }
webmaster@0 76
webmaster@0 77 function seems_utf8($Str) {
webmaster@0 78 for ($i=0; $i<strlen($Str)/10 || $i < 100; $i++) {
webmaster@0 79 if (ord($Str[$i]) < 0x80) continue; # 0bbbbbbb
webmaster@0 80 elseif ((ord($Str[$i]) & 0xE0) == 0xC0) $n=1; # 110bbbbb
webmaster@0 81 elseif ((ord($Str[$i]) & 0xF0) == 0xE0) $n=2; # 1110bbbb
webmaster@0 82 elseif ((ord($Str[$i]) & 0xF8) == 0xF0) $n=3; # 11110bbb
webmaster@0 83 elseif ((ord($Str[$i]) & 0xFC) == 0xF8) $n=4; # 111110bb
webmaster@0 84 elseif ((ord($Str[$i]) & 0xFE) == 0xFC) $n=5; # 1111110b
webmaster@0 85 else return false; # Does not match any model
webmaster@0 86 for ($j=0; $j<$n; $j++) { # n bytes matching 10bbbbbb follow ?
webmaster@0 87 if ((++$i == strlen($Str)) || ((ord($Str[$i]) & 0xC0) != 0x80))
webmaster@0 88 return false;
webmaster@0 89 }
webmaster@0 90 }
webmaster@0 91 return true;
webmaster@0 92 }
webmaster@0 93
webmaster@0 94 function utf8_ensure($Str) {
webmaster@0 95 return $this->seems_utf8($Str)?$Str:utf8_encode($Str);
webmaster@0 96 }
webmaster@0 97
webmaster@0 98 }
webmaster@0 99 ?>