PHP Resources and articles

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. From my experiences of modifying other people’s code, helping people on PHP help forums and making my own (many) mistakes, I hereby present this list:

Pivot tables in PHP

In my work as developer I normally need to transform data from one format to another. Typically our data input are a database and we need to show database data into a report, datagrid or something similar. It’s very typical to use pivot tables. It’s not very dificult to handle pivot tables by hand but the work is always the same: groups by, totals, subtotals, totals per row …. Now I want to write a class to pivot tables in PHP with the most common requirements (at least for me). I know we can create pivot tables with SQL. Group by and some other database specific commands like oracle’s GROUP BY ROLLUP/CUBE can do the work, but I like clean SQL querys. The business logic must be in PHP and SQL must be as clean as we can.

Common PHP Based Interface For Cloud Services

The Simple Cloud API is an open source project providing common PHP interfaces for File Storage, Document Storage, and Simple Queue cloud services. It will enable you to easily connect your application with a new service without having to learn their specific API. Primarily developed as a new Zend Framework component called ‘Zend_Cloud’, you can use it independently of Zend Framework.

Practical Php Pattern series

End of Year Link Compilation

This will end my Year with the links for the day or Week. I will start the new year with a completely new format for these type of links. I would appreciate any critique or comments on how you would like to have these links formatted for your convenience.

CSS

Start a web application from scratch

Worpress

Php

User Experience/User Interface

Web Design and development

Tutorials/Tips/Opinions

Tools

Wireframing/ Prototyping

Flash

Javascript

Productivity

Iphone

Links for the day

Web Application Interface Design Guide

Why Flash Might Not Be Good For Your Website

Factors That Affect Usability

Client-Side File Generator with Javascript & Flash 10+

From http://css-tricks.com Creating a webapp from scratch series
Part 1 – Planning the App: Basic Idea and Design
Part 2 – Planning the App: Database Architecture and Development Approach
Part 3 – Designing the App: Workflow Map and Photoshop Design
Part 4 – Designing the App: HTML and CSS
Part 5 – Developing the App: User Interaction
Part 6 – Developing the App: Adding AJAX Interactivity
Part 7 – Developing the App: List Interaction
Part 8 – Security & The Future
Part 9 – Bugs, Security, and Other Tweaks
And finally…. the application! Colored Lists

Eight Robust Tools To Simplify Developer’s Worklife

35 CSS-based Layouts that Look Awesome

The Benefits of Experimentation

Solutions to 5 Common Ajax Problems

Produce Interactive Charts of Time Series with dygraphs

Flot Pure Javascript Plotting Library for jQuery

10 jQuery snippets for efficient developers

Stupid jQuery Tricks

A Beautiful Apple-style Slideshow Gallery With CSS & jQuery

Making A Cool Login System With PHP, MySQL & jQuery

Links for the day

Web Design is Dead! Introducing a much improved web design process.

Minimalist Web Design: When Less is More

What makes a website successful? It might not be what you expect!

The Unusable and Superficial World of Beer and Alcohol Websites

If Content is Really King, Then What is Design?

5 Articles To Understanding Your Websites Bounce Rate

10 Signs of a User-Focused Design

The Best jQuery Plugins of 2009

Use Sprites to Create an Awesomeness-Filled Navigation Menu

50 Helpful iPhone Apps for Web Designers and Developers

5 Advanced CSS Techniques To Increase Your Skill Set

Everything You Ever Want to Know About Creating Seamless Patterns in Illustrator

phpanywhere.net

Stupid WordPress Tricks

15 Helpful Blogs No Freelancer Should Forget

Links for the day

General:

Creating a Usable Contact Form

10 Amazing Tools for Sharing Visual Inspiration through Screenshots

The Evolution of a Website Design

35 Excellent Wireframing Resources

Search Engine Optimization 101

GeneralRelativity Flash Animation Library

Inline Validation in Web Forms

Here's an nteresting drawing application called LiveBrush (free download):

22 Awesome Adobe AIR Applications for Designers

Pagination is dead

Wireframing:

Create and collaborate interactive UI mockups for your software and websites.

20 Steps to Better Wireframing

A Hole in the Workflow: Prototyping and the Handoff from Designer to Developer

35 Excellent Wireframing Resources

CODING:

Getting Clean With PHP

Quick reference search in HTML, CSS, JS, Ajax and other developer documentation

20 Fresh jQuery Plugins to Enhance your User Interface