public function query($sql, $bind = array())
    {
        // connect to the database if needed
        $this->_connect();

        // is the $sql a Zend_Db_Select object?
        if ($sql instanceof Zend_Db_Select) {
            if (empty($bind)) {
                $bind = $sql->getBind();
            }

            $sql = $sql->assemble();
        }

        // make sure $bind to an array;
        // don't use (array) typecasting because
        // because $bind may be a Zend_Db_Expr object
        if (!is_array($bind)) {
            $bind = array($bind);
        }

        // prepare and execute the statement with profiling
        $stmt = $this->prepare($sql);
        $stmt->execute($bind);

        // return the results embedded in the prepared statement object
        $stmt->setFetchMode($this->_fetchMode);
        return $stmt;
    }
public function query($sql, $bind = array())
    {
        // connect to the database if needed
        $this->_connect();

        // is the $sql a Zend_Db_Select object?
        if ($sql instanceof Zend_Db_Select) {
            if (empty($bind)) {
                $bind = $sql->getBind();
            }

            $sql = $sql->assemble();
        }

        // make sure $bind to an array;
        // don't use (array) typecasting because
        // because $bind may be a Zend_Db_Expr object
        if (!is_array($bind)) {
            $bind = array($bind);
        }

        // prepare and execute the statement with profiling
        $stmt = $this->prepare($sql);
        $stmt->execute($bind);

        // return the results embedded in the prepared statement object
        $stmt->setFetchMode($this->_fetchMode);
        return $stmt;
    }
public function query ( $ sql , $ bind = array ( ) ) { // connect to the database if needed $ this -> _connect ( ) ; // is the $sql a Zend_Db_Select object? if ( $ sql instanceof Zend_Db_Select ) { if ( empty ( $ bind ) ) { $ bind = $ sql -> getBind ( ) ; } $ sql = $ sql -> assemble ( ) ; } // make sure $bind to an array; // don't use (array) typecasting because // because $bind may be a Zend_Db_Expr object if ( ! is_array ( $ bind ) ) { $ bind = array ( $ bind ) ; } // prepare and execute the statement with profiling $ stmt = $ this -> prepare ( $ sql ) ; $ stmt -> execute ( $ bind ) ; // return the results embedded in the prepared statement object $ stmt -> setFetchMode ( $ this -> _fetchMode ) ; return $ stmt ; }
Prepares and executes an SQL statement with bound data.

@param  mixed  $sql  The SQL statement with placeholders.
May be a string or Zend_Db_Select.
@param  mixed  $bind An array of data to bind to the placeholders.
@return Zend_Db_Statement_Interface
Prepares and executes an SQL statement with bound data .