Module_Database
    └ Module_Database_QueryBuilder

API - Module_Database

• Database::instance - 返回数据库实例化对象
• Database::__construct - new Database('default');
• Database::__destruct
• Database::driver - 获取驱动引擎对象
• Database::config - 获取当前配置数组
• Database::close_connect - 关闭连接
• Database::query - 执行SQL查询
• Database::table_prefix - 返回当前表前缀
• Database::compile - 解析为SQL语句
• Database::get - 获取数据
• Database::get_one - 获取一条数据
• Database::last_query - 最后查询的SQL语句
• Database::update - 更新数据
• Database::insert - 插入数据
• Database::delete - 删除数据
• Database::count_records - 统计指定条件的数量
• Database::replace - 替换数据 replace into
• Database::merge - 替换数据 replace into
• Database::transaction - 获取事务对象
• Database::auto_use_master - 设置是否一直在主数据库上查询
• Database::is_auto_use_master - 是否一直用主数据库查询
• Database::create_database - 创建一个数据库
• Database::parse_dsn - 解析DSN路径格式
• Database::close_all_connect - 关闭全部数据库链接

继承自父类的方法和变量

• Database_QueryBuilder::get_builder - 获取Builder配置
• Database_QueryBuilder::set_builder - 设置Builder信息
• Database_QueryBuilder::distinct - 构成查询 SELECT DISTINCT
• Database_QueryBuilder::select - select(c1, c2, c3,......)
• Database_QueryBuilder::select_array - Choose the columns to select from, using an array.
• Database_QueryBuilder::select_max - 查询最大值
• Database_QueryBuilder::select_min - 查询平均值
• Database_QueryBuilder::select_avg - 查询平均值
• Database_QueryBuilder::select_sum - 查询总和
• Database_QueryBuilder::select_adv - 高级查询方式
• Database_QueryBuilder::columns - Set the columns that will be inserted.
• Database_QueryBuilder::values - 加入多条数据
• Database_QueryBuilder::set - 为update,insert设置数据
• Database_QueryBuilder::value - Set the value of a single column.
• Database_QueryBuilder::value_increment - 数据递增
• Database_QueryBuilder::value_decrement - 数据递减
• Database_QueryBuilder::table - Sets the table to update.
• Database_QueryBuilder::from - from(tableA,tableB,...)
• Database_QueryBuilder::join - Adds addition tables to "JOIN ...".
• Database_QueryBuilder::on - Adds "ON ..." conditions for the last created JOIN statement.
• Database_QueryBuilder::group_by - group_by(c1,c2,c3,.....)
• Database_QueryBuilder::having - Alias of and_having()
• Database_QueryBuilder::and_having - Creates a new "AND HAVING" condition for the query.
• Database_QueryBuilder::or_having - Creates a new "OR HAVING" condition for the query.
• Database_QueryBuilder::having_open - Alias of and_having_open()
• Database_QueryBuilder::and_having_open - Opens a new "AND HAVING (...)" grouping.
• Database_QueryBuilder::or_having_open - Opens a new "OR HAVING (...)" grouping.
• Database_QueryBuilder::having_close - Closes an open "AND HAVING (...)" grouping.
• Database_QueryBuilder::and_having_close - Closes an open "AND HAVING (...)" grouping.
• Database_QueryBuilder::or_having_close - Closes an open "OR HAVING (...)" grouping.
• Database_QueryBuilder::offset - Start returning results after "OFFSET ..."
• Database_QueryBuilder::reset - 重设数据
• Database_QueryBuilder::in
• Database_QueryBuilder::notin
• Database_QueryBuilder::where - Alias of and_where()
• Database_QueryBuilder::and_where - Creates a new "AND WHERE" condition for the query.
• Database_QueryBuilder::or_where - Creates a new "OR WHERE" condition for the query.
• Database_QueryBuilder::where_open - Alias of and_where_open()
• Database_QueryBuilder::and_where_open - Opens a new "AND WHERE (...)" grouping.
• Database_QueryBuilder::or_where_open - Opens a new "OR WHERE (...)" grouping.
• Database_QueryBuilder::where_close - Closes an open "AND WHERE (...)" grouping.
• Database_QueryBuilder::and_where_close - Closes an open "AND WHERE (...)" grouping.
• Database_QueryBuilder::or_where_close - Closes an open "OR WHERE (...)" grouping.
• Database_QueryBuilder::order_by - Applies sorting with "ORDER BY ..."
• Database_QueryBuilder::limit - Return up to "LIMIT ..." results
• Database_QueryBuilder::like - 返回 "LIKE ..."
• Database_QueryBuilder::or_like - 返回 "OR LIKE ..."
• Database_QueryBuilder::mod - 返回 "$column MOD $mod = $value"
• Database_QueryBuilder::or_mod - 返回 "OR $column MOD $mod = $value"
• Database_QueryBuilder::use_index - 使用指定索引
• Database_QueryBuilder::force_index - 强制使用指定索引
• Database_QueryBuilder::ignore_index - 或略指定索引
• Database_QueryBuilder::recovery_last_builder - 恢复最后查询或reset时的Builder数据
• Database_QueryBuilder::expr_value - 创建一个不会被过滤处理的字符串

