| Fully Qualified Name: | CodeIgniter\Database\MySQLi\Utils |
| Extends: | BaseUtils |
Utils for MySQLi
| Name | Description | Defined By |
|---|---|---|
| __construct() | Class constructor | BaseUtils |
| _backup() | Platform dependent version of the backup function. | Utils |
| backup() | Database Backup | BaseUtils |
| databaseExists() | Determine if a particular database exists | BaseUtils |
| getCSVFromResult() | Generate CSV from a query result object | BaseUtils |
| getXMLFromResult() | Generate XML data from a query result object | BaseUtils |
| listDatabases() | List databases | BaseUtils |
| optimizeDatabase() | Optimize Database | BaseUtils |
| optimizeTable() | Optimize Table | BaseUtils |
| repairTable() | Repair Table | BaseUtils |
Class constructor
| Parameter Name | Type | Description |
|---|---|---|
| $db | \ConnectionInterface|object |
Returns:
Platform dependent version of the backup function.
| Parameter Name | Type | Description |
|---|---|---|
| $prefs | array|null |
Returns: mixed
Database Backup
| Parameter Name | Type | Description |
|---|---|---|
| $params | array|string |
Returns: mixed
Determine if a particular database exists
| Parameter Name | Type | Description |
|---|---|---|
| $database_name | string |
Returns: bool
Generate CSV from a query result object
| Parameter Name | Type | Description |
|---|---|---|
| $query | \ResultInterface | Query |
| $delim | string | Delimiter |
| $newline | string | Newline |
| $enclosure | string | Enclosure |
Returns: string
Generate XML data from a query result object
| Parameter Name | Type | Description |
|---|---|---|
| $query | \ResultInterface | Query |
| $params | array | Any |
Returns: string
List databases
Returns: array|bool
Optimize Database
Returns: mixed
Optimize Table
| Parameter Name | Type | Description |
|---|---|---|
| $table_name | string |
Returns: mixed
Repair Table
| Parameter Name | Type | Description |
|---|---|---|
| $table_name | string |
Returns: mixed