PHP Class CI_DB_utility, TastyIgniter

See link: http://codeigniter.com/user_guide/database/
Author: ExpressionEngine Dev Team
Inheritance: extends CI_DB_forge
显示文件 Open project: tastyigniter/tastyigniter Class Usage Examples

Protected Properties

Property Type Description
$_list_databases string List databases statement
$_optimize_table string OPTIMIZE TABLE statement
$_repair_table string REPAIR TABLE statement
$db object Database object

Public Methods

Method Description
__construct ( &$db ) : void Class constructor
backup ( array $params = [] ) : string Database Backup
csv_from_result ( object $query, string $delim = ',', string $newline = " ", string $enclosure = '"' ) : string Generate CSV from a query result object
database_exists ( string $database_name ) : boolean Determine if a particular database exists
list_databases ( ) : array List databases
optimize_database ( ) : mixed Optimize Database
optimize_table ( string $table_name ) : mixed Optimize Table
repair_table ( string $table_name ) : mixed Repair Table
xml_from_result ( object $query, array $params = [] ) : string Generate XML data from a query result object

Method Details

__construct() public method

Class constructor
public __construct ( &$db ) : void
return void

backup() public method

Database Backup
public backup ( array $params = [] ) : string
$params array
return string

csv_from_result() public method

Generate CSV from a query result object
public csv_from_result ( object $query, string $delim = ',', string $newline = " ", string $enclosure = '"' ) : string
$query object Query result object
$delim string Delimiter (default: ,)
$newline string Newline character (default: \n)
$enclosure string Enclosure (default: ")
return string

database_exists() public method

Determine if a particular database exists
public database_exists ( string $database_name ) : boolean
$database_name string
return boolean

list_databases() public method

List databases
public list_databases ( ) : array
return array

optimize_database() public method

Optimize Database
public optimize_database ( ) : mixed
return mixed

optimize_table() public method

Optimize Table
public optimize_table ( string $table_name ) : mixed
$table_name string
return mixed

repair_table() public method

Repair Table
public repair_table ( string $table_name ) : mixed
$table_name string
return mixed

xml_from_result() public method

Generate XML data from a query result object
public xml_from_result ( object $query, array $params = [] ) : string
$query object Query result object
$params array Any preferences
return string

Property Details

$_list_databases protected_oe property

List databases statement
protected string $_list_databases
return string

$_optimize_table protected_oe property

OPTIMIZE TABLE statement
protected string $_optimize_table
return string

$_repair_table protected_oe property

REPAIR TABLE statement
protected string $_repair_table
return string

$db protected_oe property

Database object
protected object $db
return object