While this is nothing new or big news Microsoft has managed to release PHP 5 drivers for its SQL Server platforms. We have not ran PHP on a Windows server in a very long time and so we decided to give it a shot and honestly it was a total pain in the ass but only because we are not use to the IIS 7 web server. Honestly we like IIS 6 better less complicated and more to the point. Sure IIS 7 is great for those .NET applications but not everything else. For instance we tried to install and run Coldfusion 8 on IIS 7 and again a total pain in the ass while on IIS 6 it installed like a dream.
Back to the main point, PHP runs fairly well on IIS 7 but if you don’t know your way around IIS 7 then you might have some issues with it. The simple PHP scripts we tried worked perfectly well but they were not as efficient as PHP and MySQL 5. In all honesty if your going to use PHP with a database I would stick to the LAMP stack (Linux, Apache, MySQL and PHP) it just works better and a ton faster.
But if your a Small Business Server user and want to go the PHP route instead of .NET or ASPX then sure PHP will get the job done on IIS/Windows Server. The best part about it is that the driver is
released under the Apache license.
Straight from their site:
“The Microsoft Drivers for PHP for SQL Server are PHP 5 extensions that allows for the reading and writing of SQL Server data from within PHP scripts. The release contains two drivers, the SQLSRV driver and the PDO_SQLSRV driver. The SQLSRV extension provides a procedural interface while the PDO_SQLSRV extension implements PDO for accessing data in all editions of SQL Server 2005 and later (including SQL Azure). These drivers rely on the Microsoft SQL Server 2008 R2 Native Client’s ODBC driver to handle the low-level communication with SQL Server.”
Here is some more information on the driver if you guys are interested in it.