====== JDatabaseMySQLi ====== {#JAPI Joomla.Framework Database JDatabaseMySQLi #} MySQLi database driver ===== Methods ===== ^ Method ^ Description ^ | [[JDatabaseMySQLi-__construct|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-__construct|__construct]] | Database object constructor | | [[JDatabaseMySQLi-__destruct|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-__destruct|__destruct]] | Database object destructor | | [[JDatabaseMySQLi-connected|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-connected|connected]] | Determines if the connection to the server is active. | | [[JDatabaseMySQLi-explain|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-explain|explain]] | Diagnostic function | | [[JDatabaseMySQLi-getAffectedRows|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-getAffectedRows|getAffectedRows]] | | | [[JDatabaseMySQLi-getCollation|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-getCollation|getCollation]] | Assumes database collation in use by sampling one text field in one table | | [[JDatabaseMySQLi-getEscaped|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-getEscaped|getEscaped]] | Get a database escaped string | | [[JDatabaseMySQLi-getNumRows|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-getNumRows|getNumRows]] | | | [[JDatabaseMySQLi-getTableCreate|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-getTableCreate|getTableCreate]] | | | [[JDatabaseMySQLi-getTableFields|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-getTableFields|getTableFields]] | | | [[JDatabaseMySQLi-getTableList|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-getTableList|getTableList]] | | | [[JDatabaseMySQLi-getVersion|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-getVersion|getVersion]] | | | [[JDatabaseMySQLi-hasUTF|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-hasUTF|hasUTF]] | Determines UTF support | | [[JDatabaseMySQLi-insertid|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-insertid|insertid]] | | | [[JDatabaseMySQLi-insertObject|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-insertObject|insertObject]] | Inserts a row into a table based on an objects properties | | [[JDatabaseMySQLi-loadAssoc|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-loadAssoc|loadAssoc]] | Fetch a result row as an associative array
return array
| | [[JDatabaseMySQLi-loadAssocList|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-loadAssocList|loadAssocList]] | Load a assoc list of database rows | | [[JDatabaseMySQLi-loadObject|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-loadObject|loadObject]] | This global function loads the first row of a query into an objectreturn object
| | [[JDatabaseMySQLi-loadObjectList|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-loadObjectList|loadObjectList]] | Load a list of database objects | | [[JDatabaseMySQLi-loadResult|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-loadResult|loadResult]] | This method loads the first field of the first row returned by the query. | | [[JDatabaseMySQLi-loadResultArray|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-loadResultArray|loadResultArray]] | Load an array of single field results into an array | | [[JDatabaseMySQLi-loadRow|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-loadRow|loadRow]] | | | [[JDatabaseMySQLi-loadRowList|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-loadRowList|loadRowList]] | Load a list of database rows (numeric column indexing) | | [[JDatabaseMySQLi-query|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-query|query]] | Execute the query | | [[JDatabaseMySQLi-queryBatch|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-queryBatch|queryBatch]] | Execute a batch query | | [[JDatabaseMySQLi-select|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-select|select]] | Select a database for use | | [[JDatabaseMySQLi-setUTF|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-setUTF|setUTF]] | Custom settings for UTF support | | [[JDatabaseMySQLi-test|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-test|test]] | Test to see if the MySQLi connector is available | | [[JDatabaseMySQLi-updateObject|{{references:Method.png?nolink}}]] [[JDatabaseMySQLi-updateObject|updateObject]] | Document::db_updateObject() | ---- ~~DISCUSSION~~