Archive | MySQL RSS feed for this section

The longer Lithium Blog tutorial using MySQL – Part 1

TweetLithium is a lightweight, fast, flexible framework for PHP 5.3+. It is still in dev release state but is under active development. This post, as the title suggests, is to introduce you to this new framework using the typical blog tutorial. Getting started The first thing is to get the Lithium source code. You can [...]

Read full story · Comments { 15 }

Related tags, search by tags in Cheesecake-Photoblog

TweetAn often repeated question on the CakePHP Group relates to filtering hasAndBelongsToMany associations or finding related hasAndBelongsToMany associations. To give a real life example and make it more clear - In Cheesecake-Photoblog a photo has and belongs to many tags. Simple tasks like finding all tags that belong to a photo or all photos that [...]

Read full story · Comments { 0 }

CakePHP Model’s created / modified gotcha!

TweetOK! this post should more appropriately be named "Disparate behavior of DATETIME field between MySql versions" and is none of CakePHP's fault in fact no one is to blame other than perhaps MySQL and myself but such things happen to almost everyone once in a while. CakePHP does a lot of things 'automagically' - one [...]

Read full story · Comments { 7 }