Blue Horn

How to do SUM with Propel

February 6, 2009 by Sid in Symfony Framework with 2 Comments

$c->addSelectColumn(‘sum(‘.dbTimeBlockPeer::TOTAL.’) as total’);
$rs = dbTimeBlockPeer::doSelectRS($c);
while ($rs->next()) { $total = $rs->getInt(1); }

Read more →

How to add a captcha field in Symfony 1.1

February 5, 2009 by Sid in Symfony Framework with 5 Comments

Step by step on how to add a captcha field to a Symfony 1.1 form.

Read more →

Smile Care Centre, dentistry with a gentle touch

February 3, 2009 by Sid in Portfolios

Smile Care Centre is a website that Nathan has developed recently for a dentist. The website features an online appointment form where Smile Care Centre’s patients can make an appointment anywhere anytime 24/7.

Click for larger image

Click for larger image


February 3, 2009 by Sid in Portfolios (site is now not available) was a website that we have developed sometime ago for an Italian lawyer. We successfully developed the website in PHP, MySQL, and Apache. Brevettinews features news, articles, mailing list, gallery, and etc.

Click for larger image

Multiple Symfony versions in the same environment

February 2, 2009 by Sid in Symfony Framework with 0 Comments

I’ve been using this trick from symfonynerds to run multiple Symfony versions in the same environments. I can now work on projects built on Symfony 1.0, 1.1, and 1.2 simultaneously in the same environment (Ubuntu 8.10).

So now, when I want to create a Symfony 1.0 project, I would just execute “$ symfony10 init-project myproject”. And then in the project I would use “$ ./symfony cc” instead of “$ symfony cc”.

It worths mentioning that I think this trick is good for development environment but “svn:externals” trick or Symfony freeze are better for production/deployment as each project will have their own copy of Symfony Framework.

Game over for Telecom’s

January 17, 2009 by Sid in News with 0 Comments

It has been predicted since the beginning, and lo and behold, it became a reality!, an online shopping website started and owned by Telecom was closed at 5pm, 14 January 2009 after around three years of business. NZ Herald post featured 11 pages of users comments about the closing of Ferrit.

So what’s wrong with Ferrit?

  • Lack (if any) of word of mouth referrals. Most if not all web 2.0 success relied on this factor rather than bombardments of TV ads.
  • Annoying TV ads
  • Poor choice of name. People do not associate it with online shopping
  • Telecom’s bad public image
  • It was seen as a response to Trademe which was at the height of its success
  • Bad website interface and design
  • Seen as just providing links to retailers websites
  • Telecom was trying to run a business outside their expertise

A blogger commented that although it is not a successful business, Ferrit should not close down. I agree to some degree, it costed Telecom NZD $30m to setup, and it’s only been three years!

The closing of Ferrit saw Telecom’s shares went up in value, but only to drop again the next day on announcement of “Commerce Commission commences review of backhaul”.

Compare directories / folders using xxdiff

January 9, 2009 by Sid in Linux, Tools with 0 Comments

I just found this wonderful tool called xxdiff which is a command line but graphical tool, it didn’t make sense at first, but it is actually a tool that you start from command line but then gives you a graphical UI (a pretty simple but effective UI, in my opinion).

After installing xxdiff, just type a command line like this one to compare two directories recursively:

xxdiff -r /dir1 /dir2

and a GUI window should show up, something like:

One of the wonderful things about the GUI is that you can copy files from one directory to another. And you can also double click on each file to see the differences in the files contents.

I have not explored all the features and capabilities of xxdiff but it seems like a very handy tool to keep around. Very useful for manually synchronizing directories / folders.

What did our clients say about us?

December 7, 2008 by Sid in Clients

Here’s what they said about us.

“I have now had Sid work with me on a number of development projects and I would highly recommend him. Sid delivers on time and on budget and is always quick to reply an easy to work with.” – Craig Cochrane of Web Tonic

Read more →

Popular websites built using Symfony Framework

December 6, 2008 by Sid in Websites using Symfony

Symfony website has a long list of websites built using Symfony Framework, but this is my own list of favorites/highlights. So here we go:

  • Yahoo! Bookmarks, what more to say, it’s that giant company.
  •, the popular web 2.0 social bookmarking website.
  •, one of Trademe‘s websites.
  •, providing detailed web stats to nearly 5,000 websites. That’s over 300 database queries per second, over a billion page views being analyzed, over 28 real-time reports for each site, AJAX, RSS feeds, and lots more running on this framework. All on a single server.

To be continued … I’ll keep adding to this list of websites built using Symfony Framework

How to handle dot in Symfony URL

December 4, 2008 by Sid in Symfony Framework with 2 Comments

This problem with dot in Symfony URL is a common issue faced by developers. I’ve seen people asking about it few times in the symfony-users mailing list, and in fact I have asked about it once. Here’s one recent thread about it in the mailing list. Read more →

My Projects
Restaurant Websites