Our server has been hacked. Most of the sites (pretty much all html/php/js files) on this server are victim of some javascript injection. We’re are working to remedy the issue. If you receive any alerts for browser plugins etc DO NOT INSTALL THEM. Over the next few days expect the site to be unavailable.

The Issues has been resolved. The server itself was not affected but a handful of user accounts were leaked via spyware.

Popularity: 1% [?]

Referential Integrity is when the rows from one table are “cross-referenced” and verified with those in another table. This tutorial will walk you through using MySQL to enforce this rule.

Popularity: 2% [?]

Recently, John and I have been doing a lot of database work using MySQL and have had to connect to several large databases and manage them correctly. This can be a daunting task without a tool to easily do so. This is where Heidi SQL comes in. This tutorial will walk you through downloading, installing, and configuring Heidi SQL to use against your MySQL databases.

Popularity: 2% [?]

Sorry for the lack of posts that we have had recently, but John and I have been working on some new projects and are proud to be able to finally release one of the many active projects that we are working on.

Popularity: 2% [?]

This tutorial will show you how to use jQuery to allow as list (UL) to be reordered and will also make an AJAX call to a PHP file that will update the database when an item is dropped. I found this useful for a project I was working on recently. The user wanted to be able to change the order that categories displayed in a report. The items are stored in a database with a field called display_order. When the report is generated we simply order by that field.

Popularity: 8% [?]

As some of you may have noticed the site has been unavailable over the last few days. We are in the process of upgrading to a new server (with 2 quad core Xeon processors and 8gb RAM) and things have not gone as smooth as planned. We will get all the issue straightened out and try to push the new server to it’s limits. If you are wondering why we haven’t posted in the last two month’s we have both been busy with work and side projects. We hope to post some new tutorials soon.

Popularity: 2% [?]

In on of our last tutorials we covered how to verify that a user’s email address is formatted correctly as well as verify that it goes to a valid domain name. That is great, but still not a great way to make sure a user actually owns or uses that e-mail address. This tutorial will walk you through one method of sending the user an e-mail upon signing up that gives them a link to activate their account.

Popularity: 5% [?]

In this tutorial you will learn a simple way to parse CSV files using PHP and output the text of the fields you need. This tutorial is not going to go into what you can do with the data once you get it from the CSV as the possibilities are endless. We will simply show you how to get the data into an array in PHP.

Popularity: unranked [?]

This tutorial will walk you through checking for an e-mail to be valid as the user is filling out the form without having to reload the page.

Popularity: 5% [?]

This tutorial will walk you through disabling the UAC that is enabled on all Windows Vista machines by default.

Popularity: unranked [?]

Introducing WootStat, the premier Woot tracker for Facebook. Mike and myself decided to work with the Facebook API. We ended up created a cool application for tracking items on Woot.com. After checking out the competiton we stack up pretty well. I think we have the most features of any WootTracker on Facebook.

Popularity: unranked [?]

This question has been asked several times lately and I wanted to clear this up. This is a very easy concept once you get it down. In order to display the results from a MySQL query into a table will will store the results in an array and then echo out each row in a while loop.

Popularity: 1% [?]