Updating Data (Microsoft Drivers for PHP for SQL Server)


DownloadDownload PHP Driver

The topics in this section address how to update data in a database by examining common use cases.

The steps for using the Microsoft Drivers for PHP for SQL Server to update data in a database can be summarized as follows:

  1. Define a Transact-SQL query that performs an insert, update, or delete operation.

  2. Update parameter values for parameterized queries.

  3. Execute the Transact-SQL queries with the updated parameter values (if applicable). See Comparing Execution Functions for more information about executing a query.

How to: Perform Parameterized QueriesDescribes how to perform parameterized queries.
How to: Send Data as a StreamDescribes how to stream data to the server.
How to: Perform TransactionsDescribes how to use sqlsrv functions to perform transactions.

Example Application (SQLSRV Driver)
Programming Guide for PHP SQL Driver

Community Additions