Docs For Class atkMysqlDb
Atk API home Class tree Element index

Todo list

Packages: » atk Classes: skel- » atkAppSuite utils » atkAbstractFrame » atkActionListener » atkClassFinder » atkClassLoader » atkDataHolder » atkDebugger » atkDirectoryTraverser » atkEventLog » atkFileUtils » atkFrame » atkFrameSet » atkIpUtils » atkJSON » atkMail » atkMailer » atkMessageQueue » atkmlsplitter » atkNavigator » atkRootFrameset » atkSelector » atkString » atkStringParser » atkTableRenderer » atkTableRendererGrouped » atkTextMarker » atkTmpFile » atkTriggerListener » atkYAML » atkZip » browserInfo » listenerTest » simplevisitor » testNode » test_atkactionlistener » test_atkclassloader » test_atkcolumnconfig » test_atkDirectoryTraverser » test_atklistattribute » test_atkStringParser » test_atkTextMarker general » atkConfig » atkController » atkDataNode » atkErrorHandlerBase » atkFileEditor » atkLanguage » atkMailErrorHandler » atkMetaNode » atkMockNode » atkNode » atkNodeValidator » atkSessionStore » atkTreeNode » atkWizardBase » atkZendPlatformErrorHandler » clsTbsDataSource » clsTbsLocator » clsTinyButStrong » clsTinyButStrongOOo » FCKeditor » getSupportedLanguagesCollector » layout » node » sql_whereclause_blacklist_checker » test » tree » triggerNode fixture » atkAbstractFixtureLoader » atkFixtureManager » atkPHPFixtureLoader » atkYAMLFixtureLoader testcases » atkAbstractSearchHandler » DateAttributeWrapper » dummyTagAttribute » Stub_atkNew » test_atkattributeedithandler » test_atkBoolAttribute » test_atkCalculatorAttribute » test_atkcolorpickerattribute » test_atkDataGrid » test_atkdatanode » test_atkDateAttribute » test_atkFileAttribute » test_atkfrontcontroller » test_atkiputils » test_atkManyToOneRelation » test_atknode » test_atkRelation » test_atktagattribute » test_atkwizard » test_tabs » uriPartsFrontControllerMock ui » atkActionBoxBuilder » atkDialog » atkIndexPage » atkOutput » atkPage » atkPageBuilder » atkTheme » atkThemeCompiler » atkUI handlers » atkActionHandler » atkAddHandler » atkAddOrCopyHandler » atkAdminHandler » atkAttributeEditHandler » atkCopyHandler » atkDeleteHandler » atkDocumentHandler » atkEditCopyHandler » atkEditHandler » atkExportHandler » atkFeedbackHandler » atkFileExport » atkImportHandler » atkMultiSelectHandler » atkMultiUpdatehandler » atkSaveHandler » atkSearchHandler » atkSelectHandler » atkSmartSearchHandler » atkUpdatehandler » atkViewEditBase » atkViewHandler » atkXmlHandler » test_atkimporthandler attributes » atkAggregatedColumn » atkAttribute » atkBoolAttribute » atkCalculatorAttribute » atkCaptchaAttribute » atkColorPickerAttribute » atkCountryAttribute » atkCreatedByAttribute » atkCreateStampAttribute » atkCurrencyAttribute » atkDateAttribute » atkDateTimeAttribute » atkDocumentAttribute » atkDummyAttribute » atkDurationAttribute » atkEmailAttribute » atkExpressionAttribute » atkFckAttribute » atkFieldSet » atkFileAttribute » atkFileWriterAttribute » atkFlagAttribute » atkFormatAttribute » atkFuzzySearchAttribute » atkHtmlAttribute » atkIpAttribute » atkListAttribute » atkLiveTextPreview » atkMlAttribute » atkMlHtmlAttribute » atkMlNumberAttribute » atkMlSelectorAttribute » atkMlTextAttribute » atkMlWrapper » atkMultipleFileAttribute » atkMultiSelectAttribute » atkNumberAttribute » atkParserAttribute » atkPasswordAttribute » atkProfileAttribute » atkRadioAttribute » atkRadioDetailsAttribute » atkRowCounter » atkStateAttribute » atkTabbedPane » atkTagAttribute » atkTextAttribute » atkTimeAttribute » atkTimeZoneAttribute » atkToolbar » atkUpdatedByAttribute » atkUpdateStampAttribute » atkUrlAttribute » atkWeekdayAttribute » atkWysiwygAttribute » test_atkattribute » test_atkmultiselectattribute » test_atktextattribute datatypes » atkArrayDt » atkDataType » atkStringDt » atkTime subpackage » atkAttributeTestCase security » atkBajusEncryption » atkBase64Encryption » atkEncryption » atkMockSecurityManager » atkOpenSSLEncryption » atkSecurityListener » atkSecurityManager » atkUrlVault » auth_config » auth_db » auth_imap » auth_interface » auth_ldap » auth_none » auth_pop3 » auth_server » auth_sspi » test_atkMockSecurityManager » test_atkUrlVault cache » atkCache » atkCache_apc » atkCache_eaccelerator » atkCache_file » atkCache_memcache » atkCache_var » atkCache_xcache » atkCache_zp_disk » atkCache_zp_output » atkCache_zp_shm » test_atkcache_apc » test_atkcache_eaccelerator » test_atkcache_file » test_atkcache_memcache » test_atkcache_var » test_atkcache_xcache » test_atkcache_zp_disk » test_atkcache_zp_output » test_atkcache_zp_shm test » ArrayHtmlReporter » ArrayTextReporter » atkCacheTestCase » atkPHPUnitTestCaseCollector » atkPluginTestCase » atkSimpleTestTestCaseCollector » atkTestCase » atkTestCaseCollector » atkTestReporter » atkTestSuite » atkTestTraverser » test_atkMockNode » test_atktestcase » test_atktools » Test_DbConfigs » test_sql_whereclause_blacklist_checker » test_tabsecurity » test_triggers db » atkClusterDb » atkClusterDDL » atkClusterQuery » atkDb » atkDDL » atkMockDb » atkMockDDL » atkMockQuery » atkMsSqlDb » atkMsSqlDDL » atkMssqlQuery » atkMysqlDb » atkMysqlDDL » atkMysqliDb » atkMysqliDDL » atkMysqliQuery » atkMysqlQuery » atkOci8Db » atkOci8DDL » atkOci8Query » atkOci9Db » atkOci9DDL » atkOci9Query » atkOci805Db » atkOci805Query » atkPgsqlDb » atkPgsqlDDL » atkPgsqlQuery » atkQuery » test_atkdb recordlist » atkColumnConfig » atkCSVRecordList » atkCustomRecordList » atkExcelCSVRecordList » atkHTMLRecordList » atkPrintableRecordList » atkRecordList » atkRecordlistCache » atkTotalizer console » atkConsoleController menu » atkcookmenu » atkDhtmlMenu » atkDropdownMenu » atkFramesMenu » atkMenu » atkmenuinterface » atkModernMenu » atkOutlookMenu » atkPlainMenu datagrid » atkDataGrid » atkDGComponent » atkDGEditControl » atkDGEvent » atkDGIndex » atkDGLimit » atkDGList » atkDGNoRecordsFound » atkDGPaginator » atkDGRenderer » atkDGSummary lock » atkDbLock » atkLock filters » atkDistinctFilter » atkFilter » atkGroupByFilter document » atkDocumentWriter » atkDocxWriter » atkOpenDocumentWriter meta » atkDutchMetaGrammar » atkMetaAttributeModifier » atkMetaCompiler » atkMetaGrammar » atkMetaPolicy » mod_meta relations » atkExtendableShuttleRelation » atkManyBoolRelation » atkManyToManyListRelation » atkManyToManyRelation » atkManyToManySelectRelation » atkManyToOneRelation » atkManyToOneTreeRelation » atkMatrixRelation » atkOneToManyRelation » atkOneToManyRelationSessionGridHandler » atkOneToOneRelation » atkRelation » atkSecureRelation » atkShuttleControl » atkShuttleFilter » atkShuttleRelation front » atkFrontController » atkFrontControllerBridge keyboard » atkKeyboard meta-relations » atkMetaExtendableShuttleRelation » atkMetaManyBoolRelation » atkMetaManyToManyListRelation » atkMetaManyToManySelectRelation » atkMetaManyToOneRelation » atkMetaOneToManyRelation » atkMetaOneToOneRelation » atkMetaShuttleRelation modules » atkModule » mod_test interface » atkServer » atkSoapServer session » atkSessionManager » atkState wizard » atkWizard » AtkWizardActionLoader » atkWizardPanel attribute » test_atkcurrencyattribute » test_atknumberattribute
Interfaces: datagrid » atkDGListener interface » atkServerInterface
Files: general » adodb-time.inc.php » atknodetools.inc » atktools.inc » atktreetools.inc » basexml.php » class.atkconfig.inc » class.atkcontroller.inc » class.atkdatanode.inc » class.atkerrorhandlerbase.inc » class.atkfileeditor.inc » class.atklanguage.inc » class.atkmailerrorhandler.inc » class.atkmetanode.inc » class.atkmocknode.inc » class.atknode.inc » class.atknodevalidator.inc » class.atksessionstore.inc » class.atktreenode.inc » class.atkwizardbase.inc » class.atkzendplatformerrorhandler.inc » class.layout.inc » class.nodename.inc » class.sql_whereclause_blacklist_checker.inc » class.test.inc » class.test_sql_whereclause_blacklist_checker.inc » class.test_triggers.inc » commands.php » config.modules.inc » config.php » connector.php » console.php » db2yaml.php » defaultconfig.inc.php » fckeditor.php » fckeditor_php4.php » fckeditor_php5.php » io.php » module.inc » phpcompat.php » server.php » spellchecker.php » table2yaml.php » tbsooo_class.php » tbs_class.php » upload.php » util.php » version.inc attribute » class.test_atkcurrencyattribute.inc » class.test_atknumberattribute.inc attributes » class.atkaggregatedcolumn.inc » class.atkattribute.inc » class.atkboolattribute.inc » class.atkcalculatorattribute.inc » class.atkcaptchaattribute.inc » class.atkcolorpickerattribute.inc » class.atkcountryattribute.inc » class.atkcreatedbyattribute.inc » class.atkcreatestampattribute.inc » class.atkcurrencyattribute.inc » class.atkdateattribute.inc » class.atkdatetimeattribute.inc » class.atkdocumentattribute.inc » class.atkdummyattribute.inc » class.atkdurationattribute.inc » class.atkemailattribute.inc » class.atkexpressionattribute.inc » class.atkfckattribute.inc » class.atkfieldset.inc » class.atkfileattribute.inc » class.atkfilewriterattribute.inc » class.atkflagattribute.inc » class.atkformatattribute.inc » class.atkfuzzysearchattribute.inc » class.atkhtmlattribute.inc » class.atkipattribute.inc » class.atklistattribute.inc » class.atklivetextpreview.inc » class.atkmlattribute.inc » class.atkmlhtmlattribute.inc » class.atkmlnumberattribute.inc » class.atkmlselectorattribute.inc » class.atkmltextattribute.inc » class.atkmlwrapper.inc » class.atkmultiplefileattribute.inc » class.atkmultiselectattribute.inc » class.atknumberattribute.inc » class.atkparserattribute.inc » class.atkpasswordattribute.inc » class.atkprofileattribute.inc » class.atkradioattribute.inc » class.atkradiodetailsattribute.inc » class.atkrowcounter.inc » class.atkstateattribute.inc » class.atktabbedpane.inc » class.atktagattribute.inc » class.atktextattribute.inc » class.atktimeattribute.inc » class.atktimezoneattribute.inc » class.atktoolbar.inc » class.atkupdatedbyattribute.inc » class.atkupdatestampattribute.inc » class.atkurlattribute.inc » class.atkweekdayattribute.inc » class.atkwysiwygattribute.inc » class.test_atkattribute.inc » class.test_atkmultiselectattribute.inc » class.test_atktextattribute.inc attributes-- » property_accessor.php cache » class.atkcache.inc » class.atkcache_apc.inc » class.atkcache_eaccelerator.inc » class.atkcache_file.inc » class.atkcache_memcache.inc » class.atkcache_var.inc » class.atkcache_xcache.inc » class.atkcache_zp_disk.inc » class.atkcache_zp_output.inc » class.atkcache_zp_shm.inc » class.test_atkcache_apc.inc » class.test_atkcache_eaccelerator.inc » class.test_atkcache_file.inc » class.test_atkcache_memcache.inc » class.test_atkcache_var.inc » class.test_atkcache_xcache.inc » class.test_atkcache_zp_disk.inc » class.test_atkcache_zp_output.inc » class.test_atkcache_zp_shm.inc console » class.atkconsolecontroller.inc datagrid » class.atkdatagrid.inc » class.atkdgcomponent.inc » class.atkdgeditcontrol.inc » class.atkdgevent.inc » class.atkdgindex.inc » class.atkdglimit.inc » class.atkdglist.inc » class.atkdglistener.inc » class.atkdgnorecordsfound.inc » class.atkdgpaginator.inc » class.atkdgrenderer.inc » class.atkdgsummary.inc datatypes » class.atkarraydt.inc » class.atkdatatype.inc » class.atkstringdt.inc » class.atktimedt.inc db » class.atkclusterdb.inc » class.atkclusterddl.inc » class.atkclusterquery.inc » class.atkdb.inc » class.atkddl.inc » class.atkmockdb.inc » class.atkmockddl.inc » class.atkmockquery.inc » class.atkmssqldb.inc » class.atkmssqlddl.inc » class.atkmssqlquery.inc » class.atkmysqldb.inc » class.atkmysqlddl.inc » class.atkmysqlidb.inc » class.atkmysqliddl.inc » class.atkmysqliquery.inc » class.atkmysqlquery.inc » class.atkoci8db.inc » class.atkoci8ddl.inc » class.atkoci8query.inc » class.atkoci9db.inc » class.atkoci9ddl.inc » class.atkoci9query.inc » class.atkoci805db.inc » class.atkoci805query.inc » class.atkpgsqldb.inc » class.atkpgsqlddl.inc » class.atkpgsqlquery.inc » class.atkquery.inc » class.test_atkdb.inc document » class.atkdocumentwriter.inc » class.atkdocxwriter.inc » class.atkopendocumentwriter.inc filters » class.atkdistinctfilter.inc » class.atkfilter.inc » class.atkgroupbyfilter.inc fixture » class.atkabstractfixtureloader.inc » class.atkfixturemanager.inc » class.atkphpfixtureloader.inc » class.atkyamlfixtureloader.inc front » class.atkfrontcontroller.inc » class.atkfrontcontrollerbridge.inc handlers » class.atkactionhandler.inc » class.atkaddhandler.inc » class.atkaddorcopyhandler.inc » class.atkadminhandler.inc » class.atkattributeedithandler.inc » class.atkcopyhandler.inc » class.atkdeletehandler.inc » class.atkdocumenthandler.inc » class.atkeditcopyhandler.inc » class.atkedithandler.inc » class.atkexporthandler.inc » class.atkfeedbackhandler.inc » class.atkfileexport.inc » class.atkimporthandler.inc » class.atkmultiselecthandler.inc » class.atkmultiupdatehandler.inc » class.atksavehandler.inc » class.atksearchhandler.inc » class.atkselecthandler.inc » class.atksmartsearchhandler.inc » class.atkupdatehandler.inc » class.atkvieweditbase.inc » class.atkviewhandler.inc » class.atkxmlhandler.inc » class.test_atkimporthandler.inc include » autoload.inc » basics.inc » compatibility.inc » configs.inc » debugging.inc » errorhandler.inc » globals.inc » initial.inc » security.inc interface » class.atkserver.inc » class.atksoapserver.inc » interface.atkserverinterface.inc javascript » class.atkmultilanguage.js.php » class.atkprofileattribute.js.php » dhtml_tabs.js.php keyboard » class.atkkeyboard.inc lock » class.atkdblock.inc » class.atklock.inc » lock.php lock-- » lock.js.php menu » atkmenutools.inc » class.atkcookmenu.inc » class.atkdhtmlmenu.inc » class.atkdropdownmenu.inc » class.atkframesmenu.inc » class.atkmenu.inc » class.atkmenuinterface.inc » class.atkmodernmenu.inc » class.atkoutlookmenu.inc » class.atkplainmenu.inc meta » class.atkdutchmetagrammar.inc » class.atkmetaattributemodifier.inc » class.atkmetacompiler.inc » class.atkmetagrammar.inc » class.atkmetapolicy.inc » module.inc meta-relations » class.atkmetaextendableshuttlerelation.inc » class.atkmetamanyboolrelation.inc » class.atkmetamanytomanylistrelation.inc » class.atkmetamanytomanyselectrelation.inc » class.atkmetamanytoonerelation.inc » class.atkmetaonetomanyrelation.inc » class.atkmetaonetoonerelation.inc » class.atkmetashuttlerelation.inc modules » class.atkmodule.inc modules-- » atkmoduletools.inc popups » colorpicker.inc recordlist » class.atkcolumnconfig.inc » class.atkcsvrecordlist.inc » class.atkcustomrecordlist.inc » class.atkexcelcsvrecordlist.inc » class.atkhtmlrecordlist.inc » class.atkprintablerecordlist.inc » class.atkrecordlist.inc » class.atkrecordlistcache.inc » class.atktotalizer.inc relations » class.atkextendableshuttlerelation.inc » class.atkmanyboolrelation.inc » class.atkmanytomanylistrelation.inc » class.atkmanytomanyrelation.inc » class.atkmanytomanyselectrelation.inc » class.atkmanytoonerelation.inc » class.atkmanytoonetreerelation.inc » class.atkmatrixrelation.inc » class.atkonetomanyrelation.inc » class.atkonetoonerelation.inc » class.atkrelation.inc » class.atksecurerelation.inc » class.atkshuttlecontrol.inc » class.atkshuttlefilter.inc » class.atkshuttlerelation.inc security » class.atkbajusencryption.inc » class.atkbase64encryption.inc » class.atkencryption.inc » class.atkmocksecuritymanager.inc » class.atkopensslencryption.inc » class.atksecuritylistener.inc » class.atksecuritymanager.inc » class.atkurlvault.inc » class.auth_config.inc » class.auth_db.inc » class.auth_imap.inc » class.auth_interface.inc » class.auth_ldap.inc » class.auth_none.inc » class.auth_pop3.inc » class.auth_server.inc » class.auth_sspi.inc » class.test_atkmocksecuritymanager.inc » class.test_atkurlvault.inc session » class.atksessionmanager.inc » class.atkstate.inc skel » app.php » atk.inc » config.inc.php » debugger.php » dispatch.php » include.php » index.php » menu.php » test.php » top.php » welcome.php skel- » atkappsuite.php subpackage » class.atkattributetestcase.inc test » class.atkcachetestcase.inc » class.atkphpunittestcasecollector.inc » class.atkplugintestcase.inc » class.atksimpletesttestcasecollector.inc » class.atktestcase.inc » class.atktestcasecollector.inc » class.atktestreporter.inc » class.atktestsuite.inc » class.atktesttraverser.inc » class.test_atkmocknode.inc » class.test_atktestcase.inc » class.test_atktools.inc » class.test_dbconfigs.inc » class.test_tabsecurity.inc testcases » class.atkabstractsearchhandler.inc » class.stub_atknew.inc » class.test_atkattributeedithandler.inc » class.test_atkboolattribute.inc » class.test_atkcalculatorattribute.inc » class.test_atkcolorpickerattribute.inc » class.test_atkdatagrid.inc » class.test_atkdatanode.inc » class.test_atkdateattribute.inc » class.test_atkfileattribute.inc » class.test_atkfrontcontroller.inc » class.test_atkiputils.inc » class.test_atkmanytoonerelation.inc » class.test_atknode.inc » class.test_atkrelation.inc » class.test_atktagattribute.inc » class.test_atkwizard.inc » class.test_tabs.inc themes » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc » themedef.inc ui » block.atknavigator.php » block.atknavigatorinfo.php » class.atkactionboxbuilder.inc » class.atkdialog.inc » class.atkindexpage.inc » class.atkoutput.inc » class.atkpage.inc » class.atkpagebuilder.inc » class.atktheme.inc » class.atkthemecompiler.inc » class.atkui.inc » function.atkconfig.php » function.atkdatefield.php » function.atkdispatchfile.php » function.atkfrontcontroller.php » function.atkloadscript.php » function.atkmessages.php » function.atkmoduledir.php » function.atkscript.php » function.atkstyle.php » function.atktext.php » function.atkthemeicon.php » function.atkthemeimg.php » function.stacktrace.php » modifier.atkjson.php » modifier.atkvardump.php » resource.string.php » resource.theme.php » resource.ui.php utils » atkbrowsertools.inc » class.atkactionlistener.inc » class.atkclassloader.inc » class.atkdataholder.inc » class.atkdebugger.inc » class.atkdirectorytraverser.inc » class.atkeventlog.inc » class.atkfileutils.inc » class.atkframeset.inc » class.atkiputils.inc » class.atkjson.inc » class.atkmail.inc » class.atkmailer.inc » class.atkmessagequeue.inc » class.atkmlsplitter.inc » class.atknavigator.inc » class.atkselector.inc » class.atkstring.inc » class.atkstringparser.inc » class.atktablerenderer.inc » class.atktablerenderergrouped.inc » class.atktextmarker.inc » class.atktmpfile.inc » class.atktriggerlistener.inc » class.atkyaml.inc » class.atkzip.inc » class.test_atkactionlistener.inc » class.test_atkclassloader.inc » class.test_atkcolumnconfig.inc » class.test_atkdirectorytraverser.inc » class.test_atklistattribute.inc » class.test_atkstringparser.inc » class.test_atktextmarker.inc » help.inc wizard » class.atkwizard.inc » class.atkwizardactionloader.inc » class.atkwizardpanel.inc
Home  ->  Documentation home  ->  Atk index  ->  Docs For Class atkMysqlDb [ package: atk ]

