Useful PHP and MySQL articles to improve your development skills!

CakePHP Authsome
Authentication for people who hate the AuthComponent.

Triggering Cascading Updates and Deletions with Foreign Key Constraints
Cool article how to create cascading updates and deletions on your MySQL database using key constraints.

Create Pivot Tables in PHP
Tutorial on how you can use PHP to create Pivot Tables.

Working in the Method Scope with Static Variables in PHP 5 Classes
Despite their name, static properties can help in a wide variety of situations. If you’re not using them currently, and you regularly implement design patterns in your code, after reading this series you’ll wonder how you ever did without them.

PHP mistakes, misconceptions, bad practices and blatant no nos.
Go to any PHP help forum and you’ll be sure to see many bad practises, innocent misconceptions and blatant no nos. None of us are perfect and none of us started off writing great code. We have all had that moment where we looked back on a script that we wrote years ago and thought “what the hell was I thinking?”. But it is a process. You make mistakes, you learn from those mistakes and then you move on.

Practical Php Patterns: Composite
One of the most important structural patterns is the Composite one: its goal is managing a hierarchy of objects where both leaf objects and composition of other objects conform to a common interface. This hierarchy is usually constituted by part-whole relationships (often composition in the strict sense or aggregation), and it can be viewed as a tree.

Relationships between objects
Clear article where relationships between objects are explained.

Implementing Factory Methods in PHP 5
If you’ve ever developed desktop applications using mature object-oriented languages like C++ and Java, then it’s possible that you’ve found yourself saying a few funny phrases such as “I need to implement a factory method within this class,” or in the worst case: “this class needs to implement a factory method, but I don’t have a single clue about how to do that.” Surprisingly, you can implement these factory methods pretty quickly and easily in PHP 5.

Related posts:

1. 5 articles to improve your jQuery skills! jQuery 1.4 API Cheat Sheet Complete cheat sgeet of the...
2. MySQL Caching Techniques Recently Jay Pipes published great article about lazy connecting and...
3. 23 articles and resources to improve your WordPress life! I’ve collected some cool articles which will give you tips...
4. Great tips to improve your MySQL performance Some great articles on how to improve the performance of...
5. 15 essential PHP and MySQL tutorials! Showing Google Maps with many markers in PHP Sometimes you...

Related posts brought to you by Yet Another Related Posts Plugin.