phpMyBackup Pro is an easy to use, free, web-based MySQL backup application. It can backup one or several databases, using compression like gzip, zip (or no compression) and can schedule backups. It can also backup directly to an FTP server or send the backups via email.

All of these features are presented in a management interface. A shell mode is also available for manual use or by cron script.

There are several language packages already available.

For more information: phpMyBackup Pro

For those of you, like me, who use PHP and Javascript regularly, PHP.JS is a great enhancement. PHP.JS is an open source project where PHP functions are ported to Javascript. This means that the PHP functionality is executed client-side which reduces the load on the server.

Some of the functions that have already been ported are:

• md5()
• date()
• base64_decode()

As the library has become too big to include at once, and having users copy-paste functions to their projects can end up causing maintenance hell, the developers have created a compiler tool that allows programmers to select ONLY the functions they need, and wrap them up in a single php.js file.

Another benefit from this library is that it enhances the functionality of Javascript by adding functions that don’t exist natively in Javascript.

Definitely a great tool for developers.

For more information: PHP.JS

Having used osCommerce for several ecommerce online shops over the last few years, I had been waiting for the latest update since March 2007. A little over a month ago, that wait ended with the release of osCommerce Alpha 5. The update came with very little warning and even less fanfare. Regardless, I excitedly downloaded the latest version and installed it. Once it was installed, I took a look at the front end and found there was not much change other than it using CSS layouts. I didn’t think this was that much of a big deal as most online shops end up being completely redesigned.

I then took a look at the Administration system and was completely underwhelmed. There were hardly any new features. I found this strange, especially after two years between updates. The developer has stated that he has put alot of effort into making this flexible platform so that others can add functionality through contributions (or plugins). Bitterly disappointed, and not wanting to wait for the functionality to be created by others six months down the track, I decided to look at other alternatives.

I had read about Magento as it was mentioned several times on the osCommerce forums as a competitor. After looking at the Magento demo administration and front end, I’d thought I would give it a try. Now to be fair to osCommerce, I found Magento to be alot harder to install. I downloaded Magento v1.3. The first attempt at installing wouldn’t get passed the database creation step. It kept giving me an error. I checked all my database settings but couldn’t find anything wrong with them.  I did a search through the Magento forums and found other people were having the same problem. One suggestion was to just create a new database and user and use those during installation. Sure enough it worked. Strange thing was that I had created a new database and user just for Magento before my first install. Weird!

After the installation was done, I clicked on the link that takes you to the front end home page. Everything seemed to be working fine. I then logged into the Admin and started adding Categories and Products to see how it all works. This part of Magento is quite detailed. It combines the Product detail and SEO elements right from the start. I added my first product, saved it and then created a Category and added the Product to it. So far so good. Next step was to test out the front end with the newly added Category and Product. I typed in the URL for the front end. Up came the Home Page but no Category or Product. I went back into the Admin and checked what I had done but everything seemed to be in order. Tried the Home page again and still no Category menu or Product.

Magento Store Edit

I thought it might be the Default theme so I downloaded and installed the Modern theme (more on installing Extensions later in this article). Still no success. So like all good developers do, I hit the forums. Sure enough, I found what I was doing wrong. In the System->Manage Stores->Edit Store section I hadn’t set the root category for the store. Once I did this, Categories and Products were displayed on the Home Page.

Downloading extensions is pretty straight forward. You search through the Magento Extensions list and grab the extension key from the one you want. You then go into the Magento Connect Manager, enter the Extension Key and click on Install. The Extension is then downloaded and automatically installed.

You can filter the Extensions by choosing to see Core, Community or Commercial extensions. There are a plethora of Extensions already created. Extensions range from Payment Gateways to Administration Enhancements to Themes.

Another thing I like about the Administration System is it’s full of options that osCommerce doesn’t have. For example, you can set Roles for Users who log into the Administration System. You can set the Role to only access certain areas of the Administration System. This means that the Developer setting up the site can give access to the client but limit the areas they can access to avoid any accidental setup changes from being made. Magento also has in-built Google Sitemap creation, CMS management, URL rewrite management, Customer groups, report generation … the list goes on.

I’m still in the process of transferring an old osCommerce online shop across to Magento. However, from what I’ve seen so far, it outstrips osCommerce in terms of functionality and features that come standard. I would recommend Magento to any developer out there needing an Open Source ecommerce solution that provides them with the functionality and features they need right out of the box.

For more information: www.magentocommerce.com

Anyone who manages their own website knows how important it is to track the traffic coming to their site. There are several solutions out there, Google Analytics being the most well known. I wanted to see what other alternatives were out there.

After a bit of searching, I came across Piwik, an Open Source alternative to Google Analytics. After reading through the Piwik website, I thought I would give it a try.

Installation is very simple. Just upload the files to your webspace, and then access the installation URL. The Piwik installation will firstly perform a system check to make sure your system meets the minimum requirements. Next comes the Database access details. Once the Database is setup, your are then asked to enter the Super User details. Finally you are required to add a website URL to track.

For the tracking to work, you need to add Javascript to each page you want tracked. Tracking covers the standard things like vistors, unique visits, Bounce Rate, Browsers, location and so on. The one feature I really like is that all sections of Piwik are actually plugins. You can easily customise the information you see in Piwik by enabling/disabling the plugins. Expanded functionality in the future will be added via new plugins.

Piwik Dashboard

As this project is Open Source, it’s open to anyone who wishes to contribute. There are already several translations of the project. As Piwik is still in beta (currently at v0.2.33 as of writing this article), there is still a few months of development before v1.0 is reached. However, even at this early stage, I’m finding Piwik to be feature rich and quite stable. Some of the features the developers have planned to implement are:

• multi sites dashboard
• new modular Javascript API
• PDF reports

Piwik looks to be a promising alternative to Google Analytics. The developers have delivered a robust platform that will allow Piwik to grow with user contributions over coming months. Definitely worth taking a look at.

For more information: piwik.org

As a Freelance Developer, I’m always searching for new things to use in the next job. Often it’s little things that save time, or that implement a cool feature into the design of a site. Sometimes I stumble across things that I can’t believe I didn’t know about before. These are the things I would like to share with you.

With this site, I hope to cover things such as Social Networking (Twitter, Facebook etc), Open Source Applications, Flash (AS3/4), PHP, mySQL, Javascript APIs and some entertaining links along the way.

I welcome any discussion on the subjects I write about, and hope I can help some of you reach solutions without spending hours “Googling” for the answer.