Using SQL Server with PHP 5.5

PHP is adopted worldwide and Microsoft has been providing hooks in the past  so that PHP applications can access SQL Server data. Extending connectivity to SQL Database on Microsoft Azure need no explanation.

SQL Server driver (SQLServer31.exe, 499KB, version 3.1.CTP) for PHP is now available as a CTP. Now PHP scripts can access Microsoft SQL Server and Microsoft Azure SQL Database.

You can download the CTP here:
http://www.microsoft.com/en-us/download/details.aspx?id=20098&WT.mc_id=Blog_SQL_Announce_DI

Details of this version:

This version

• Supports PHP Version 5.5 and requires Microsoft ODBC driver 11 (or higher)
• It supports SQL Server 2012; LocalDB and AlwaysOn features
• Buffered Queries are included

All SQL Server user can get it at no extra cost.

This widens the interoperability range.

The soon to be released JDBC driver compatible with JDK7 for SQL Server will enable applications to connect to SQL Server widening connectivity with Java Platform.

I have covered in detail how to use PHP applications (PHP versions 5.2.4 or later) to access data on Microsoft Azure SQL Databases (formerly called  Microsoft SQL Azure) using PHP Data Objects. Details are on pages 369-373, Chapter 10 in my 2010 book here:

 

You can buy or join the library here:

https://www.packtpub.com/application-development/microsoft-sql-azure-enterprise-application-development