// 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)); }}?>

Notes

When you prepare a statement that uses variables as parameters, the variables
are bound to the statement. This means that if you update the values of the
variables, the next time you execute the statement it will run with updated
parameter values. For statements that you plan to execute only once, use
sqlsrv_query().