— You Are At The Archives for the sql Tag —

Feeling Dirty After So Much SQL

04.28.09 // CakePHP // (0)

What this does is go through my Apache log in my MySQL DB and calculate unique hits, overall hits, amount of bandwidth used per month, and only for the past 3 months! Making sure each month begins and ends on the first and last day of the month, not using timestamps from the current date! [...]

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 [...]