非Public项目

• Database::$instances
• Database::$config - 当前配置
• Database::$driver - 当前驱动
• Database::$_connection - 数据库连接对象
• Database::$is_auto_use_master - 是否自动使用主数据库
• Database::$slow_querys - 记录慢查询
• Database_QueryBuilder::$_builder - Builder数组
• Database_QueryBuilder::$_builder_bak - Builder备份
• Database_QueryBuilder::$_last_join
• Database::save_slow_query - 记录慢查询

隐藏其它非Public项目

显示其它非Public项目

author

呼吸二氧化碳 jonwang@myqee.com

category

MyQEE

package

Module

subpackage

Database

copyright

Copyright © 2008-2013 myqee.com

license

http://www.myqee.com/license.html

Database::instance( $config_name = null)

参数列表

返回值

• Database

 // 设置一样的builder
 $db->from('mytable')->where('id>', 10)->limit(10)->order_by('id', 'DESC');

 // 获取当前builder
 $builder = $db->get_builder();

 // 执行查询
 $data1 = $db->where('type', 1)->get()->as_array();
 echo $db->last_query();     //SELECT * FROM `mytable` WHERE `id` > 10 AND `type` = '1' ORDER BY `id` DESC LIMIT 10

 // 将前面获取的builder重新设置回去
 $db->set_builder($builder);

 // 再次执行另外一个附加条件的查询
 $data2 = $db->where('type', 3)->get()->as_array();
 echo $db->last_query();     //SELECT * FROM `mytable` WHERE `id` > 10 AND `type` = '3' ORDER BY `id` DESC LIMIT 10

 $db->select('id', 'username')->from('members')->get()->as_array();
 echo $db->last_query();     //SELECT `id`, `username` FROM `members`;

 $db->select('db1.id', 'db2.username')->from('members as db1')->join('mydb as db2')->on('db1.id', 'db2.mid')->get()->as_array();
 echo $db->last_query();     //SELECT `db1`.`id`, `db2`.`username` FROM `members` AS `db1` JOIN ON `db1`.`id` = `db2`.`mid`;

 // 使用Database::expr_value()方法可以传入一个不被解析的字符串
 $db->select(Database::expr_value('SUM("id") as `id`'))->from('members')->get()->as_array();
 echo $db->last_query();     //SELECT SUM("id") as `id` FROM `members`;

// 例1
$v1 = array('k1'=>1,'k2'=>1);
$v2 = array('k1'=>2,'k2'=>1);
$v3 = array('k1'=>3,'k2'=>1);
$db->values($v1,$v2,$v3);        //加入3行数据

// 例2
$values = array();
$values[] = array('k1'=>1,'k2'=>1);
$values[] = array('k1'=>2,'k2'=>1);
$values[] = array('k1'=>3,'k2'=>1);
$db->values($values);            //加入3行数据,等同上面的效果

 $db->from('mydb')->where('id', 1)->get()->as_array();    // 执行查询
 $db->recovery_last_builder();                            // 恢复

 $db->from('mydb')->where('id', 1);

 $builder = $db->get_builder();      // 在执行前获取builder设置
 $db->get()->as_array();             // 执行查询
 $db->set_builder($builder);         // 将前面获取的builder重新复原

 $count = $db->from('mydb')->where('id', 10, '>')->count_records();
 // 在执行count_records()时，所有的builder数据将会被清空
 echo $db->last_query();   // SELECT COUNT(1) AS `total_row_count` FROM `mydb` WHERE `id` > '10'

 // 恢复builder
 $db->recovery_last_builder();
 $db->limit(20)->order_by('id', 'DESC')->get()->as_array();

 echo $db->last_query();   // SELECT * FROM `mydb` WHERE `id` > '10' ORDER BY `id` DESC LIMIT 10