MDB2
[ class tree: MDB2 ] [ index: MDB2 ] [ all elements ]
Packages:
MDB2
apidoc


Classes:
MDB2
MDB2_BufferedIterator
MDB2_Date
MDB2_Driver_Common
MDB2_Driver_Datatype_Common
MDB2_Driver_Function_Common
MDB2_Driver_Manager_Common
MDB2_Driver_Native_Common
MDB2_Driver_Reverse_Common
MDB2_Error
MDB2_Extended
MDB2_Iterator
MDB2_LOB
MDB2_Module_Common
MDB2_Result
MDB2_Result_Common
MDB2_Row
MDB2_Statement_Common
Files:
Common.php
Common.php
Common.php
Common.php
Common.php
Date.php
example.php
Extended.php
Iterator.php
LOB.php
MDB2.php

Class: MDB2

Source Location: /MDB2-2.5.0b1/MDB2.php

Class Overview




The main 'MDB2' class is simply a container class with some static  methods for creating DB objects as well as some utility functions  common to all parts of DB.




Author(s):






    







Methods
















Inherited Variables





Inherited Methods














Class Details



[line 267]

The main 'MDB2' class is simply a container class with some static  methods for creating DB objects as well as some utility functions  common to all parts of DB.
The object model of MDB2 is as follows (indentation means inheritance):
MDB2          The main MDB2 class.  This is simply a utility class               with some 'static' methods for creating MDB2 objects as               well as common utility functions for other MDB2 classes.
MDB2_Driver_Common   The base for each MDB2 implementation.  Provides default  |            implementations (in OO lingo virtual methods) for  |            the actual DB implementations as well as a bunch of  |            query utility functions.  |  +-MDB2_Driver_mysql  The MDB2 implementation for MySQL. Inherits MDB2_Driver_Common.               When calling MDB2::factory or MDB2::connect for MySQL               connections, the object returned is an instance of this               class.  +-MDB2_Driver_pgsql  The MDB2 implementation for PostGreSQL. Inherits MDB2_Driver_Common.               When calling MDB2::factory or MDB2::connect for PostGreSQL               connections, the object returned is an instance of this               class.









[ Top ]








Method Detail



	
	
apiVersion   [line 567]

	

    

    

		string apiVersion(
)
    

    


	
		Return the MDB2 API version


    

  • Return: the MDB2 API version number
    • 

  • Access: public
    • 








        
[ Top ]

  

  
  
	
	
areEquals   [line 518]

	

    

    

		boolean areEquals(
array
$arr1, array
$arr2)
    

    


	
		It looks like there's a memory leak in array_diff() in PHP 5.1.x,  so use this method instead.








        
Parameters:

    

    

          

        array  
        $arr1  
        — 
        
      

          

        array  
        $arr2  
        — 
        
      

        

    


        
[ Top ]

  

  
  
	
	
classExists   [line 306]

	

    

    

		bool classExists(
string
$classname)
    

    


	
		Checks if a class exists without triggering __autoload


    

  • Return: true success and false on error
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $classname  
        — 
        classname
      

        

    


        
[ Top ]

  

  
  
	
	
connect   [line 433]

	

    

    

		mixed &connect(
mixed
$dsn, [array
$options = false])
    

    


	
		Create a new MDB2 connection object and connect to the specified  database
IMPORTANT: In order for MDB2 to work properly it is necessary that  you make sure that you work with a reference of the original  object instead of a copy (this is a PHP4 quirk).
For example:      $db =& MDB2::connect($dsn);           ^^  And not:      $db = MDB2::connect($dsn);           ^^


    

  • Return: a newly created MDB2 connection object, or a MDB2                   error object on error
    • 

  • See: MDB2::parseDSN
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        mixed  
        $dsn  
        — 
        'data source name', see the MDB2::parseDSN                             method for a description of the dsn format.                             Can also be specified as an array of the                             format returned by MDB2::parseDSN.
      

          

        array  
        $options  
        — 
        An associative array of option names and                             their values.
      

        

    


        
[ Top ]

  

  
  
	
	
errorMessage   [line 725]

	

    

    

		string errorMessage(
[int|array
$value = null])
    

    


	
		Return a textual error message for a MDB2 error code


    

  • Return: error message, or false if the error code was                   not recognized
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        int|array  
        $value  
        — 
        integer error code,
      

        

    


        
[ Top ]

  

  
  
	
	
factory   [line 376]

	

    

    

		mixed &factory(
mixed
$dsn, [array
$options = false])
    

    


	
		Create a new MDB2 object for the specified database type
IMPORTANT: In order for MDB2 to work properly it is necessary that  you make sure that you work with a reference of the original  object instead of a copy (this is a PHP4 quirk).
For example:      $db =& MDB2::factory($dsn);           ^^  And not:      $db = MDB2::factory($dsn);


    

  • Return: a newly created MDB2 object, or false on error
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        mixed  
        $dsn  
        — 
        'data source name', see the MDB2::parseDSN                       method for a description of the dsn format.                       Can also be specified as an array of the                       format returned by MDB2::parseDSN.
      

          

        array  
        $options  
        — 
        An associative array of option names and                             their values.
      

        

    


        
[ Top ]

  

  
  
	
	
fileExists   [line 955]

	

    

    

		bool fileExists(
string
$file)
    

    


	
		Checks if a file exists in the include path


    

  • Return: true success and false on error
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $file  
        — 
        filename
      

        

    


        
[ Top ]

  

  
  
	
	
