PHP 5.4.33 Released

sqlsrv_cancel

(Não há informação de versão disponível, talvez apenas no SVN)

sqlsrv_cancelCancels a statement

Descrição

bool sqlsrv_cancel ( resource $stmt )

Cancels a statement. Any results associated with the statement that have not been consumed are deleted. After sqlsrv_cancel() has been called, the specified statement can be re-executed if it was created with sqlsrv_prepare(). Calling sqlsrv_cancel() is not necessary if all the results associated with the statement have been consumed.

Parâmetros

stmt

The statement resource to be cancelled.

Valor Retornado

Retorna TRUE em caso de sucesso ou FALSE em caso de falha.

Exemplos

Exemplo #1 sqlsrv_cancel() example

<?php
$serverName 
"serverName\sqlexpress";
$connectionInfo = array( "Database"=>"dbName""UID"=>"username""PWD"=>"password");
$conn sqlsrv_connect$serverName$connectionInfo);
if( 
$conn === false ) {
     die( 
print_rsqlsrv_errors(), true));
}

$sql "SELECT Sales FROM Table_1";

$stmt sqlsrv_prepare$conn$sql);

if( 
$stmt === false ) {
     die( 
print_rsqlsrv_errors(), true));
}

if( 
sqlsrv_execute$stmt ) === false) {
     die( 
print_rsqlsrv_errors(), true));
}

$salesTotal 0;
$count 0;

while( (
$row sqlsrv_fetch_array$stmt)) && $salesTotal <=100000)
{
     
$qty $row[0];
     
$price $row[1];
     
$salesTotal += ( $price $qty);
     
$count++;
}

echo 
"$count sales accounted for the first $$salesTotal in revenue.<br />";

// Cancel the pending results. The statement can be reused.
sqlsrv_cancel$stmt);
?>

Notas

The main difference between sqlsrv_cancel() and sqlsrv_free_stmt() is that a statement resource cancelled with sqlsrv_cancel() can be re-executed if it was created with sqlsrv_prepare(). A statement resource cancelled with sqlsrv_free_statement() cannot be re-executed.

Veja Também

add a note add a note

User Contributed Notes

There are no user contributed notes for this page.
To Top