CI_DB_utility Class Reference

Inherits CI_DB_forge.

Inherited by CI_DB_mssql_utility, CI_DB_mysql_utility, CI_DB_mysqli_utility, CI_DB_oci8_utility, CI_DB_odbc_utility, CI_DB_postgre_utility, and CI_DB_sqlite_utility.

Collaboration diagram for CI_DB_utility:

[legend]

List of all members.

Public Member Functions
	CI_DB_utility ()
	list_databases ()
	optimize_table ($table_name)
	optimize_database ()
	repair_table ($table_name)
	csv_from_result ($query, $delim=",", $newline="\n", $enclosure= '"')
	xml_from_result ($query, $params=array())
	backup ($params=array())
Public Attributes
	$db
	$data_cache = array()

---

Member Function Documentation

CI_DB_utility::backup

(

$

params = array()

)

Database Backup

public

Returns:

void

CI_DB_utility::CI_DB_utility

(

)

Constructor

Grabs the CI super object instance so we can access it.

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

Generate CSV from a query result object

public

Parameters:

	object	The query result object
	string	The delimiter - comma by default
	string	The newline character - by default
	string	The enclosure - double quote by default

Returns:

string

CI_DB_utility::list_databases

(

)

List databases

public

Returns:

bool

CI_DB_utility::optimize_database

(

)

Optimize Database

public

Returns:

array

CI_DB_utility::optimize_table

(

$

table_name

)

Optimize Table

public

Parameters:

string

the table name

Returns:

bool

CI_DB_utility::repair_table

(

$

table_name

)

Repair Table

public

Parameters:

string

the table name

Returns:

bool

CI_DB_utility::xml_from_result	(	$	query,
		$	params = array()
	)

Generate XML data from a query result object

public

Parameters:

	object	The query result object
	array	Any preferences

Returns:

string

---

Member Data Documentation

CI_DB_utility::$data_cache = array()

CI_DB_utility::$db

---

The documentation for this class was generated from the following file:

• Z:/projects/CI/system/database/DB_utility.php