public function arrayPrepare($query, array $input_parameters) {
        $query = str_replace("\n", "", $query);

        $params = array();
        foreach ($input_parameters as $key => $value) {
            if (is_array($value)) {
                $implode = '';
                $delim = '';
                foreach ($value as $valueKey => $valueValue) {
                    $params[$key . '_' . $valueKey] = $valueValue;
                    $implode.= $delim . $key . '_' . $valueKey;
                    $delim = ', ';
                }
                $query = str_replace($key, $implode, $query);
            } else {
                $params[$key] = $value;
            }
        }

        try {
            $statement = $this->prepare($query);
        } catch (Exception $exc) {
            throw new Exception($query."\n".$this->errorInfo());
        }

        foreach ($params as $key => $value) {
            //echo "bind $key => $value\n";
            $statement->bindValue($key, $value)."\n";
        }
        return $statement;
    }