Class Mysql
Class which provides an interface to a MySQL database
-
MOC\Module\Database\Constant
-
MOC\Module\Database\Configuration
-
MOC\Module\Database\Driver
-
MOC\Module\Database\Driver\Mysql
Methods summary
public
|
#
__construct( )
Constructor which sets database system specific options
Constructor which sets database system specific options
|
public
boolean
|
#
Open( string $DSN, string $User, string $Password, null|string $Database = null )
Opens a MySQL database connection
Opens a MySQL database connection
Parameters
- $DSN
string $DSN
- $User
string $User
- $Password
string $Password
- $Database
null|string $Database
Returns
boolean
|
public
array|boolean
|
#
Execute( integer $FETCH_AS = self::RESULT_AS_ARRAY_ASSOC )
Executes a SQL query
Parameters
- $FETCH_AS
integer $FETCH_AS
Returns
array|boolean
|
protected
array
|
#
FetchAsArray( resource $Result )
Fetches a query result as an array
Fetches a query result as an array
Parameters
Returns
array
|
protected
array
|
#
FetchAsArrayAssoc( resource $Result )
Fetches a query result as an associative array
Fetches a query result as an associative array
Parameters
Returns
array
|
public
boolean
|
#
Close( )
Closes a database connection
Closes a database connection
Returns
boolean
|
public
|
|
public
|
#
TransactionCommit( )
Ends a Transaction with Commit
Ends a Transaction with Commit
Todo
Implement Commit
|
public
|
#
TransactionRollback( )
Ends a Transaction with Rollback
Ends a Transaction with Rollback
Todo
Implement Rollback
|