As most of you have probably noticed we have made some major changes to team tutorials. I created a new layout with the intention of making the site much easier to read. We added a preview image for each post that will be updated on all new posts. There is also a description box on … Read more
We have been working on a new look and feel for the site. The new layout should be a little more clean than the old one. We tried to keep it simple and improve the readability. We will be upgrading over the next few days and will update with more details.
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.
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.
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.
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.
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 … Read more
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.
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.
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.
This tutorial will walk you through disabling the UAC that is enabled on all Windows Vista machines by default.
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.