MySQL, PHP based website statistics

php mysql graph web-statistics
heron picture heron · Feb 10, 2012 · Viewed 10.3k times · Source

Trying to integrate something like tracewatch into admin panel of my PHP, MySQL based website.

But I need 1 page solution, not heavy system like twatch with user management.

I wonder, is there any simple php class or mini app for this purpose (want to get something like this on admin page)?

Answer

Tural Ali picture Tural Ali · Mar 1, 2012

There are bunch of tracewatch alternatives. Here are somes:

Piwik

enter image description here

Piwik is an open-source Web analytics application developed using PHP and MySQL. It has a "plugins" system that allows for utmost extensibility and customization. Install only the plugins you need or go overboard and install them all – the choice is up to you. The plugins system, as you can imagine, also opens up possibilities for you to create your own custom extensions. This thing’s lightweight – the download’s only 1.9MB.

FireStats

enter image description here

FireStats is a simple and straight-forward Web analytics application written in PHP/MySQL. It supports numerous platforms and set-ups including C# sites, Django sites, Drupal, Joomla!, WordPress, and several others. Are you a resourceful developer who needs moar cowbell? FireStats has an excellent API that will assist you in creating your own custom apps or publishing platform components (imagine: displaying the top 10 most downloaded files in your WordPress site) based on your FireStats data.

JAWStats

enter image description here

JAWStats is a server-based Web analytics application that runs with the popular AWStats (in fact, if you’re on a shared hosting plan – AWStats is probably already installed). JAWStats does two things to extend AWStats – it improves performance by reducing server resource usage and improves the user interface a little bit. With that said, you can’t go wrong with just using AWStats either if you’re happy with it.

SimpleStats

enter image description here

Simple Stats is a PHP based, web analytics utility designed to enable you in monitoring visits on your website. It is very simple to install, and it's interface goes straight to the important facts such as the Google search queries (understand "the search expressions in Google") that your visitors might have used to browse to your website.

Related questions

How to generate graphs and charts from mysql database in php

How can I generate graphs and charts from a mysql database using php? I'm trying to use "chart director" but I can't even install it properly, because I'm using php version 5.3, and it's using a deprecated function dl. Do you …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More