The previous article gave you an overview of the phpMyAdmin interface and functionality. It's now time to dive in further and learn how to construct and execute queries.

They show (complete with screenshots) how to use the GUI to build the different parts of your query - a simple SELECT statement with a join pulling together the customer information and their addresses.

phpMyAdmin is a HTML interface developed in PHP, for creating and managing MySQL databases. Before you download and install the latest version, have a look at the requirements section on the phpMyAdmin Wiki.

They look at the overall interface, how to set up users, making a new database, creating a table inside of it, pushing data into the table and the various options that the tool has to help you manage your database(s) - all with nice big screenshots to show you where it all is.

Installation of PHP-GTK 2 on MacOS X 10.4 and 10.5 is actually pretty simple, as it can use the latest PHP-GTK installer, which works just like any other Mac installer.

They include screenshots as a guide to the step-by-step (extremely simple) process of getting the software installed.

For those interested in technical details, a complete list of the prerequisites is given at step 2 of the installation. Download the installer at http://www.kix.in/php-gtk2/PHP-GTK-2.0.0.dmg

In this tutorial, we will get an introduction to CubeCart, created and distributed by Devellion Limited. Their flagship product is one of the easiest low-cost e-commerce solutions available, and is growing in popularity. Note that CubeCart is not technically open source, since the code cannot be freely redistributed. On the other hand, most of the code is not protected using encoding, and can thus be read and understood.

They go through the selection process - picking which version of their software is right for you - and the installation, configuration and how to verify that everything's up and running smoothly. Screenshots are included to help along the way.

One of the most popular CMSs is Drupal, partly because it offers all of the aforesaid features, and partly because developers familiar with PHP (the language used by Drupal) can modify the functioning and appearance of almost every aspect of Drupal.

In this tutorial, we will discuss how to install and configure a brand-new Drupal Web site from scratch. We will also touch upon the basics of adding content to a Drupal installation.

They include useful screenshots along the way as well, helping to guide you through the process a bit better than with just words. There's tons of configuration options that you could mess with in a Drupal installation, but they do well to give you the essential ones that you'll need to get it up and running smoothly.

Following on from the Simple Zend_Layout Example, Zend_Form is now in the trunk, so here's a super simple, complete example that shows it in action.

He includes screenshots of the different steps along the way - the form that will be generated, the structure of the directories and, of course, the contents of the PHP files to make things happen. He also mentions the use of Decorators (the design pattern) to assign the various attributes of the form element object.

I've put up the latest installment in my "Grails for PHP developers". Rather than delve too much more in to Grails head on, I'm taking this installment (and at least the next one) to delve more in to the Groovy language itself. Groovy offers similarities to PHP, but also many differences which can trip you up if you're not careful. I'll try to lay those out as best I can in the next couple of installments.

This new part of the series goes back and puts the spotlight on GRoovy, the base of the Groovy/Grails combo. He talks about working with variables and arrays as containers for multiple pieces of data and some possible gotchas that could come up along the way.

php-desktop emulates a desktop using KDE programs/icons

php-desktop is tested with KDE. It also uses KDE programs (for example kde-open) and KDE icons. php-desktop gets the icon by the mimetype of a file. If the file is a desktop-file php-desktop gets the icon from there.

You can check out a screenshot of the project for a preview of what it's like or just download the archive and try it out for yourself.