isConnection   [line 654]

	

    

    

		bool isConnection(
mixed
$value)
    

    


	
		Tell whether a value is a MDB2 connection


    

  • Return: whether $value is a MDB2 connection
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        mixed  
        $value  
        — 
        value to test
      

        

    


        
[ Top ]

  

  
  
	
	
isError   [line 627]

	

    

    

		bool isError(
mixed
$data, [int
$code = null])
    

    


	
		Tell whether a value is a MDB2 error.


    

  • Return: true if parameter is an error
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        mixed  
        $data  
        — 
        the value to test
      

          

        int  
        $code  
        — 
        if is an error object, return true                         only if $code is a string and                         $db->getMessage() == $code or                         $code is an integer and $db->getCode() == $code
      

        

    


        
[ Top ]

  

  
  
	
	
isResult   [line 671]

	

    

    

		bool isResult(
mixed
$value)
    

    


	
		Tell whether a value is a MDB2 result


    

  • Return: whether $value is a MDB2 result
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        mixed  
        $value  
        — 
        value to test
      

        

    


        
[ Top ]

  

  
  
	
	
isResultCommon   [line 688]

	

    

    

		bool isResultCommon(
mixed
$value)
    

    


	
		Tell whether a value is a MDB2 result implementing the common interface


    

  • Return: whether $value is a MDB2 result implementing the common interface
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        mixed  
        $value  
        — 
        value to test
      

        

    


        
[ Top ]

  

  
  
	
	
isStatement   [line 705]

	

    

    

		bool isStatement(
mixed
$value)
    

    


	
		Tell whether a value is a MDB2 statement interface


    

  • Return: whether $value is a MDB2 statement interface
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        mixed  
        $value  
        — 
        value to test
      

        

    


        
[ Top ]

  

  
  
	
	
loadClass   [line 327]

	

    

    

		mixed loadClass(
string
$class_name, bool
$debug)
    

    


	
		Loads a PEAR class.


    

  • Return: true success or PEAR_Error on failure
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $class_name  
        — 
        classname to load
      

          

        bool  
        $debug  
        — 
        if errors should be suppressed
      

        

    


        
[ Top ]

  

  
  
	
	
loadFile   [line 543]

	

    

    

		string loadFile(
string
$file)
    

    


	
		load a file (like 'Date')


    

  • Return: name of the file that was included
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $file  
        — 
        name of the file in the MDB2 directory (without '.php')
      

        

    


        
[ Top ]

  

  
  
	
	
parseDSN   [line 825]

	

    

    

		array parseDSN(
string
$dsn)
    

    


	
		Parse a data source name.
Additional keys can be added by appending a URI query string to the  end of the DSN.
The format of the supplied DSN is in its fullest form:  
  1.   phptype(dbsyntax)://username:password@protocol+hostspec/database?option=8&another=true
    2. 

Most variations are allowed:  
  1.   phptype://username:password@protocol+hostspec:110//usr/db_file.db?mode=0644
    2. 

  2.   phptype://username:password@hostspec/database_name
    3. 

  3.   phptype://username:password@hostspec
    4. 

  4.   phptype://username@hostspec
    5. 

  5.   phptype://hostspec/database
    6. 

  6.   phptype://hostspec
    7. 

  7.   phptype(dbsyntax)
    8. 

  8.   phptype
    9. 



    

  • Return: an associative array with the following keys: 
    • phptype:  Database backend used in PHP (mysql, odbc etc.)
    • dbsyntax: Database used with regards to SQL syntax etc.
    • protocol: Communication protocol to use (tcp, unix etc.)
    • hostspec: Host specification (hostname[:port])
    • database: Database to use on the DBMS server
    • username: User name for login
    • password: Password for login
    • 

  • Author: Tomas V.V.Cox <cox@idecnet.com>
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        string  
        $dsn  
        — 
        Data Source Name to be parsed
      

        

    


        
[ Top ]

  

  
  
	
	
setOptions   [line 281]

	

    

    

		mixed setOptions(
MDB2_Driver_Common
&$db, array
$options)
    

    


	
		set option array   in an exiting database object


    

  • Return: MDB2_OK or a PEAR Error object
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        MDB2_Driver_Common  
        &$db  
        — 
        MDB2 object
      

          

        array  
        $options  
        — 
        An associative array of option names and their values.
      

        

    


        
[ Top ]

  

  
  
	
	
singleton   [line 483]

	

    

    

		mixed &singleton(
[mixed
$dsn = null], [array
$options = false])
    

    


	
		Returns a MDB2 connection with the requested DSN.
A new MDB2 connection object is only created if no object with the  requested DSN exists yet.
IMPORTANT: In order for MDB2 to work properly it is necessary that  you make sure that you work with a reference of the original  object instead of a copy (this is a PHP4 quirk).
For example:      $db =& MDB2::singleton($dsn);           ^^  And not:      $db = MDB2::singleton($dsn);           ^^


    

  • Return: a newly created MDB2 connection object, or a MDB2                   error object on error
    • 

  • See: MDB2::parseDSN
    • 

  • Access: public
    • 








        
Parameters:

    

    

          

        mixed  
        $dsn  
        — 
        'data source name', see the MDB2::parseDSN                             method for a description of the dsn format.                             Can also be specified as an array of the                             format returned by MDB2::parseDSN.
      

          

        array  
        $options  
        — 
        An associative array of option names and                             their values.
      

        

    


        
[ Top ]

  

  
  



        

		    

		    Documentation generated on Mon, 11 Mar 2019 15:17:17 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright ©  PHP Group 2004.