sqlsrv_cancel

(No version information available, might only be in Git)

sqlsrv_cancel — Cancels a statement

说明

sqlsrv_cancel ( resource $stmt ) : bool

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.

参数

stmt

The statement resource to be cancelled.

返回值

成功时返回 TRUE， 或者在失败时返回 FALSE。

范例

Example #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_r( sqlsrv_errors(), true));
}

$sql = "SELECT Sales FROM Table_1";

$stmt = sqlsrv_prepare( $conn, $sql);

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

if( sqlsrv_execute( $stmt ) === false) {
     die( print_r( sqlsrv_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);
?>

注释

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.

参见

相关文章
php ibm db2 函数 prepares an sql statement to be executedphp firebird/interbase 函数 cancels a registered event handlerphp maxdb 函数 prepare an sql statement for executionphp maxdb 函数 frees stored result memory for the given statement handlephp maxdb 函数 initializes a statement and returns an resource for use with maxdb stmt preparephp maxdb 函数 returns the number of parameter for the given statementphp mssql 函数 free statement memoryphp mysql xdevapi 函数 bind prepared statement variables as parametersphp mysqlnd qc 函数 installs a callback which decides whether a statement is cachedphp oci8 函数 returns the next child statement resource from a parent statement resource that has oracle database 12c implicit result setsphp postgresql 函数 submits a request to create a prepared statement with the given parameters and waits for completionphp sqlsrv 函数 cancels a statementphp sqlsrv 函数 executes a statement prepared with sqlsrv preparephp sqlsrv 函数 retrieves metadata for the fields of a statement prepared by sqlsrv prepare or sqlsrv queryphp sqlsrv 函数 frees all resources for the specified statementphp sqlsrv 函数 returns the value of the specified configuration settingphp sqlsrv 函数 gets field data from the currently selected rowphp sqlsrv 函数 indicates whether the specified statement has rowsphp sqlsrv 函数 makes the next result of the specified statement activephp sqlsrv 函数 retrieves the number of fields columns on a statement
关注编程学问公众号