PhpRiot
News Archive
PhpRiot Newsletter
Your Email Address:

More information

CodeFury.net: CodeIgniter/PHP + IIS + MySQL + MSSQL: It Works!

Note: This article was originally published at PHPDeveloper on 14 January 2011.
PHPDeveloper

Kenny Katzgrau has a recent post on the Code Fury blog talking about the combination of CodeIgniter, IIS, MySQL and MSSQL and how it all works in his installation (after a few small gotchas).

There are a lot of people out there who call themselves "LAMP" developers - short for Linux, Apache, MySQL, PHP. That's the standard configuration for production PHP applications. Recently, I ended up having to build a CodeIgniter application on Windows, IIS, Mysql+MS-SQL, and PHP. Sound like there are bound to be issues? You bet, and it especially hurts because now I'm a real-live WIMP developer. And what made it even more interesting was that due to constraints, I had to develop the application in Ubuntu and deploy to Windows for production.

He includes the list of the "gotchas" that he came across when doing the installation - six of them:

  • PHP and MSSQL on Ubuntu
  • PHP and MSSQL on Windows
  • mssql vs. sqlsrv
  • File Permissions and Logging
  • No .htaccess Fo' You!
  • 2 Databases, 1 Application