How to Create a Simple Podcast RSS Feed using PHP and MySQL
Generating a podcast RSS feed with PHP is actually very easy. I have had to do it a few different times and every time I do it I have to look up the syntax of the XML document. To save myself time in the future I thought I would document the process here for myself [...]
Ranking MySQL Results by Multiple Columns
Today I got a request from a reader to make a post about how to rank MySQL results by multiple columns. This is actually really easy to do so it shouldn’t take long to explain. Basically when doing the query you can just add multiple items in the ORDER BY argument in your MySQL query. [...]
How to Create a Simple RSS Feed using PHP and MySQL
Generating a RSS feed with PHP is actually very easy. I have had to do it a few different times and every time I do it I have to look up the syntax of the XML document. To save myself time in the future I thought I would document the process here for myself and [...]
Multiple Column Text Search of MySQL Database Using PHP
I have done this a few times but I can never quite remember how it works. Thanks to some assistance from Sheldon I was able to put together this simple tutorial on how to create a PHP search that will automatically search multiple MySQL columns, score the results, and return the results ordered by relevance. [...]
How to Format Raw Byte File Size into a Humanly Readable Value Using PHP
Nothing like spending a beautiful Fall Saturday morning programming, that is the story of my life. I am finally getting close to completing VoiceTales. One of the last steps in the project to create a simple function that shows a humanly readable file size value for each recording a customer makes. I looked around and [...]
Cool Ajax Tutorials and Examples
A friend Sheldon tipped me off to a cool set of Ajax tutorials at the Smashing Magazine website. There are all kinds of great examples using various JavaScript libraries like MooTools and jQuery. If you’re bored click through and check out some of these cool ideas and examples. http://www.smashingmagazine.com/2008/10/16/50-excellent-ajax-tutorials/
How to Find Tomorrow, Next Month, or Next Year using PHP
I found an interesting new way to find a future or past day, month, or year using PHP. It is much easier than using a timestamp and mktime() to calculate a new date. Since this method was so easy I thought I would share it with all 3 fans of my blog. How this method [...]
Simple Random Images with PHP
Since it is a Saturday and I only spent a few hours at work today, I didn’t have a chance to do anything too fun or innovative which means I don’t have anything new to write about. So instead I thought I would write a quick helpful tutorial on how to create randomly rotating images [...]
Using MySQL in and between Clauses
In and between are two functions MySQL offers that aren’t something I use on a daily basis but they are incredibly useful from time to time for specific operations. The in() function can be IN() or NOT IN() and the same is applicable for BETWEEN or NOT BETWEEN. Here some example queries of this functionality [...]
PHP Script to Automatically Force File Download
I am working with a friend to help develop a simple interface for a backup system he is operating. Basically, the script displays a secure list of files by filename and each filename is clickable to download the corresponding file. I have forced the download of files using PHP in the past but the method [...]