— You Are At The Archives for the mysql Tag —

MySQL Dump of My Countries Table

03.03.09 // CakePHP // (0)

Struggling to find a decent English version with anĀ ISO 3166-1 alpha-2 code, I decided to work my own from the Wikipedia page. The MySQL dump features a lowercase code so you can use country flags from here without worrying about string conversion to meet filenames. So here is the 3 column table:
Download:: Countries.sql

Ultimate Guestbook Tutorial: How to build a Guestbook with a honeypot, error checking, IP banning, pagination, e-mail notification and smilies with PHP and mySQL

04.26.08 // PHP // (50)

In this tutorial i will teach you how to make a guestbook script with PHP and mySQL. Guestbooks are very common today on the internet and are great for getting user feedback or a simple hello from your site fan’s. This tutorial will feature form submission techniques, user input error handling, smilies, honeypot traps, and [...]

Tutorial: How to build a poll system with PHP and mySQL

04.11.08 // PHP // (49)

If you have been doing the other tutorials on this site you will notice that I have been teaching PHP and mySQL through projects. Projects that you can slot into your website, or if you are building a project, code that you can use within your project. I start from the ground up, assuming you [...]