Coming from a SQL Server, and PHP background, I often get asked, does SQL Server work with PHP?
The answer is YES. I have been using SQL Server and PHP together in a high availability load balanced environment with multiple data centers for the last 4 years.
Microsoft offers drivers that plug into PHP to allow the connectivity. You get support for parameterized queries, record sets, and everything that might need to work in this environment.
The first set of PHP / SQL Server drivers that I tried over 4 years ago, was a big buggy, it had some memory leaks, but what we have been using has been completely stable for the last 4 years.
I have only used PHP connecting to SQL Server from a Windows based web server (IIS). I have never tried, and don’t even know if it works on Apache or Linux.
Here is a link to the drivers at Microsoft http://www.microsoft.com/en-us/download/details.aspx?id=20098
-Steve Stedman
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!