Class: atkMysqlDb

Source Location: /db/class.atkmysqldb.inc

Class atkMysqlDb

Descendants

Child Class Description
atkMsSqlDb Driver for MsSQL databases
atkMysqliDb Driver for MySQL databases > 4.1.3

[ Top ]

Inherited from parent

Inherited Properties Inherited Methods

Inherited From atkDb

atkDb::$m_affected_rows
atkDb::$m_auto_free
atkDb::$m_charset
atkDb::$m_collate
atkDb::$m_connection
atkDb::$m_database
atkDb::$m_errno
atkDb::$m_error
atkDb::$m_errorLookup
atkDb::$m_haltonerror
atkDb::$m_host
atkDb::$m_link_id
atkDb::$m_mode
atkDb::$m_password
atkDb::$m_port
atkDb::$m_query_id
atkDb::$m_record
atkDb::$m_row
atkDb::$m_tableMeta
atkDb::$m_user
atkDb::$m_user_error
atkDb::$m_vendor

Inherited From atkDb

atkDb::affected_rows()
Retrieve the number of rows affected by the last query.
atkDb::clearMapping()
Clear the current database mapping.
atkDb::cloneAll()
Clones the database structure of the given database to this database. This also means the complete database is emptied beforehand.
atkDb::commit()
Commit the current transaction.
atkDb::connect()
Connect to the database.
atkDb::createDDL()
Create an atkDDL object for constructing ddl queries.
atkDb::createQuery()
Create an atkQuery object for constructing queries.
atkDb::deleteAll()
Empty all database tables.
atkDb::disconnect()
Disconnect from database
atkDb::doConnect()
Connect to the database
atkDb::dropAll()
Drop all database tables.
atkDb::errorLookup()
Looks up the error
atkDb::escapeSQL()
escapes quotes for use in SQL: ' -> '' (and sometimes % -> %%)
atkDb::func_concat()
Get CONCAT() equivalent for the current database.
atkDb::func_concat_ws()
Get CONCAT_WS() equivalent for the current database.
atkDb::func_datetimetochar()
Get TO_CHAR() equivalent for the current database.
atkDb::func_datetochar()
Get TO_CHAR() equivalent for the current database.
atkDb::func_now()
get NOW() or SYSDATE() equivalent for the current database
atkDb::func_substring()
get SUBSTRING() equivalent for the current database.
atkDb::getAtkDbErrno()
Get generic atk errorccode
atkDb::getDbErrno()
Get vendor-dependent database error number.
atkDb::getDbError()
Get vendor-dependent database error message.
atkDb::getDbStatus()
Check if current db is present and acceptable for current user
atkDb::getErrorMsg()
Get localized error message (for display in the application)
atkDb::getErrorType()
Determine whether an error that occurred is a recoverable (user) error or a system error.
atkDb::getInstance()
Get database instance.
atkDb::getMapping()
Returns the current database mapping.
atkDb::getQueryMode()
Returns the query mode
atkDb::getrows()
Get all rows that are the result of a certain specified query
atkDb::getSearchModes()
This function indicates what searchmodes the database supports.
atkDb::getTranslatedDatabaseName()
Returns the real database name. If a mapping
atkDb::getType()
Get the database driver type.
atkDb::getValue()
Get a single value (first row, first column) from a certain specified query
atkDb::getValues()
Get an array with all the values in the (first) column.
atkDb::halt()
If haltonerror is set, this will raise an atkerror. If not, it will place the error in atkdebug and continue.
atkDb::hasError()
Has error?
atkDb::hasMode()
Check if the current instance has the given mode
atkDb::init()
(Re)Initialise a database driver with a connection
atkDb::link_id()
Get the current connection.
atkDb::lock()
Lock a table in the database.
atkDb::maxIdentifierLength()
Returns the maximum length an identifier (tablename, columnname, etc) may have
atkDb::metadata()
Return the meta data of a certain table HIE GEBLEVEN
atkDb::nextid()
Get the next sequence number of a certain sequence.
atkDb::next_record()
Retrieve the next record in the resultset.
atkDb::query()
Parse and execute a query.
atkDb::query_id()
Get the current query statement resource id.
atkDb::quoteIdentifier()
Quote Indentifier
atkDb::rollback()
Rollback the current transaction.
atkDb::savepoint()
Set savepoint with the given name.
atkDb::setHaltOnError()
Halt on error or not?
atkDb::setInstance()
Replace the current instance of a named connection at runtime with a different connection. This is useful for example for replacing a named database instance with a mock object for testing purposes.
atkDb::setSequenceValue()
Set database sequence value.
atkDb::setUserError()
Define custom user error codes.
atkDb::tableExists()
This function checks the database for a table with the provide name
atkDb::tableMeta()
Fetches table meta data from database
atkDb::table_names()
Return the available table names
atkDb::toggleForeignKeys()
Enable/disable all foreign key constraints.
atkDb::unlock()
Relieve all locks.
atkDb::useMapping()
Use the given mapping to translate database requests from one database to another database. This can be used for test purposes.
atkDb::vendorDateFormat()
Convert a php date() format specifier to a vendor specific format specifier.
atkDb::_getOrUseMapping()
Get or set the database mapping
atkDb::_getTableMetaFromCache()
If cached it'll return the table metadata from cache.
atkDb::_getTableMetaFromDb()
Returns the tablemetadata directly from db
atkDb::_translateError()
Translate database-vendor dependent error messages into an ATK generic error code.

