/**
* Closes the resource.
*/
public function close()
{
if ($this->_resource) {
$this->_resource->closeCursor();
}
unset($this->_resource);
$this->_resource = null;
$this->_data = [];
}
/**
* Method to free up the memory used for the result set.
*
* @param mixed $cursor The optional result set cursor from which to fetch the row.
*
* @return void
*
* @since 1.0
*/
protected function freeResult($cursor = null)
{
$this->executed = false;
if ($cursor instanceof \PDOStatement) {
$cursor->closeCursor();
$cursor = null;
}
if ($this->prepared instanceof \PDOStatement) {
$this->prepared->closeCursor();
$this->prepared = null;
}
}
/**
* Frees up the result object
*
* @internal
*
* @return void
*/
public function __destruct()
{
if (!is_resource($this->result) && !is_object($this->result)) {
return;
}
// stdClass results are holders for prepared statements, so we don't
// want to free them since it would break fStatement
if ($this->result instanceof stdClass) {
if ($this->database->getExtension() == 'msyqli') {
$this->result->statement->free_result();
}
unset($this->result);
return;
}
switch ($this->database->getExtension()) {
case 'ibm_db2':
db2_free_result($this->result);
break;
case 'mssql':
mssql_free_result($this->result);
break;
case 'mysql':
mysql_free_result($this->result);
break;
case 'mysqli':
mysqli_free_result($this->result);
break;
case 'oci8':
oci_free_statement($this->result);
break;
case 'odbc':
odbc_free_result($this->result);
break;
case 'pgsql':
pg_free_result($this->result);
break;
case 'sqlite':
unset($this->result);
break;
case 'sqlsrv':
sqlsrv_free_stmt($this->result);
break;
case 'pdo':
$this->result->closeCursor();
break;
}
$this->result = NULL;
}
/**
* Frees up the result object
*
* @internal
*
* @return void
*/
public function __destruct()
{
if (!is_resource($this->result) && !is_object($this->result)) {
return;
}
switch ($this->database->getExtension()) {
case 'mssql':
mssql_free_result($this->result);
break;
case 'mysql':
mysql_free_result($this->result);
break;
case 'mysqli':
mysqli_free_result($this->result);
break;
case 'oci8':
oci_free_statement($this->result);
break;
case 'odbc':
odbc_free_result($this->result);
break;
case 'pgsql':
pg_free_result($this->result);
break;
case 'sqlite':
unset($this->result);
break;
case 'sqlsrv':
sqlsrv_free_stmt($this->result);
break;
case 'pdo':
$this->result->closeCursor();
break;
}
$this->result = NULL;
}
/**
* will free all memory associated with the result identifier result.
*
* @param resource $result query result
*
* @return bool TRUE on success or FALSE on failure.
* @deprecated since version 2.6.0 - alpha 3. Switch to doctrine connector.
*/
public function freeRecordSet($result)
{
$this->deprecated();
return $result->closeCursor();
}
/**
* Free database result
*
* @access public
* @param resource $resource
* @return boolean
*/
function freeResult($resource) {
return $resource->closeCursor();
} // freeResult
