How easy is it to use PHP on an MS Server with MS SQL?

Question

I generally use linux servers and program in PHP (plus other associated technologies) with mysql databases. A client has existing ASP sites using MSSQL databases on a Windows server and wants some new sites created on their server using their MSSQL database as the main data source. I have used ASP in the past but much prefer PHP so would rather use this.

I just wanted to confirm that i'm right in saying as long as the server has PHP installed (which it does) then there's no reason I can't create a PHP site on the Windows server and just use different connectors to connect to the MSSQL db (rather than what i would usually use for connecting to a MYSQL db). Presumably (other than the different connect/query code) this would work in pretty much the same way as with a linux setup with mysql and i could then code the site in PHP but use their existing datasource?

I would be extremely grateful if anyone could confirm i'm right in saying this and if there's any other issues that might cause any problems?

Thanks so much for your help as ever,

Dave

AndrewR · Accepted Answer · 2011-09-07 10:21:20Z

2

You can enable MSSQL support in PHP on Windows. The default Windows PHP install has the php_mssql.dll extension commented out in the php.ini file. Uncomment that line, restart Apache, and it should work.

There is a supporting DLL called ntwdblib.dll that you may need to find a replacement for, as the version included with PHP may be outdated and won't work with newer versions of SQL Server. (I had this problem when setting it up.)

answered Sep 7, 2011 at 10:21

AndrewR

6,7681 gold badge26 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Álvaro González · Accepted Answer · 2011-09-07 10:32:10Z

1

There are two different libraries to connect to SQL Server from PHP:

The legacy mssql extension, which has been discontinued on Windows
Microsoft's sqlsrv extension, which only works on Windows

I've basically worked with the second one and I can say it's a very interesting product. It's robust, it has a very nice interface and it's totally up-to-date. But what I like most is that it has very nice features. E.g.:

It can return dates as PHP DateTime objects
It provides a PDO driver

The only drawback of using SQL Server is that there isn't an easy way to write a cross-platform app but I understand it isn't problem in your case.

answered Sep 7, 2011 at 10:32

Álvaro González

147k45 gold badges282 silver badges378 bronze badges

Comments

Eskil Mjelva Saatvedt · Accepted Answer · 2011-09-07 10:18:33Z

1

Yes, it is rather straight forweard.

You need to have the mssql library activated in php.ini. Which can be troublesom.

MSSSQL docmentation

answered Sep 7, 2011 at 10:18

Eskil Mjelva Saatvedt

5477 silver badges20 bronze badges

Collectives™ on Stack Overflow

How easy is it to use PHP on an MS Server with MS SQL?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related