[ Top ]

Property Summary

mixed   $m_identifierQuoting  
mixed   $m_seq_field  
mixed   $m_seq_namefield  
mixed   $m_seq_table  
mixed   $m_type  

[ Top ]

Method Summary

affected   affected_rows()   Evaluate the result; which rows were affected by the query.
void   atkmysqldb()   Base constructor
void   disconnect()   Disconnect from database
mixed   doConnect()   Connect to the database
void   dropAll()   Drop all database tables.
String   func_datetimetochar()   Get TO_CHAR() equivalent for the current database.
String   func_datetochar()   Get TO_CHAR() equivalent for the current database.
false|string   getColumnLength()   Mysql_field_len returns unusable results for decimal,float and double column types.
String   getErrorType()   Determine whether an error that occurred is a recoverable (user) error or a system error.
array   getSearchModes()   This function indicates what searchmodes the database supports.
result   lock()   Lock a certain table in the database
void   locktables_fallback_on_error()   This method provides a fallback when error 1100 occurs (Table ... not locked using LOCK TABLES). This method locks the table and runs the query again.
array   metadata()   Return the meta data of a certain table
the   nextid()   Get the next sequence number of a certain sequence.
result   next_record()   Goto the next record in the result set
number   num_fields()   Evaluatie the result; how many fields where affected by the query.
number   num_rows()   Evaluate the result; how many rows were affected by the query.
void   query()   Performs a query
void   seek()   Goto a certain position in result set.
void   setSequenceValue()   Set database sequence value.
boolean   tableExists()   This function checks the database for a table with the provide name
array   table_names()   Return the available table names
result   unlock()   Unlock table(s) in the database
String   vendorDateFormat()   Convert a php date() format specifier to a mysql specific format specifier.
string   _getTableType()   Returns the table type.
void   _setErrorVariables()   Store MySQL errors in internal variables
int   _translateError()   Translates known database errors to developer-friendly messages

