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?
