Documentation

// 生成されるクエリ: SELECT * FROM `users`
$query = DB::query('SELECT * FROM `users`');

// get the default connection
$db = DB::instance();

// get a named connection
$db = DB::instance('backup');

// クエリを実行する
$user = DB::select()->from('users')->where('id', 1)->execute();

echo DB::last_query();
// SELECT * FROM `users` WHERE `id` = 1

// 生成されるクエリ: SELECT *
$query = DB::select();

// 生成されるクエリ: SELECT `id`, `name`
$query = DB::select('id', 'name');

// 生成されるクエリ: SELECT *
$query = DB::select_array();

// 生成されるクエリ: SELECT `id`, `name`
$query = DB::select_array(array('id', 'name'));

// 生成されるクエリ: INSERT INTO `table_name`
$query = DB::insert('table_name');

// 生成されるクエリ: INSERT INTO `table_name` (`id`, `name`)
$query = DB::insert('table_name', array('id', 'name'));

// 生成されるクエリ: UPDATE `table_name`
$query = DB::update('table_name');

// 生成されるクエリ: DELETE FROM `table_name`
$query = DB::delete('table_name');

// 返り値: Database_Expression('COUNT(table_name.table_column)');
$expr = DB::expr('COUNT(table_name.table_column)');

// 生成されるクエリの意図しない位置にクオートが付かないようにする
$expr = DB::expr('columnname + 1');

// 返り値: 'something\'s quoted'
$query = DB::quote("'something's quoted'");

// 返り値: 'something\'s quoted' (定義済みのデータベースコネクションで)
$query = DB::quote("'something's quoted'", $db_connection);

// `users`.`name`
print_r(DB::quote_identifier('users.name'));

// array(
//    [0] => `users`.`name`
// )
print_r(DB::quote_identifier(array('users.name')));

// `users`
print_r(DB::quote_table('users'));

// array(
//    [0] => `users`
// )
print_r(DB::quote_identifier(array('users')));

// prefixed_table_name
print_r(DB::table_prefix('table_name'));

// 'or *\' \"'
print_r(DB::escape('or *\' "'));

/*
Array
(
	[id] => Array
	(
		[type] => int
		[min] => -2147483648
		[max] => 2147483647
		[column_name] => id
		[column_default] =>
		[data_type] => int
		[is_nullable] =>
		[ordinal_position] => 1
		[display] => 255
		[comment] =>
		[extra] => auto_increment
		[key] => PRI
		[privileges] => select,insert,update,references
	)

	[name] => Array
	(
		[type] => string
		[column_name] => name
		[column_default] =>
		[data_type] => varchar
		[is_nullable] =>
		[ordinal_position] => 3
		[character_maximum_length] => 255
		[collation_name] => utf8_unicode_ci
		[comment] =>
		[extra] =>
		[key] =>
		[privileges] => select,insert,update,references
	)
)
*/
print_r(DB::list_columns('users'));

/*
Array
(
	[name] => Array
	(
		[type] => string
		[column_name] => name
		[column_default] =>
		[data_type] => varchar
		[is_nullable] =>
		[ordinal_position] => 3
		[character_maximum_length] => 255
		[collation_name] => utf8_unicode_ci
		[comment] =>
		[extra] =>
		[key] =>
		[privileges] => select,insert,update,references
	)
)
*/
print_r(DB::list_columns('users','%name%'));

/*
Array
(
    [name] => PRIMARY
    [column] => id
    [order] => 1
    [type] => BTREE
    [primary] => true
    [unique] => true
    [null] => false
    [ascending] => true
)
Array
(
    [name] => TypeValue
    [column] => type
    [order] => 1
    [type] => BTREE
    [primary] => false
    [unique] => true
    [null] => false
    [ascending] => true
)
Array
(
    [name] => TypeValue
    [column] => value
    [order] => 2
    [type] => BTREE
    [primary] => false
    [unique] => true
    [null] => false
    [ascending] => true
)

// here, TypeValue is a compound index with two columns, the order indicates
// the sequence in which the columns are defined in the index

*/
print_r(DB::list_columns('table'));

/*
Array
(
    [name] => TypeValue
    [column] => type
    [order] => 1
    [type] => BTREE
    [primary] =>
    [unique] => 1
    [null] =>
    [ascending] => 1
)
Array
(
    [name] => TypeValue
    [column] => value
    [order] => 2
    [type] => BTREE
    [primary] =>
    [unique] => 1
    [null] =>
    [ascending] => 1
)
*/
print_r(DB::list_columns('table','%Value%'));

/*
Array
(
    [0] => areas
    [1] => fuel_sessions
    [2] => config
    [3] => files
)
*/
DB::list_tables();

/*
Array
(
    [0] => fuel_sessions

)
*/
DB::list_tables('%sessions%');

/*
Array
(
    [type] => string
    [exact] => 1
)
*/
DB::datatype('char');

// (int) 14
DB::count_records('users');

// SELECT * FROM `users` WHERE `active` = "yes" LIMIT 10;
$limited_result = DB::select()->from('users')->where('active', '=', 'yes')->limit(10)->execute();

// SELECT count(*) as count FROM `users` WHERE `active` = "yes";
DB::count_last_query();

DB::set_charset('utf8');

$lasterror = DB::error_info();

DB::in_transaction();

DB::start_transaction();

DB::commit_transaction();

DB::rollback_transaction();