MySQL

Zend Server CE, Free LAMP Stack for Mac/Linux/Windows

I recently installed Zend Server CE on my MacBook Pro to check out the performance of the "partial page" caching Zend offers in their platform.

I was pleasantly surprised how simple it was to get up and running. Zend Platform CE installs its own version of Apache, PHP. If you're installing it on Windows or Mac, it will also install MySQL.

Everything is configured and controlled in your zend path. By default on the Mac it is /usr/local/zend.

Navicat

Navicat is a cross platform (linux/mac/windows) MySQL/PostgreSQL client with a built-in SSH tunnel. This means if you have SSH access, you can use the same 'localhost' credentials as your web app, regardless of what IP you're accessing the site from. http://www.navicat.com/download/download.html

JQuery Sortables with PHP and MySQL

This article will show you how to order a server-side list of fruit from a database using drag and drop behavior and then save them back to the database in order.

I recently worked on a project which required an unordered list to be re-ordered and then saved. I wasn't about to make users enter numbers next to each item so I looked toward JQuery's UI library.

Objective: We will display a list of fruit. The user can then drag the fruit and click a button to save the new order in the database.