— You Are At The Archives for the sql Tag —

Feeling Dirty After So Much SQL

04.28.09 // CakePHP // (0) // 12 views

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 // (57) // 44,664 views

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