You organize your data. Now organize your savings.
Set savings goals, track your progress, and stay on course.
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?
Yes No