[ Top ]

Properties

mixed   $m_identifierQuoting = array('start' => '`', 'end' => '`', 'escape' => '`') [line 38]
API Tags:
Access:  protected


Redefinition of:
atkDb::$m_identifierQuoting
Indentifier Quoting

[ Top ]
mixed   $m_seq_field = "nextid" [line 32]

[ Top ]
mixed   $m_seq_namefield = "seq_name" [line 34]

[ Top ]
mixed   $m_seq_table = "db_sequence" [line 30]

[ Top ]
mixed   $m_type = "mysql" [line 36]

Redefinition of:
atkDb::$m_type
Driver name.

[ Top ]

Methods

affected_rows  [line 358]

  affected affected_rows( )

Evaluate the result; which rows were affected by the query.


API Tags:
Return:  rows


Redefinition of:
atkDb::affected_rows()
Retrieve the number of rows affected by the last query.

Redefined in descendants as:

[ Top ]
atkmysqldb  [line 44]

  void atkmysqldb( )

Base constructor



[ Top ]
disconnect  [line 158]

  void disconnect( )

Disconnect from database



Redefinition of:
atkDb::disconnect()
Disconnect from database

Redefined in descendants as:

[ Top ]
doConnect  [line 69]

  mixed doConnect( string $host, string $user, string $password, string $database, int $port, string $charset  )

