abstract_sgbd.php

<?php
/*
This file is part of Mkframework.

Mkframework is free software: you can redistribute it and/or modify
it under the terms of the GNU Lesser General Public License as published by
the Free Software Foundation, either version 3 of the License.

Mkframework is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU Lesser General Public License for more details.

You should have received a copy of the GNU Lesser General Public License
along with Mkframework.  If not, see <http://www.gnu.org/licenses/>.

*/
abstract class abstract_sgbd{

    protected $_tConfig;
    protected $_sConfig;
    protected $_sClassRow;
    protected $_pDb;
    protected $_sReq;
    protected $_tId;
    
    private static $_tInstance=array();
    
    protected static function _getInstance($class,$sConfig) {
        if ( !isset(self::$_tInstance[$class][$sConfig]) ){
            $oSgbd = new $class();
            $oSgbd->chooseConfig($sConfig);
            self::$_tInstance[$class][$sConfig]=$oSgbd;
            
        }
        return self::$_tInstance[$class][$sConfig];
    }
    
    public function setClassRow($sClassRow){
        $this->_sClassRow=$sClassRow;
    }
    public function chooseConfig($sConfig){
        $this->_sConfig=$sConfig;
    }
    public function setConfig($tConfig){
        $this->_tConfig=$tConfig;
    }
    public function getRequete(){
        return $this->_sReq;
    }
    public function bind($tReq){
        $sReq='';
        
        if(is_array($tReq)){
            $sReq=$tReq[0];
            if(isset($tReq[1]) and is_array($tReq[1])){
                $tParam=$tReq[1];
            }else{
                unset($tReq[0]);
                $tParam=array_values($tReq);
            }
            
            foreach($tParam as $sVal){
                $sVal=$this->quote($sVal);
                $sReq=preg_replace('/[?]/',$sVal,$sReq,1);
            }
        }else{
            return $tReq;
        }
            
        return $sReq;
    }
    
    public function getInsertFromTab($tProperty){
        
        $sCols='';
        $sVals='';
        
        if($tProperty){
            foreach($tProperty as $sVar => $sVal){
                $sCols.=$sVar.',';
                $sVals.=$this->quote($sVal).',';
            }
        }
        return '('.substr($sCols,0,-1).') VALUES ('.substr($sVals,0,-1).') ';
    }
    public function getUpdateFromTab($tProperty){
        $sReq='';
        if($tProperty){
            foreach($tProperty as $sVar => $sVal){
                $sReq.=$sVar.'='.$this->quote($sVal).',';
            }
        }
        return substr($sReq,0,-1);
    }
    public function setId($tId){
        $this->_tId=$tId;
    }
    public function getWhereFromTab($tId){
        $sWhere='';
        if(is_array($tId)){
            foreach($tId as $sVar => $sVal){
                if($sWhere!=''){ $sWhere.=' AND '; }
                $sWhere.=$sVar.'='.$this->quote($sVal);
            }
        }
        
        return $sWhere;
    }
    public function erreur($sErreur){
        throw new Exception($sErreur);
    }
    
}