sybaseConnection.php

Go to the documentation of this file.

<?php

/**
 * Sybase ASE database connection class
 *
 * @package objSQL
 * @version 2.1.0
 * @author MT Jordan <mtjo62@gmail.com>
 * @link http://objsql.sourceforge.net
 * @copyright 2004-2010 openSource Partners
 * @license LGPL
 * @revision $Id: sybaseConnection.php,v 1.7 2008-01-30 21:37:20-05 mt_jordan Exp $
 */

class sybaseConnection
{
   /**********************************************
    * Internal variables
    *********************************************/

   /**
     * Database connection object
     *
     * @access private
     * @var    mixed
     */
    private $objConnection;

   /**
     * Database connection information
     *
     * @access private
     * @var    array
     */
    private $objDatasource;

    /**********************************************
     * Class methods
     *********************************************/

    /**
     * Constructor
     *
     * @access public
     * @param  array $datasource
     */
    public function __construct( $datasource )
    {
        $this->objDatasource    = $datasource;
        $this->objDatasource[5] = ( array_key_exists( 5, $this->objDatasource ) && $this->objDatasource[5] ) ? true : false;
    }

    /**
     * Connect to database server
     *
     * @access public
     * @return mixed
     */
    public function objDbConnection()
    {
        //set higher levels to counteract random connection errors
        //php_sybase_ct.dll/server/PHP5 bug?
        sybase_min_client_severity( 100 );
        sybase_min_server_severity( 100 );

        $this->objConnection = ( $this->objDatasource[5] ) ? sybase_pconnect( $this->objDatasource[1], $this->objDatasource[2], $this->objDatasource[3] )
                                                           : sybase_connect( $this->objDatasource[1], $this->objDatasource[2], $this->objDatasource[3] );

        if ( $this->objConnection )
            //this may or may not be ignored - database is coupled with schema/server/user/pass
            sybase_select_db( $this->objDatasource[4], $this->objConnection );
        else
            trigger_error( sybase_get_last_message(), E_USER_WARNING );

        return $this->objConnection;
    }

    /**
     * Close connection to database server
     *
     * @access public
     * @return bool
     */
    public function objDbClose()
    {
        return sybase_close( $this->objConnection );
    }

    /**
     * Return info on database server
     *
     * @access public
     * @return str
     */
    public function objServerVersion()
    {
        $objStmt   = sybase_query( 'SELECT @@VERSION' );
        $objResult = sybase_fetch_row( $objStmt );
        sybase_free_result( $objStmt );

        return $objResult[0];
    }
}

?>