PHP and SQL Server Programming By Example

This book provides alternative approach to build PHP application with Windows platform and database SQL Server. It describes how to work with PHP and SQL Server and illustrates their use with code examples. The last chapter author explains how PHP to access Windows Azure SQL Database.

*Short TOC*

1. Setup Development Environment

2. Hello World - PHP and SQL Server

3. CRUD Operations

3.1 CRUD Operations

3.2 Creating Data

3.3 Reading Data

3.4 Update Data

3.5 Deleting Data

4. Working with Image and Blob Data

4.1 Image and Blob Data

4.2 Uploading Image

4.3 Listing Image Data

5. Transaction

6. Stored Procedures

6.1 Stored Procedures

6.2 Calling Stored Procedure

6.3 Calling Stored Procedure with Parameter

6.4 Calling Stored Procedure with Input and Output Parameters

7. Windows Azure SQL Database

7.1 Windows Azure SQL Database

7.2 Creating Windows Azure SQL Database

7.3 Connecting to Windows Azure SQL Database

7.4 Inserting Data

7.5 Retrieving Data