I have many web applications I've written over the years currently on a Windows 2003 server running IIS6 and PHP4.
Our SQL server is a Microsoft SQL server 2008.
PHP4 came with mssql module, all I had to do back then was uncomment the mssql section of php.ini and it was good to go.
The old server is still up and running and functioning, but I'm trying to set up a new server with PHP5 and move all of the web applications over to it.
I'm a bit confused as to which version of PHP I should install, whether VC6 or VC9, thread safe or non-thread safe and whether I should install it as CGI or Fast-CGI module.
I did eventually get PHP installed. However PHP5 does not come bundled with MS SQL.
After some searching I found a Microsoft SQL driver for PHP. However the syntax is class based, and all of my old code is function based. I was able to get this to work with the database, however there is a LOT of code I would have to change in order to move the applications over.
TLDR:
Is there a way to install PHP5 on IIS with a module that uses the old mssql functions (as opposed to the class based driver issued by Microsoft) to interact with MS SQL Server 2008 so that I can simply copy my applications over instead of having to rewrite all of the code that interacts with the database?
- Wasn't sure if this should go in MS SQL or Installation forums, please move if necessary.