How to Access MySQL at Web Hosts Without phpMyAdmin
While most web hosts have phpMyAdmin installed for their customers to use, there are plenty out there that do not. The phpMyAdmin interface is what most developers have become accustomed to when developing MySQL based websites. If phpMyAdmin is not installed on your web host, there are several options that will allow you to access [...]
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 Properly Store Currency/Money in MySQL
I have looked this up a number of times because I can never quite remember the exact procedure. I have decided to document this, primarily for myself, but I hope others find it useful as well. They method I have found the most useful for storing money in a MySQL database it using a float [...]
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 [...]