mambax7 / smartfaq

     *

     * @return array

     */

    public function getAllChildId($selectId, $order = '', array $idarray = [])

    {

        $selectId = (int)$selectId;

        $sql      = 'SELECT ' . $this->id . ' FROM ' . $this->table . ' WHERE ' . $this->pid . '=' . $selectId . '';

        if ('' !== $order) {

            $sql .= " ORDER BY $order";

        }

        $result = $this->db->query($sql);

        $count  = $this->db->getRowsNum($result);

        if (0 == $count) {

            return $idarray;

        }

        while (false !== (list($r_id) = $this->db->fetchRow($result))) {

            array_push($idarray, $r_id);

            $idarray = $this->getAllChildId($r_id, $order, $idarray);

        }

        return $idarray;

    }

    //returns an array of ALL parent ids for a given id($selectId)

     *

     * @return array

     */

    public function getAllChild($selectId = 0, $order = '', array $parray = [])

    {

        $selectId = (int)$selectId;

        $sql      = 'SELECT * FROM ' . $this->table . ' WHERE ' . $this->pid . '=' . $selectId . '';

        if ('' !== $order) {

            $sql .= " ORDER BY $order";

        }

        $result = $this->db->query($sql);

        $count  = $this->db->getRowsNum($result);

        if (0 == $count) {

            return $parray;

        }

        while (false !== ($row = $this->db->fetchArray($result))) {

            array_push($parray, $row);

            $parray = $this->getAllChild($row[$this->id], $order, $parray);

        }

        return $parray;

    }

    /**

     * Enter description here...