Connect to the database

Parameters:
string   $host:  Hostname
string   $user:  Username
string   $password:  Password
string   $database:  The database to connect to
int   $port:  The portnumber to use for connecting
string   $charset:  The charset to use

API Tags:
Return:  Connection status


Redefinition of:
atkDb::doConnect()
Connect to the database

Redefined in descendants as:

[ Top ]
dropAll  [line 437]

  void dropAll( )

Drop all database tables.



Redefinition of:
atkDb::dropAll()
Drop all database tables.

[ Top ]
func_datetimetochar  [line 688]

  String func_datetimetochar( String $fieldname  )

Get TO_CHAR() equivalent for the current database.

TODO/FIXME: add format parameter. Current format is always yyyy-mm-dd hh:mi.

Parameters:
String   $fieldname:  The field to generate the to_char for.

API Tags:
Return:  Piece of sql query that converts a datetime field to char for the current database


Redefinition of:
atkDb::func_datetimetochar()
Get TO_CHAR() equivalent for the current database.

[ Top ]
func_datetochar  [line 655]

  String func_datetochar( String $fieldname, [String $format = ""]  )

Get TO_CHAR() equivalent for the current database.

Each database driver should override this method to perform vendor specific conversion.

Parameters:
String   $fieldname:  The field to generate the to_char for.
String   $format:  Format specifier. The format is compatible with php's date() function (http://www.php.net/date) The default is what's specified by $config_date_to_char, or "Y-m-d" if not set in the configuration.

