Zend_Db_Statement_Mysqli Class Reference

Inheritance diagram for Zend_Db_Statement_Mysqli:

Public Member Functions
	_prepare ($sql)
	close ()
	closeCursor ()
	columnCount ()
	errorCode ()
	errorInfo ()
	_execute (array $params=null)
	fetch ($style=null, $cursor=null, $offset=null)
	nextRowset ()
	rowCount ()
Public Member Functions inherited from Zend_Db_Statement
	__construct ($adapter, $sql)
	bindColumn ($column, &$param, $type=null)
	bindParam ($parameter, &$variable, $type=null, $length=null, $options=null)
	bindValue ($parameter, $value, $type=null)
	execute (array $params=null)
	fetchAll ($style=null, $col=null)
	fetchColumn ($col=0)
	fetchObject ($class='stdClass', array $config=array())
	getAttribute ($key)
	setAttribute ($key, $val)
	setFetchMode ($mode)
	_fetchBound ($row)
	getAdapter ()
	getDriverStatement ()

Protected Member Functions
	_bindParam ($parameter, &$variable, $type=null, $length=null, $options=null)
Protected Member Functions inherited from Zend_Db_Statement
	_prepare ($sql)
	_parseParameters ($sql)
	_stripQuoted ($sql)

Protected Attributes
	$_keys
	$_values
	$_meta = null
Protected Attributes inherited from Zend_Db_Statement
	$_stmt = null
	$_adapter = null
	$_fetchMode = Zend_Db::FETCH_ASSOC
	$_attribute = array()
	$_bindColumn = array()
	$_bindParam = array()
	$_sqlSplit = array()
	$_sqlParam = array()
	$_queryId = null

Detailed Description

Definition at line 39 of file Mysqli.php.

Member Function Documentation

_bindParam()

_bindParam (   $parameter, &  $variable,   $type = null,   $length = null,   $options = null  )

protected

Binds a parameter to the specified variable name.

Parameters

mixed	$parameter	Name the parameter, either integer or string.
mixed	$variable	Reference to PHP variable containing the value.
mixed	$type	OPTIONAL Datatype of SQL parameter.
mixed	$length	OPTIONAL Length of SQL parameter.
mixed	$options	OPTIONAL Other options.

Returns

bool

Exceptions

Zend_Db_Statement_Mysqli_Exception

Definition at line 92 of file Mysqli.php.

    {
        return true;
    }

_execute()

_execute

(

array

$params = null

)

Executes a prepared statement.

Parameters

array

$params

OPTIONAL Values to bind to parameter placeholders.

Returns

bool

Exceptions

Zend_Db_Statement_Mysqli_Exception

See also

Zend_Db_Statement_Mysqli_Exception

Zend_Db_Statement_Mysqli_Exception

Definition at line 183 of file Mysqli.php.

    {
        if (!$this->_stmt) {
            return false;
        }

        // if no params were given as an argument to execute(),
        // then default to the _bindParam array
        if ($params === null) {
            $params = $this->_bindParam;
        }
        // send $params as input parameters to the statement
        if ($params) {
            array_unshift($params, str_repeat('s', count($params)));
            $stmtParams = array();
            foreach ($params as $k => &$value) {
                $stmtParams[$k] = &$value;
            }
            call_user_func_array(
                array($this->_stmt, 'bind_param'),
                $stmtParams
                );
        }

        // execute the statement
        $retval = $this->_stmt->execute();
        if ($retval === false) {
            #require_once 'Zend/Db/Statement/Mysqli/Exception.php';
            throw new Zend_Db_Statement_Mysqli_Exception("Mysqli statement execute error : " . $this->_stmt->error, $this->_stmt->errno);
        }


        // retain metadata
        if ($this->_meta === null) {
            $this->_meta = $this->_stmt->result_metadata();
            if ($this->_stmt->errno) {
                #require_once 'Zend/Db/Statement/Mysqli/Exception.php';
                throw new Zend_Db_Statement_Mysqli_Exception("Mysqli statement metadata error: " . $this->_stmt->error, $this->_stmt->errno);
            }
        }

        // statements that have no result set do not return metadata
        if ($this->_meta !== false) {

            // get the column names that will result
            $this->_keys = array();
            foreach ($this->_meta->fetch_fields() as $col) {
                $this->_keys[] = $this->_adapter->foldCase($col->name);
            }

            // set up a binding space for result variables
            $this->_values = array_fill(0, count($this->_keys), null);

            // set up references to the result binding space.
            // just passing $this->_values in the call_user_func_array()
            // below won't work, you need references.
            $refs = array();
            foreach ($this->_values as $i => &$f) {
                $refs[$i] = &$f;
            }

            $this->_stmt->store_result();
            // bind to the result variables
            call_user_func_array(
                array($this->_stmt, 'bind_result'),
                $this->_values
            );
        }
        return $retval;
    }

_prepare()

_prepare

(

$sql

)

Parameters

string

$sql

Returns

void

Exceptions

Zend_Db_Statement_Mysqli_Exception

See also

Zend_Db_Statement_Mysqli_Exception

Definition at line 66 of file Mysqli.php.

    {
        $mysqli = $this->_adapter->getConnection();

        $this->_stmt = $mysqli->prepare($sql);

        if ($this->_stmt === false || $mysqli->errno) {
            #require_once 'Zend/Db/Statement/Mysqli/Exception.php';
            throw new Zend_Db_Statement_Mysqli_Exception("Mysqli prepare error: " . $mysqli->error, $mysqli->errno);
        }
    }

