PHP Custom Web Statistics Part 3

PHP Custom Web Statistics Part 3 Support

In today's tutorial, Gareth provides and walks through the the code to collect and display of your site's visitor statistics. We examine ways to select data in MySQL and display different types of hits in PHP. You learn how to identify different browsers, opeating systems, and whether the visitor is a "bot" or not ( robot from a search engine or other web crawler) and, if so, how to identify its origin, in order to display statistics to help you understand who visits your site.

Please note that this article forms part of a chapter in the DMXzone e-book PHP Web Applications for Dreamweaver: Juicy Solutions for the Busy Developer.

Overview

Contents:

Creating the month.php Page

Changing the Page Title

Adding a Page Heading

Creating the Hits per Day Table

Adding custom functions to the dataFunctions.php include File

dataHitsPerDay() – Reads the number of hits per day for a particular month from the database

dataVisitorsPerDay() – Reads the number of visitors per day for a particular month from the database

dataPagesPerDay () – Reads the number of pages per day for a particular month from the database

daysFillBlanks () – Creates a list of consecutive day results

Adding the HTML

Creating the Hits by Operating System Table

The User Agents Field

Modifying the dataFunctions.php include file

Adding the HTML and PHP

Creating the Hits per Browser Table

Creating the Hits by Spiders / Bots table

What are Spiders / Bots?

Adding the HTML and PHP Code

Expanding the System

Summary

Gareth Downes-Powell

Gareth Downes-Powell Gareth has a range of skills, covering many computer and internet related subjects. He is proficient in many different languages including ASP and PHP, and is responsible for the setup and maintenance of both Windows and Linux servers on a daily basis.

In his daily web development work he uses the complete range of Macromedia software, including Dreamweaver MX, Flash MX, Fireworks MX and Director to build a number of websites and applications. Gareth has a close relationship with Macromedia, and as a member of Team Macromedia Dreamweaver, he has worked closely in the development of Dreamweaver, and was a beta tester for Dreamweaver MX.

On a daily basis he provides support for users in the Macromedia forums, answering questions and providing help on a range of different web related subjects. He has also written a number of free and commercial extensions for Dreamweaver MX, to further extend its capabilities using its native JavaScript API’s or C++.

As a web host, Gareth has worked with a range of different servers and operating systems, with the Linux OS as his personal favourite. Most of his development work is done using a combination of Linux, Apache and MySQL and he has written extensively about setting up this type of system, and also running Apache and MySQL under Windows.

See All Postings From Gareth Downes-Powell >>