#Analytics awstats how to
#Analytics awstats full
#Analytics awstats code
#Analytics awstats free

We are only interested in getting the country name. The response is a JSON object comprising a lot of data. We will send a GET request to, passing ' ip' as the parameter using PHP curl. We will use the IP address derived above to query for the country.

#Analytics awstats how to

Related article: How to get the current date and time in PHP Getting the user IP addressīelow is how you get the IP address of the user in PHP: The next step is to get the current time in DateTime format.

#Analytics awstats code

Here I won't go much into details, use the PHP code below to get the URL.

#Analytics awstats full

In a previous article, I explained in detail how to get the full URL of the current page using PHP language. Now that our database table is ready, the following step is to collect the information we want to save. Related article: Creating and setting up MySQL database in cPanel Our table will be created and look like below in PhpMyAdmin. `created_at` timestamp NOT NULL DEFAULT current_timestamp() In your MySQL website database, create a table with the fields(columns) as below with this SQL query:

And lastly, the time in which they leave the page.

The time in which the visitor gets into the page.

The country from which the visitor is viewing the page.

With this tool, we will be able to store a record of every unique page visit. In this tutorial, I will take you through a step-by-step procedure on how to create a custom website analytics tool (like Google Analytics) using PHP, MySQL, and jQuery Ajax. In fact, most people would discourage you from reinventing the wheel. In most cases, you won't need to make your own analytics tool. With it, you can as well track multiple aspects of your website traffic. With it, you can view how many visitors your website has had over a given duration, the countries in which your visitors are coming from, the devices they are using, how they get to your website, how they leave your website, how long they stay on your site, the most visited pages, number of visitors currently viewing your website and their location, etc.Īnother powerful and popular tool for analytics is AWstats, a tool that comes already packaged in your web hosting cPanel account.

#Analytics awstats free

Google Analytics for instance is the most popular free website traffic analytics tool owned by Google. There exist many and great tools that can help in tracking and monitoring the traffic to a website. There is then the need to monitor, measure and track the marketing efforts through the amount of traffic the website gets in return. With huge traffic (number of website visits) comes great opportunities such as increased brand awareness, more app installations, more leads, more sales (of physical or digital products), more income through display advertisements, more income from affiliate marketing, etc.Īs a way of getting more traffic to their websites, many website owners go an extra mile to market their websites through multiple ways such as Search Engine Optimization (SEO), Pay per Click (PPC) advertising, Search Engine Marketing (SEM), Social Media Marketing (SMM), Email Marketing, Affiliate Marketing, Content Marketing and Influencer Marketing among other ways. In whichever niche or industry your website falls under, you definitely wish to have as much traffic as you possibly can. It is with no doubt the desire for all website owners to have as many people as possible visiting their websites.

John Mwaniki / How to build a custom web analytics tool in PHP, MySQL and jQuery Ajax