This tutorial series shows you how to use PHP to interact with the SQL Server using PHP Data Objects (PDO) API.
Section 1. Getting Started #
- Connecting to the SQL Server from PHP – show you how to install the necessary tools and libraries and perform configuration to connect PHP to the SQL Server.
Section 2. Inserting Data #
- Insert data into a table – show you how to insert a new row into a table in SQL Server from PHP.
- Insert multiple rows into a table – discover how to perform a multi-insert statement to insert multiple rows into a table.
Section 3. Querying Data #
- Select data from a table – Show you how to select data from a table.
- Pagination – Learn how to perform pagination by breaking up a large result set into smaller ones.
Section 4. Updating Data #
- Update data from a table – Guide you on how to update data in a table.
Section 5. Deleting Data #
- Delete data from a table – Show you how to delete data from a table in SQL Server from PHP.
Section 6. Performing Transactions #
- Perform a transaction – Learn how to perform an SQL Server transaction from PHP.
Section 7. Calling Stored Procedures #
- Call a stored procedure – Show you how to call a stored procedure in SQL Server.
- Call a stored procedure with OUTPUT parameters – Learn how to call a stored procedure with OUTPUT parameters.
Was this tutorial helpful?
