PHP and mssql

[eluser]edhrx[/eluser]
I have been commissoned to write a web app for a health service organisation here in the UK. Here's the rub. They won't go near anything that dos'nt have mssql or oracle as the back end. I try to 'sell' the mysql route etc but it's just a non starter.

The problem I'm finding with CodeIgniter ( and judging from the forums on the Zend Framework) that using any of libraries for connecting to mssql needs a lot of fiddling about with lots of dependencies depending on your environment. I hate to say it but I'm driven to Visual Studio for this project simply because there are consistent set of tools available for using php / mssql

I'm just looking for opinions in relation to this topic


happy holidays Ed.

[eluser]Matthew Lanham[/eluser]
Hi There,

I wrote a whole Extranet in PHP / MSSQL last year (not on codeigniter)....

I didn't find issues with connecting and using mssql only installing php on IIS....Codeigniter has support for mssql (i think) as does php, and it works in the same way as mysql i.e. mssql_connect, mssql_query, mssql_fetch_array

There were only a couple of things i found, when you have a database lets say for an email address, and you set it to a varchar of 200, in mysql if the email was 50, it would only return 50 characters to you, however in mssql it would return the whole 200.

Apart from these minor issues, there was really no other difference in the general working...