mconnection.class

Ir para a documentação deste ficheiro.

<?php
class MysqlConnection extends MConnection
{
    function __construct($conf)
    {
        parent::__construct($conf);
    }
 
    function _connect($dbhost, $LoginDB, $LoginUID, $LoginPWD, $persistent = true, $port='')
    {
        $this->id = mysqli_connect($dbhost, $LoginUID, $LoginPWD, $LoginDB, $port);
        mysqli_select_db($this->id, $LoginDB);
    }
 
    function _close()
    {
        mysqli_close($this->id);
    }
 
    function _begintransaction()
    {
        $this->_execute("begin transaction");
    }
 
    function _commit()
    {
        $this->_execute("commit");
    }
 
    function _rollback()
    {
        $this->_execute("rollback");
    }
 
    function _error()
    {
        return mysqli_error($this->id);
    }
 
    function _execute($sql)
    {
        $rs = mysqli_query($this->id, $sql);
        $success = false;
 
        if ($rs)
        {
            $success = true;
            mysqli_free_result ($rs);
        }
        else
        {
            $this->traceback[] = $this->GetError();
        }
 
        return $success;
    }
 
    function _createquery()
    {
        return new MysqlQuery();
    }
 
    function _chartotimestamp($timestamp)
    {
        return " TO_DATE(" . $timestamp . ",'DD/MM/YYYY HH24:MI:SS') ";
    }
 
    function _chartodate($date)
    {
        return " TO_DATE(" . $date . ",'DD/MM/YYYY') ";
    }
 
    function _timestamptochar($timestamp)
    {
        return " TO_CHAR(" . $timestamp . ",'DD/MM/YYYY HH24:MI:SS') ";
    }
 
    function _datetochar($date)
    {
        return " TO_CHAR(" . $date . ",'DD/MM/YYYY') ";
    }
 
    function _sqljoin(&$sql, $table1, $table2, $cond)
    {
        if ($sql->join)
        {
            $sql->join = "($sql->join INNER JOIN $table2 ON ($cond))";
        }
        else
        {
            $sql->join = "($table1 INNER JOIN $table2 ON ($cond))";
        }
    }
 
    function _sqlleftjoin(&$sql, $table1, $table2, $cond)
    {
        if ($sql->join)
        {
            $sql->join = "($sql->join LEFT JOIN $table2 ON ($cond))";
        }
        else
        {
            $sql->join = "($table1 LEFT JOIN $table2 ON ($cond))";
        }
    }
 
    function _sqlrightjoin(&$sql, $table1, $table2, $cond)
    {
        if ($sql->join)
        {
            $sql->join = "($sql->join RIGHT JOIN $table2 ON ($cond))";
        }
        else
        {
            $sql->join = "($table1 RIGHT JOIN $table2 ON ($cond))";
        }
    }
}
?>