(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 , $sql , array ( & $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:
Please login to continue.