/** * @name fetchAll * @desc 执行SQL语句并返回全部数据 * @param string $sql 要执行的sql语句 * @param string $id 主键 * @return array * @access public **/ public function fetchAll($sql, $id = '') { $begin_microtime = Debug::getTime(); try { $info = $this->db->fetchAll($sql, $id); } catch (Exception $e) { $this->halt($e, $sql); return false; } Debug::db($this->db_host, $this->db_name, $sql, Debug::getTime() - $begin_microtime, $info); return $info; }
/** * 获取所有子孙ID * * @param integer $cateId * @return array */ public function getAllChilds($cateId) { $childs = array(); $select = $this->db->select()->from('category', 'cate_id')->where('parent_id = ?', $cateId); $res = $this->db->fetchAll($select); foreach ($res as $r) { $childs[] = $r['cate_id']; $subChilds = self::getAllChilds($r['cate_id']); $childs = array_merge($childs, $subChilds); } return $childs; }