Pragmatism in the real world

WinPHP wrap-up thoughts

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 come come to an end and I'm fairly happy with how SuccesSQL has come. I wish I had realised exactly how little time I had in May though. Somehow I managed to forget that we had three… continue reading.

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.

The EuroWinPHP application

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. So.. I've decided on a name: SuccesSQL! I can almost hear the groan from here… What can I say? The name appealed to me :) The plan is to write a web based management interface for MS SQL Server databases… continue reading.