API Tags:
Return:  Piece of sql query that converts a date field to char for the current database


Redefinition of:
atkDb::func_datetochar()
Get TO_CHAR() equivalent for the current database.

[ Top ]
getColumnLength  [line 555]

  false|string getColumnLength( string $tableName, string $columnName, string $columnType  )

Mysql_field_len returns unusable results for decimal,float and double column types.

This method returns a number format, e.g.: '6,2' or false in case of failure OR if the field type does not support a floating point (e.g. for integer fields) so it can fall back on mysql_field_len()

Parameters:
string   $tableName: 
string   $columnName: 
string   $columnType: 

API Tags:
Return:  e.g. '6,2'
Access:  public


[ Top ]
getErrorType  [line 108]

  String getErrorType( )

Determine whether an error that occurred is a recoverable (user) error or a system error.


API Tags:
Return:  "user" or "system"


Redefinition of:
atkDb::getErrorType()
Determine whether an error that occurred is a recoverable (user) error or a system error.

[ Top ]
getSearchModes  [line 636]

  array getSearchModes( )

This function indicates what searchmodes the database supports.


API Tags:
Return:  with search modes


Redefinition of:
atkDb::getSearchModes()
This function indicates what searchmodes the database supports.

[ Top ]
lock  [line 311]

  result lock( string $table, [string $mode = "write"]  )

