Docs For Class atkMysqliDb
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 atkMysqliDb [ package: atk ]

Class: atkMysqliDb

Source Location: /db/class.atkmysqlidb.inc

Class atkMysqliDb

Inherited from parent

Inherited Properties Inherited Methods

Inherited From atkMysqlDb

atkMysqlDb::$m_identifierQuoting
atkMysqlDb::$m_seq_field
atkMysqlDb::$m_seq_namefield
atkMysqlDb::$m_seq_table
atkMysqlDb::$m_type

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 atkMysqlDb

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

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 ]

Method Summary

affected   affected_rows()   Evaluate the result; which rows were affected by the query.
void   atkmysqlidb()   Base constructor
bool   commit()   Commit the current transaction.
void   disconnect()   Disconnect from database
mixed   doConnect()   Connect to the database
int   getInsertId()   Returns the last inserted auto increment value.
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   rollback()   Rollback the the current transaction.
void   savepoint()   Set savepoint with the given name.
void   seek()   Goto a certain position in result set.
array   table_names()   Return the available table names
void   toggleForeignKeys()   Enable/disable all foreign key constraints.
result   unlock()   Unlock table(s) in the database
void   _debugWarnings()   Get all MySQL warnings for the previously executed query and make atkwarnings of them.
void   _setErrorVariables()   Store MySQL errors in internal variables

[ Top ]

Methods

affected_rows  [line 333]

  affected affected_rows( )

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


API Tags:
Return:  rows


Redefinition of:
atkMysqlDb::affected_rows()
Evaluate the result; which rows were affected by the query.

[ Top ]
atkmysqlidb  [line 35]

  void atkmysqlidb( )

Base constructor



[ Top ]
commit  [line 507]

  bool commit( )

Commit the current transaction.


API Tags:
Return:  true


Redefinition of:
atkDb::commit()
Commit the current transaction.

[ Top ]
disconnect  [line 109]

  void disconnect( )

Disconnect from database



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

[ Top ]
doConnect  [line 59]

  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:
atkMysqlDb::doConnect()
Connect to the database

[ Top ]
getInsertId  [line 567]

  int getInsertId( )

Returns the last inserted auto increment value.


API Tags:
Return:  auto increment value of latest insert query
Access:  public


[ Top ]
lock  [line 285]

  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:
atkMysqlDb::lock()
Lock a certain table in the database

[ Top ]
locktables_fallback_on_error  [line 215]

  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


Redefinition of:
atkMysqlDb::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.

[ Top ]
metadata  [line 414]

  array metadata( string $table, [bool $full = false]  )

Return the meta data of a certain table

Parameters:
string   $table:  the table name
bool   $full:  all meta data or not

API Tags:
Return:  with meta data


Redefinition of:
atkMysqlDb::metadata()
Return the meta data of a certain table

[ Top ]
nextid  [line 364]

  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:
atkMysqlDb::nextid()
Get the next sequence number of a certain sequence.

[ Top ]
next_record  [line 246]

  result next_record( )

Goto the next record in the result set


API Tags:
Return:  of going to the next record


Redefinition of:
atkMysqlDb::next_record()
Goto the next record in the result set

[ Top ]
num_fields  [line 353]

  number num_fields( )

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


API Tags:
Return:  of affected fields


Redefinition of:
atkMysqlDb::num_fields()
Evaluatie the result; how many fields where affected by the query.

[ Top ]
num_rows  [line 343]

  number num_rows( )

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


API Tags:
Return:  of affected rows


Redefinition of:
atkMysqlDb::num_rows()
Evaluate the result; how many rows were affected by the query.

[ Top ]
query  [line 125]

  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:
atkMysqlDb::query()
Performs a query

[ Top ]
rollback  [line 533]

  void rollback( [string $savepoint = ""]  )

Rollback the the current transaction.

Parameters:
string   $savepoint:  The savepoint to rollback to


Redefinition of:
atkDb::rollback()
Rollback the current transaction.

[ Top ]
savepoint  [line 522]

  void savepoint( string $name  )

Set savepoint with the given name.

Parameters:
string   $name:  savepoint name


Redefinition of:
atkDb::savepoint()
Set savepoint with the given name.

[ Top ]
seek  [line 272]

  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


Redefinition of:
atkMysqlDb::seek()
Goto a certain position in result set.

[ Top ]
table_names  [line 481]

  array table_names( [bool $includeViews = true]  )

Return the available table names

Parameters:
bool   $includeViews:  Include views?

API Tags:
Return:  with table names etc.


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

[ Top ]
toggleForeignKeys  [line 557]

  void toggleForeignKeys( boolean $enable  )

Enable/disable all foreign key constraints.

Parameters:
boolean   $enable:  enable/disable foreign keys?


Redefinition of:
atkDb::toggleForeignKeys()
Enable/disable all foreign key constraints.

[ Top ]
unlock  [line 312]

  result unlock( )

Unlock table(s) in the database


API Tags:
Return:  of unlocking


Redefinition of:
atkMysqlDb::unlock()
Unlock table(s) in the database

[ Top ]
_debugWarnings  [line 191]

  void _debugWarnings( )

Get all MySQL warnings for the previously executed query and make atkwarnings of them.


API Tags:
Access:  private


[ Top ]
_setErrorVariables  [line 92]

  void _setErrorVariables( )

Store MySQL errors in internal variables


API Tags:
Access:  private


Redefinition of:
atkMysqlDb::_setErrorVariables()
Store MySQL errors in internal variables

[ Top ]
Home | About | Contact