Developing software in the Real World

SuccesSQL demo online

This post is part of a series about my experiences building a PHP app for Windows Server 2008 and IIS 7 for the European WinPHP Challenge 2009 which is sponsored by iBuildings, Microsoft and Leaseweb. The WinPHP challenge comes to an end around now, so I've put up a demo installation of SuccesSQL (v0.01!) at http://test.successql.org. The test site takes a lot longer to display the first page than version running in my VM and… continue reading.

Metadata from Zend_Db_Table_Abstract

This post is part of a series about my experiences building a PHP app for Windows Server 2008 and IIS 7 for the European WinPHP Challenge 2009 which is sponsored by iBuildings, Microsoft and Leaseweb. I finally found some more time to work on SuccesSQL and can now display table structure information: Zend_Db_Table provides all this information directly which is quite useful, however the intended use-case for Zend_Db_Table is that you extend Zend_Db_Table_Abstract for each… continue reading.

Retrieving a list of databases from SQL Server

This post is part of a series about my experiences building a PHP app for Windows Server 2008 and IIS 7 for the European WinPHP Challenge 2009 which is sponsored by iBuildings, Microsoft and Leaseweb. I need to get a list of databases from SQL Server for the currently logged in user. Initially, I found a built in function sp_databases. This looked promising, until I discovered that it didn't work for my user. I'm pretty… continue reading.

SQL Server troubles

This post is part of a series about my experiences building a PHP app for Windows Server 2008 and IIS 7 for the European WinPHP Challenge 2009 which is sponsored by iBuildings, Microsoft and Leaseweb. I'm now at the stage where I'm writing code and came across an error: Message: 2 [Microsoft][SQL Native Client] Named Pipes Provider: Could not open a connection to SQL Server [2]. That seemed a little odd, so I fired up… continue reading.

Zend Framework URL Rewriting in IIS7

This post is part of a series about my experiences building a PHP app for Windows Server 2008 and IIS 7 for the European WinPHP Challenge 2009 which is sponsored by iBuildings, Microsoft and Leaseweb. To get my Zend Framework Tutorial working with my IIS7 & MS SQL server set up, I needed two things: A Sqlsrv adapter for Zend Framework. A replacement Apache's mod_rewrite module. I've already covered the Sqlsrv adapter, so let's look… continue reading.

Zend Framework connection to SQL Server using SqlSrv

This post is part of a series about my experiences building a PHP app for Windows Server 2008 and IIS 7 for the European WinPHP Challenge 2009 which is sponsored by iBuildings, Microsoft and Leaseweb. I haven't managed to get much time on the challenge this week as I had hoped. Both my sons' birthday parties have taken place along with one son's birthday (the other's is tomorrow). It turns out that fellow challenger Juozas… continue reading.

MSSQL and PHP

This post is part of a series about my experiences building a PHP app for Windows Server 2008 and IIS 7 for the European WinPHP Challenge 2009 which is sponsored by iBuildings, Microsoft and Leaseweb. It's time to connect PHP to MS SQL Server. To make life simple, I decided to take my Zend Framework tutorial and get that going. I created the database and albums table using the SQL Server Management Studio and populated… continue reading.

Viewing PHP errors over the network when using IIS

This post is part of a series about my experiences building a PHP app for Windows Server 2008 and IIS 7 for the European WinPHP Challenge 2009 which is sponsored by iBuildings, Microsoft and Leaseweb. I thought I'd spend a little time sorting out how to connect to MSSQL server using PHP on my Windows 2008 box. I now have my system set up in VMWare Fusion and use SMB to map the wwwroot directory… continue reading.

Women in open source communities

An incident occurred at a Rails conference recently where pictures of scantily clad women were used on slides. The attitude behind the use of the images disturbs me. To be clear, this is not a Rails issue as I aware of a similar issue in the PHP community and it is prevalent in the the entire IT industry. Martin Fowler has summed up pretty much how I feel about it: The nub is that whatever… continue reading.