/usr/local/miolo2/classes/database/oracle8/mconnection.class

Go to the documentation of this file.

<?php
class Oracle8Connection extends MConnection
{
    var $executemode = OCI_COMMIT_ON_SUCCESS;

    function __construct($conf)
    {
        parent::__construct($conf);
    }

    function _connect($dbhost, $LoginDB, $LoginUID, $LoginPWD, $persistent = true)
    {
        if ($persistent)
        {
            $this->id = OCIPLogon($LoginUID, $LoginPWD, $LoginDB);
        }
        else
        {
            $this->id = OCILogon($LoginUID, $LoginPWD, $LoginDB);
        }
    }

    function _close()
    {
        OCILogOff ($this->id);
    }

    function _error($resource = null)
    {
        $err = oci_error($resource ? $resource : $this->id);
        return ($err ? $err['message'] : false);
    }

    function _parse($sql)
    {
        $statement = oci_parse($this->id, $sql);
        return $statement;
    }

    function _bind($stmt, $ph, $pv)
    {
        ocibindbyname($stmt, $ph, $pv);
    }

    function _execute($sql)
    {
        if ($statement = oci_parse($this->id, $sql))
        {
            if ($success = oci_execute($statement, $this->executemode))
            {
                $this->affectedrows = oci_num_rows($statement);
                oci_free_statement ($statement);
            }
            else
            {
                $this->traceback[] = $this->_error($statement);
            }
        }
        else
        {
            $this->traceback[] = $this->_error();
        }

        return $success;
    }

    function _createquery()
    {
        return new Oracle8Query();
    }

    function _chartotimestamp($timestamp, $format='DD/MM/YYYY HH24:MI:SS')
    {
        return ":TO_DATE('" . $timestamp . "','$format') ";
    }

    function _chartodate($date, $format='DD/MM/YYYY')
    {
        return ":TO_DATE('" . $date . "','$format') ";
    }

    function _timestamptochar($timestamp, $format='DD/MM/YYYY HH24:MI:SS')
    {
        return "TO_CHAR($timestamp,'$format') ";
    }

    function _datetochar($date, $format='DD/MM/YYYY')
    {
        return "TO_CHAR($date,'$format') ";
    }
}
?>

CopyLeft (L) 2001-2006 - [MIOLO Development Team] SOLIS - Cooperativa de Soluções Livres - Lajeado/RS - Brasil