sqlsrv_execute

(No version information available, might only be in Git)
Executes a statement prepared with sqlsrv_prepare()
bool sqlsrv_execute ( resource $stmt )

Executes a statement prepared with sqlsrv_prepare(). This function is ideal for executing a prepared statement multiple times with different parameter values.

Parameters:
stmt

A statement resource returned by sqlsrv_prepare().

Returns:

Returns TRUE on success or FALSE on failure.

Examples:
sqlsrv_execute() example

This example demonstrates how to prepare a statement with sqlsrv_prepare() and re-execute it multiple times (with different parameter values) using sqlsrv_execute().

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<?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 = "UPDATE Table_1
        SET OrderQty = ?
        WHERE SalesOrderID = ?";
 
// Initialize parameters and prepare the statement. 
// Variables $qty and $id are bound to the statement, $stmt.
$qty = 0; $id = 0;
$stmt = sqlsrv_prepare( $conn$sqlarray( &$qty, &$id));
if( !$stmt ) {
    die( print_r( sqlsrv_errors(), true));
}
 
// Set up the SalesOrderDetailID and OrderQty information. 
// This array maps the order ID to order quantity in key=>value pairs.
$orders array( 1=>10, 2=>20, 3=>30);
 
// Execute the statement for each order.
foreach$orders as $id => $qty) {
    // Because $id and $qty are bound to $stmt1, their updated
    // values are used with each execution of the statement. 
    if( sqlsrv_execute( $stmt ) === false ) {
          die( print_r( sqlsrv_errors(), true));
    }
}
?>
See also:

sqlsrv_prepare() -

sqlsrv_query() -

doc_php
2025-01-10 15:47:30
Comments
Leave a Comment

Please login to continue.