Splitting a String on a Character There are a lot of functions out there that are very simple and easy to understand but are absolutely necessary to make fully functional applications. This week, we are going to begin with a simple string function: split. The split function (explode in PHP) allow the programmer to take … Continue reading Function – Splitting a string
There have been a lot of changes going on recently and the site has been getting pushed to the side. We are going to start trying to get some new content posted regularly again. The forums that we added back a while ago are now functional again (never noticed they weren’t working). Feel free to … Continue reading Forums and Posts
In this tutorial we are going to use XSLT to transform a simple XML document into an XHTML web page. XSLT stands for eXtensible Style Sheet Transformations. With our XSL document we will pretty much grab the values we need from the source XML and display them nicely in XHTML.
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 … Continue reading New Features
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 … Continue reading Site Downtime
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.