选择语言 :

 Module_Database_QueryBuilder::set_builder

设置Builder信息

 // 设置一样的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
Database Module_Database_QueryBuilder::set_builder( array $builder )

参数列表

参数 类型 描述 默认值
$builder array Builder信息数组,不必完整的,建议通过get_builder()获取后设置
返回值
  • Database
File: ./modules/database/querybuilder.class.php
public function set_builder(array $builder)
{
    $this->_builder = array_merge($this->_builder, $builder);

    return $this;
}