CI_DB_utility Class Reference

Inheritance diagram for CI_DB_utility:

Public Member Functions
	__construct ()
	list_databases ()
	database_exists ($database_name)
	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 Member Functions inherited from CI_DB_forge
	__construct ()
	create_database ($db_name)
	drop_database ($db_name)
	add_key ($key= '', $primary=FALSE)
	add_field ($field= '')
	create_table ($table= '', $if_not_exists=FALSE)
	drop_table ($table_name)
	rename_table ($table_name, $new_table_name)
	add_column ($table= '', $field=array(), $after_field= '')
	drop_column ($table= '', $column_name= '')
	modify_column ($table= '', $field=array())
	_reset ()

Data Fields
	$db
	$data_cache = array()
Data Fields inherited from CI_DB_forge
	$fields = array()
	$keys = array()
	$primary_keys = array()
	$db_char_set = ''

Constructor & Destructor Documentation

__construct

(

)

Constructor

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

Member Function Documentation

backup

(

$params = array())

Database Backup

public

Returns

void

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

database_exists

(

$database_name)

Determine if a particular database exists

public

Parameters

string

Returns

boolean

list_databases

(

)

List databases

public

Returns

bool

optimize_database

(

)

Optimize Database

public

Returns

array

optimize_table

(

$table_name)

Optimize Table

public

Parameters

string

the table name

Returns

bool

repair_table

(

$table_name)

Repair Table

public

Parameters

string

the table name

Returns

bool

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

---

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

• system/database/DB_utility.php