Lock a certain table in the database

Parameters:
string   $table:  the table name
string   $mode:  the type of locking

API Tags:
Return:  of locking


Redefinition of:
atkDb::lock()
Lock a table in the database.

Redefined in descendants as:

[ Top ]
locktables_fallback_on_error  [line 241]

  void locktables_fallback_on_error( string $query, [string $querymode = 'w']  )

This method provides a fallback when error 1100 occurs (Table ... not locked using LOCK TABLES). This method locks the table and runs the query again.

Parameters:
string   $query:  The original query that failed
string   $querymode:  Kind of query - 'w' for write or 'r' for read


Redefined in descendants as:

[ Top ]
metadata  [line 465]

  array metadata( String $table, [boolean $full = false]  )

Return the meta data of a certain table

Parameters:
String   $table:  the table name (optionally in 'database.tablename' format)
boolean   $full:  all meta data or not

API Tags:
Return:  with meta data


Redefinition of:
atkDb::metadata()
Return the meta data of a certain table HIE GEBLEVEN

Redefined in descendants as:

[ Top ]
nextid  [line 389]

  the nextid( string $sequence  )

Get the next sequence number of a certain sequence.

Parameters:
string   $sequence:  the sequence name

API Tags:
Return:  next sequence id


Redefinition of:
atkDb::nextid()
Get the next sequence number of a certain sequence.

