Overview

Namespaces

  • MOC
    • Adapter
    • Core
      • Changelog
      • Depending
      • Drive
        • Directory
        • File
      • Error
        • Register
        • Type
      • Journal
      • Proxy
      • Template
      • Xml
    • Extension
      • Excel
      • Flot
      • Mail
      • Pdf
      • Word
      • Xml
      • YUICompressor
      • Zip
    • Generic
      • Common
      • Device
        • Extension
        • Widget
    • Module
      • Database
        • Driver
      • Drive
      • Image
        • Font
      • Installer
      • Network
        • Ftp
          • Directory
          • File
          • Transport
        • Http
        • ParcelTracker
          • Carrier
      • Office
        • Chart
          • Axis
        • Document
          • Excel
            • Cell
              • Format
              • Style
                • Border
                  • Bottom
                  • Left
                  • Right
                  • Top
                • Font
            • Close
            • Page
            • Worksheet
          • Pdf
            • Close
            • Font
            • Page
              • Margin
              • Position
            • Text
          • Xml
            • Close
        • Image
        • Mail
          • Address
          • Content
      • Packer
        • Yui
        • Zip
      • Template
    • Plugin
      • Gateway
      • Repository
      • Shared
  • PHP

Classes

  • Mysql
  • Odbc
  • OdbcMssql
  • OdbcOracle
  • Overview
  • Namespace
  • Class
  • Tree
  • Deprecated
  • Todo
  • Download

Class Mysql

Class which provides an interface to a MySQL database

MOC\Module\Database\Constant
Extended by MOC\Module\Database\Configuration
Extended by MOC\Module\Database\Driver
Extended by MOC\Module\Database\Driver\Mysql
Namespace: MOC\Module\Database\Driver
Located at Module/Database/Driver/MySql.php
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

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

$Result
resource
$Result

Returns

array
protected array
# FetchAsArrayAssoc( resource $Result )

Fetches a query result as an associative array

Fetches a query result as an associative array

Parameters

$Result
resource
$Result

Returns

array
public boolean
# Close( )

Closes a database connection

Closes a database connection

Returns

boolean
public
# TransactionStart( )

Starts a Transaction

Starts a Transaction

Todo

Implement Transaction
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
Methods inherited from MOC\Module\Database\Driver
DebugError(), DebugMessage(), EnableDebug(), GetQuery(), GetResource(), Parameter(), SetParameter(), SetResource(), SetStatement(), Statement()
Methods inherited from MOC\Module\Database\Configuration
OptionDateTimeFormat(), OptionEscapeQuoteWith(), OptionQuote()
Constants inherited from MOC\Module\Database\Constant
DEBUG_HTML, PARAM_KEY_UNDEFINED, PARAM_TYPE_DATETIME, PARAM_TYPE_INTEGER, PARAM_TYPE_NONE, PARAM_TYPE_STRING, PARAM_TYPE_STRING_LIST, RESULT_AS_ARRAY, RESULT_AS_ARRAY_ASSOC
API documentation generated by ApiGen 2.8.0