设置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
public function set_builder(array $builder)
{
$this->_builder = array_merge($this->_builder, $builder);
return $this;
}