Module Database

Api

MOC\Api::Module()->Database()

• ->Driver( DRIVER_.. )

  • ->Open( Host, User, Password, Database )

  • ->Statement( SqlTemplate )

  • ->Parameter( Value, Identifier, PARAM_TYPE_.. )

  • ->Execute( RESULT_AS_.. )

  • ->Close()

  • ->[Driver-Methods]()

Driver

A driver is mainly used to unify the different database engines. It also adds additional methods specific to the database e.g. transactions

Supported Databases

Native:

MySql

Odbc:

MsSql Oracle

Usage

$Database = MOC\Api::Module()->Database();
$Database->Driver( $Database::DRIVER_MYSQL )->Open( '127.0.0.1', 'User', 'Password', 'Database' )
$Result = $Database->Statement( "SELECT * FROM Table WHERE Column = ?" )->Parameter( 'Value' )->Execute()
// Result: array( array( 'Column' => 'Value', 'Column' => 'Value', ... ), ... )