Function – Splitting a string

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

Downloading and Installing Heidi SQL

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.

Using jQuery to Reorder a List and Update a Database

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.

Sending E-Mail to validate User Sign-up

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.

How to Parse a CSV File Using PHP

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.