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.

Posted on 28 May 2009 in WinPHP Challenge, Zend Framework 1

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.

Posted on 19 May 2009 in WinPHP Challenge

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.

Posted on 16 May 2009 in WinPHP Challenge

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.

Posted on 11 May 2009 in WinPHP Challenge

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.

Posted on 10 May 2009 in WinPHP Challenge

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.

Posted on 4 May 2009 in WinPHP Challenge

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.

Posted on 3 May 2009 in WinPHP Challenge

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.

Posted on 1 May 2009 in Around the web, Me

Zend Framework Tutorial for ZF 1.8

Zend Framework 1.8, has been released! To celebrate, I have completely revised and updated my Zend Framework tutorial to support the new Zend_Tool command line tool and Zend_Application for bootstrapping. Let me know what you think :)

Posted on in Zend Framework 1

Zend_Loader's autoloader deprecated in Zend Framework 1.8

Zend_Loader's autoloader has been deprecated in the upcoming Zend Framework version 1.8 and so you now get a notice if you use it: Notice: Zend_Loader::Zend_Loader::registerAutoload is deprecated as of 1.8.0 and will be removed with 2.0.0; use Zend_Loader_Autoloader instead in /www/zf-tutorial/library/Zend/Loader.php on line 207 Notice: Zend_Loader::Zend_Loader::autoload is deprecated as of 1.8.0 and will be removed with 2.0.0; use Zend_Loader_Autoloader instead in /www/zf-tutorial/library/Zend/Loader.php on line 186 Notice: Zend_Loader::Zend_Loader::autoload is deprecated as of 1.8.0 and will be… continue reading.

Posted on 30 April 2009 in Zend Framework 1

Archives