The eZDB class provides database wrapper functions The eZ db library procides a database independent framework for SQL databases. The current supported databases are: PostgreSQL and MySQL. More...

Static Public Member Functions
static	checkTransactionCounter ()
static	hasInstance ()
static	instance ($databaseImplementation=false, $databaseParameters=false, $forceNewInstance=false)
	Returns a shared instance of the eZDBInterface class aka database object.
static	setErrorHandling ($errorHandling)
	Sets the default eZDB error handling mode.
static	setInstance ($instance)
Public Attributes
const	ERROR_HANDLING_EXCEPTIONS = 2
const	ERROR_HANDLING_STANDARD = 1
	Error handling mode.
Static Protected Attributes
static	$errorHandling = self::ERROR_HANDLING_STANDARD
Private Member Functions
	__construct ()

Detailed Description

The eZDB class provides database wrapper functions The eZ db library procides a database independent framework for SQL databases. The current supported databases are: PostgreSQL and MySQL.

eZ db is designed to be used with the following type subset of SQL: int, float, varchar and text.

To store date and time values int's are used. eZ locale is used to present the date and times on a localized format. That way we don't have to worry about the different date and time formats used in the different databases.

Auto incrementing numbers, sequences, are used to generate unique id's for a table row. This functionality is abstracted as it works different in the different databases.

Limit and offset functionality is also abstracted by the eZ db library.

eZ db is designed to use lowercase in all table/column names. This is done to prevent errors as the different databases handles this differently. Especially when returning the data as an associative array.

  // Get the current database instance
  // will create a new database object and connect to the database backend
  // if there is already created an instance for this session the existing
  // object will be returned.
  // the settings for the database connections are set in site.ini
  $db = eZDB::instance();

  // Run a simple query
  $db->query( 'DELETE FROM sql_test' );

  // insert some data
  $str = $db->escapeString( "Testing escaping'\"" );
  $db->query( "INSERT INTO sql_test ( name, description ) VALUES ( 'New test', '$str' )" );

  // Get the last serial value for the sql_test table
  $rowID = $db->lastSerialID( 'sql_test', 'id' );

  // fetch some data into an array of associative arrays
  $rows = $db->arrayQuery( 'SELECT * FROM sql_test' );

  foreach ( $rows as $row )
  {
     print( $row['name'] );
  }

  // fetch some data with a limit
  // will return the 10 first rows in the result
  $ret = $db->arrayQuery( 'SELECT id, name, description, rownum FROM sql_test',
                           array( 'offset' => 0, 'limit' => 10 ) );

  // check which implementation we're running
  print( $db->databaseName() );

See also:: eZLocale eZINI

Definition at line 79 of file ezdb.php.

Constructor & Destructor Documentation

eZDB::__construct ( ) [private]

Constructor. NOTE: Should not be used.

Definition at line 85 of file ezdb.php.

Member Function Documentation

static eZDB::checkTransactionCounter ( ) [static]

Checks transaction counter If the current transaction counter is 1 or higher means 1 or more transactions are running and a negative value means something is wrong. Prints the error.

Definition at line 293 of file ezdb.php.

Referenced by eZScript\shutdown().

static eZDB::hasInstance ( ) [static]

Returns an instance of the database object.

Definition at line 94 of file ezdb.php.

Referenced by eZDBCleanup(), and eZScript\shutdown().