close()

close

(

)

Closes the cursor and the statement.

Returns

bool

Definition at line 102 of file Mysqli.php.

    {
        if ($this->_stmt) {
            $r = $this->_stmt->close();
            $this->_stmt = null;
            return $r;
        }
        return false;
    }

closeCursor()

closeCursor

(

)

Closes the cursor, allowing the statement to be executed again.

Returns

bool

Implements Zend_Db_Statement_Interface.

Definition at line 117 of file Mysqli.php.

    {
        if ($stmt = $this->_stmt) {
            $mysqli = $this->_adapter->getConnection();
            while ($mysqli->more_results()) {
                $mysqli->next_result();
            }
            $this->_stmt->free_result();
            return $this->_stmt->reset();
        }
        return false;
    }

columnCount()

columnCount

(

)

Returns the number of columns in the result set. Returns null if the statement has no result set metadata.

Returns

int The number of columns.

Implements Zend_Db_Statement_Interface.

Definition at line 136 of file Mysqli.php.

    {
        if (isset($this->_meta) && $this->_meta) {
            return $this->_meta->field_count;
        }
        return 0;
    }

errorCode()

errorCode

(

)

Retrieves the error code, if any, associated with the last operation on the statement handle.

Returns

string error code.

Implements Zend_Db_Statement_Interface.

Definition at line 150 of file Mysqli.php.

    {
        if (!$this->_stmt) {
            return false;
        }
        return substr($this->_stmt->sqlstate, 0, 5);
    }

errorInfo()

errorInfo

(

)

Retrieves an array of error information, if any, associated with the last operation on the statement handle.

Returns

array

Implements Zend_Db_Statement_Interface.

Definition at line 164 of file Mysqli.php.

    {
        if (!$this->_stmt) {
            return false;
        }
        return array(
            substr($this->_stmt->sqlstate, 0, 5),
            $this->_stmt->errno,
            $this->_stmt->error,
        );
    }

fetch()

fetch	(		$style = null,
			$cursor = null,
			$offset = null
	)

Fetches a row from the result set.

Parameters

int	$style	OPTIONAL Fetch mode for this fetch operation.
int	$cursor	OPTIONAL Absolute, relative, or other.
int	$offset	OPTIONAL Number for absolute or relative cursors.

Returns

mixed Array, object, or scalar depending on fetch mode.

Exceptions

Zend_Db_Statement_Mysqli_Exception

See also

Zend_Db_Statement_Mysqli_Exception

Implements Zend_Db_Statement_Interface.

Definition at line 270 of file Mysqli.php.

    {
        if (!$this->_stmt) {
            return false;
        }
        // fetch the next result
        $retval = $this->_stmt->fetch();
        switch ($retval) {
            case null: // end of data
            case false: // error occurred
                $this->_stmt->reset();
                return false;
            default:
                // fallthrough
        }

        // make sure we have a fetch mode
        if ($style === null) {
            $style = $this->_fetchMode;
        }

        // dereference the result values, otherwise things like fetchAll()
        // return the same values for every entry (because of the reference).
        $values = array();
        foreach ($this->_values as $key => $val) {
            $values[] = $val;
        }

        $row = false;
        switch ($style) {
            case Zend_Db::FETCH_NUM:
                $row = $values;
                break;
            case Zend_Db::FETCH_ASSOC:
                $row = array_combine($this->_keys, $values);
                break;
            case Zend_Db::FETCH_BOTH:
                $assoc = array_combine($this->_keys, $values);
                $row = array_merge($values, $assoc);
                break;
            case Zend_Db::FETCH_OBJ:
                $row = (object) array_combine($this->_keys, $values);
                break;
            case Zend_Db::FETCH_BOUND:
                $assoc = array_combine($this->_keys, $values);
                $row = array_merge($values, $assoc);
                return $this->_fetchBound($row);
                break;
            default:
                #require_once 'Zend/Db/Statement/Mysqli/Exception.php';
                throw new Zend_Db_Statement_Mysqli_Exception("Invalid fetch mode '$style' specified");
                break;
        }
        return $row;
    }

nextRowset()

nextRowset

(

)

Retrieves the next rowset (result set) for a SQL statement that has multiple result sets. An example is a stored procedure that returns the results of multiple queries.

Returns

bool

Exceptions

Zend_Db_Statement_Mysqli_Exception

See also

Zend_Db_Statement_Mysqli_Exception

Implements Zend_Db_Statement_Interface.

Definition at line 337 of file Mysqli.php.

    {
        #require_once 'Zend/Db/Statement/Mysqli/Exception.php';
        throw new Zend_Db_Statement_Mysqli_Exception(__FUNCTION__.'() is not implemented');
    }

rowCount()

rowCount

(

)

Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.

Returns

int The number of rows affected.

Implements Zend_Db_Statement_Interface.

Definition at line 353 of file Mysqli.php.

    {
        if (!$this->_adapter) {
            return false;
        }
        $mysqli = $this->_adapter->getConnection();
        return $mysqli->affected_rows;
    }

Field Documentation

$_keys

$_keys

protected

Definition at line 47 of file Mysqli.php.

$_meta

$_meta = null

protected

Definition at line 59 of file Mysqli.php.

$_values

$_values

protected

Definition at line 54 of file Mysqli.php.

---

The documentation for this class was generated from the following file:

• vendor/magento/zendframework1/library/Zend/Db/Statement/Mysqli.php