Quickly Setup a PHP/MySQL Environment

Posted by Andrew Cetinick on June 30th, 2008

If you want a quick and easy way to setup a PHP/MySQL development environment use XAMPP. XAMPP is a very easy Apache distribution giving you instant support for PHP, Perl and more.

XAMPP even contains an FTP server, phpMyAdmin, and a mail server. There’s no easier and better way to instantly serve your web applications.

You can download the latest version of XAMPP from the ApacheFriends website. XAMPP is reguarly updated for the latest versions of the packages used.

Fill in the blank cells of a Pivot Table

Posted by schone on June 30th, 2008

This is a quick tutorial on how you can populate the blank row area cells which are created by a Pivot Table.

Read the rest of this entry »

Blizzard Announces Diablo III

Posted by Andrew Cetinick on June 30th, 2008

Blizzard has announced the eagerly awaited Diablo III at Blizzard’s Worldwide Invitational. Eight years since Blizzard released Diablo II, dedicated fans have been patient.

Read the rest of this entry »

Installing the uTorrent and WebUI client on Ubuntu Hardy

Posted by schone on June 30th, 2008

Here is a quick guide to setting up the uTorrent and WebUI client on a Ubuntu Hardy box.

Read the rest of this entry »

Export an Access Query or Table to an Oracle database

Posted by schone on June 27th, 2008

Ever wanted to get a query or table which you have in Access exported into a table in an Oracle database? Read on!

Related : Connecting an Excel Pivot Table with an Oracle database

Read the rest of this entry »

Converting Text to a Date in Excel

Posted by schone on June 26th, 2008

Can’t perform any date formatting on a cell because Excel doesn’t recognise its contents as an ‘actual’ date? Using the DATE() formula can help you convert a text field to a date field!

Read the rest of this entry »

Linking an Excel worksheet to a Text file

Posted by schone on June 25th, 2008

Just like Access can create a linked Table to a text file, Excel can do the same using a very quick and simple method.

Read the rest of this entry »

Using an OpenOffice Calc DataPilot with a MySQL database

Posted by schone on June 25th, 2008

I thought I would OpenOffice through another test and see how easy it is to build a DataPilot on a MySQL database.

Related : MySQL ODBC driver Tutorial
Related : Using an OpenOffice Calc DataPilot with a Base Database

Read the rest of this entry »

Creating an Administration Back-end for Rails

Posted by Andrew Cetinick on June 24th, 2008

One of the most important parts of web development is building an administration back-end for your data, a place that is secure from the rest of your application where you can administrate users, topics, categories, or whatever you need for your website. But how do you do it in Ruby on Rails? Where do my controllers go? I will show you a simple way of creating an administration back-end for your Rails application.

Read the rest of this entry »

Ruby on Rails Database Setup Tutorial

Posted by Andrew Cetinick on June 24th, 2008

Ruby on Rails supports many different type of databases. How do you setup Ruby on Rails with your database? Here are some examples to help you out.

Read the rest of this entry »


Copyright © 2008 Jumbabox. All rights reserved.