fwolf / fwlib

     * @param   mixed   $param

     * @return  string

     */

    public function setDelete($param)

    {

        $this->paramPart['DELETE'] = $param;

        $this->sqlPart['DELETE'] = 'DELETE FROM ' . $param;

        return $this->sqlPart['DELETE'];

    }

    /**

     * @param   mixed   $param

     * @return  string

     */

    public function setGroupby($param)

    {

        $this->paramPart['GROUPBY'] = $param;

        $this->sqlPart['GROUPBY'] = ' GROUP BY ' . $this->genSqlArray($param);

        return $this->sqlPart['GROUPBY'];

    }

    /**

     * @param   mixed   $param

     * @return  string

     */

    public function setHaving($param)

    {

        $this->paramPart['HAVING'] = $param;

        // Add '(' to defend sql injection

        $this->sqlPart['HAVING'] = ' HAVING ('

            . $this->genSqlArray($param, ') AND (') . ')';

        return $this->sqlPart['HAVING'];

    }

    /**

     * @param   mixed   $param

     * @return  string

     */

    public function setOrderby($param)

    {

        $this->paramPart['ORDERBY'] = $param;

        $this->sqlPart['ORDERBY'] = ' ORDER BY ' . $this->genSqlArray($param);

        return $this->sqlPart['ORDERBY'];

    }

    /**

     * @param   mixed   $param

     * @return  string

     */

    public function setSet($param)

    {

        $this->paramPart['SET'] = $param;

        // For UPDATE only, INSERT uses VALUES

        // User give param array(col => value)

        $this->sqlPart['SET'] = $this->genSqlArraySet($param);

        return $this->sqlPart['SET'];

    }

    /**

     * @param   mixed   $param

     * @return  string

     */

    public function setWhere($param)

    {

        $this->paramPart['WHERE'] = $param;

        // Add '(' to defend sql injection

        $this->sqlPart['WHERE'] = ' WHERE ('

            . $this->genSqlArray($param, ') AND (') . ')';

        return $this->sqlPart['WHERE'];

    }

}