Gitee
\

\CI_DB_mysql_utility

MySQL Utility Class

Summary

Methods
Properties
Constants
__construct()
list_databases()
database_exists()
optimize_table()
optimize_database()
repair_table()
csv_from_result()
xml_from_result()
backup()
No public properties found
No constants found
_backup()
$db
$_list_databases
$_optimize_table
$_repair_table
N/A
No private methods found
No private properties found
N/A

Properties

$db

$db : object

Database object

Type

object

$_list_databases

$_list_databases : string

List databases statement

Type

string

$_optimize_table

$_optimize_table : string

OPTIMIZE TABLE statement

Type

string

$_repair_table

$_repair_table : string

REPAIR TABLE statement

Type

string

Methods

__construct()

__construct(  $db) : void

Class constructor

Parameters

$db

list_databases()

list_databases() : array

List databases

Returns

array

database_exists()

database_exists(string  $database_name) : boolean

Determine if a particular database exists

Parameters

string $database_name

Returns

boolean

optimize_table()

optimize_table(string  $table_name) : mixed

Optimize Table

Parameters

string $table_name

Returns

mixed

optimize_database()

optimize_database() : mixed

Optimize Database

Returns

mixed

repair_table()

repair_table(string  $table_name) : mixed

Repair Table

Parameters

string $table_name

Returns

mixed

csv_from_result()

csv_from_result(object  $query, string  $delim = ',', string  $newline = "\n", string  $enclosure = '"') : string

Generate CSV from a query result object

Parameters

object $query

Query result object
string $delim

Delimiter (default: ,)
string $newline

Newline character (default: \n)
string $enclosure

Enclosure (default: ")

Returns

string

xml_from_result()

xml_from_result(object  $query, array  $params = array()) : string

Generate XML data from a query result object

Parameters

object $query

Query result object
array $params

Any preferences

Returns

string

backup()

backup(array  $params = array()) : string

Database Backup

Parameters

array $params

Returns

string

_backup()

_backup(array  $params = array()) : mixed

Export

Parameters

array $params

Preferences

Returns

mixed