Creating a database for the web page visitor counter

Creating a database for the web page visitor counter:

The first thing we’re going to do is create a database in MySQL and call it “visitors”. Using “phpMyAdmin”, open up this “visitors” database ” and run the following SQL to create the tables in your database.

CREATE TABLE IF NOT EXISTS `visit` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  `visit_count` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ip_address` (`ip_address`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
The above SQL code will create a table named “visit” and include three columns in it. The first column is for “ID” with “Auto_Increment” property. The second column is for “ip_address”, which we’ll use to store the IP addresses of each site user. And the third column is for “visit_count” – this is for unique visitors to your website who visit more than once. Each time this user stops by, the value in this column is incremented by 1.