Redefined in descendants as:

[ Top ]
next_record  [line 272]

  result next_record( )

Goto the next record in the result set


API Tags:
Return:  of going to the next record


Redefinition of:
atkDb::next_record()
Retrieve the next record in the resultset.

Redefined in descendants as:

[ Top ]
num_fields  [line 378]

  number num_fields( )

Evaluatie the result; how many fields where affected by the query.


API Tags:
Return:  of affected fields


Redefined in descendants as:

[ Top ]
num_rows  [line 368]

  number num_rows( )

Evaluate the result; how many rows were affected by the query.


API Tags:
Return:  of affected rows


Redefined in descendants as:

[ Top ]
query  [line 174]

  void query( string $query, [int $offset = -1], [int $limit = -1]  )

Performs a query

Parameters:
string   $query:  the query
int   $offset:  offset in record list
int   $limit:  maximum number of records


Redefinition of:
atkDb::query()
Parse and execute a query.

Redefined in descendants as:

[ Top ]
seek  [line 298]

  void seek( [int $position = 0]  )

Goto a certain position in result set.

Not specifying a position will set the pointer at the beginning of the result set.

Parameters:
int   $position:  the position


Redefined in descendants as:

[ Top ]
setSequenceValue  [line 699]

  void setSequenceValue( string $seqname, int $value  )

Set database sequence value.

Parameters:
string   $seqname:  sequence name
int   $value:  sequence value


Redefinition of:
atkDb::setSequenceValue()
Set database sequence value.

[ Top ]
tableExists  [line 626]

  boolean tableExists( String $table  )

This function checks the database for a table with the provide name

Parameters:
String   $table:  the table to find

API Tags:
Return:  true if found, false if not found


Redefinition of:
atkDb::tableExists()
This function checks the database for a table with the provide name

[ Top ]
table_names  [line 601]

  array table_names( )

Return the available table names


API Tags:
Return:  with table names etc.


Redefinition of:
atkDb::table_names()
Return the available table names

Redefined in descendants as:

[ Top ]
unlock  [line 338]

  result unlock( )

Unlock table(s) in the database


API Tags:
Return:  of unlocking


Redefinition of:
atkDb::unlock()
Relieve all locks.

Redefined in descendants as:

[ Top ]
vendorDateFormat  [line 671]

  String vendorDateFormat( String $format  )

Convert a php date() format specifier to a mysql specific format specifier.

Note that currently, only the common specifiers Y, m, d, H, h, i and s are supported.

Parameters:
String   $format:  Format specifier. The format is compatible with php's date() function (http://www.php.net/date)

API Tags:
Return:  Mysql specific format specifier.


Redefinition of:
atkDb::vendorDateFormat()
Convert a php date() format specifier to a vendor specific format specifier.

[ Top ]
_getTableType  [line 453]

  string _getTableType( string $table  )

Returns the table type.

Parameters:
string   $table:  table name

API Tags:
Return:  table type


[ Top ]
_setErrorVariables  [line 141]

  void _setErrorVariables( )

Store MySQL errors in internal variables


API Tags:
Access:  private


Redefined in descendants as:

[ Top ]
_translateError  [line 119]

  int _translateError( )

Translates known database errors to developer-friendly messages


API Tags:
Return:  Flag of the error


Redefinition of:
atkDb::_translateError()
Translate database-vendor dependent error messages into an ATK generic error code.

Redefined in descendants as:

[ Top ]
Home | About | Contact