Blue Horn New Zealand Web Design & Development (PHP 5, MySQL, Symfony Framework, Apache, Linux)

6Feb/092

How to do SUM with Propel

http://www.digitalbase.eu/blog/simplifying-queries-using-sum-count-etc-in-propel/

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

5Feb/094

How to add a captcha field in Symfony 1.1

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

3Feb/09Off

Smile Care Centre, dentistry with a gentle touch

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

3Feb/09Off

Brevettinews

Brevettinews.it (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

2Feb/090

Multiple Symfony versions in the same environment

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.