allejo / bzion

     * @param  mixed|array $params    (Optional) The array of values that will be binded to the prepared statement

     * @return int         Returns the number of rows affected

     */

    public function execute($queryText, $params = false)

    {

        if (!is_array($params)) {

            $params = array($params);

        }

        $debug = new DatabaseQuery($queryText, $params);

        $query = $this->doQuery($queryText, $params);

        $return = $query->rowCount();

        $debug->finish($return);

        return $return;

    }

    /**

     * Prepares and executes a MySQL prepared SELECT statement. <em>The second parameter is optional when using this function to execute a query with no placeholders.</em>

     * @param  mixed|array $params    (Optional) The array of values that will be binded to the prepared statement

     * @return array       Returns an array of the values received from the query

     */

    public function query($queryText, $params = false)

    {

        if (!is_array($params)) {

            $params = array($params);

        }

        $debug = new DatabaseQuery($queryText, $params);

        $return = $this->doQuery($queryText, $params)->fetchAll();

        $debug->finish($return);

        return $return;

    }

    /**

     * Perform a query