Skip to main content

PHP: Recording Page Hits

Wanted to create something that was easy to use, maintain and grow. It's extremely basic as it is. It stores the page visited and if the user is logged in, their id; if the user is not logged in, it currently stores "0" as the user id.

Later, this class might expand to store the user's browsing history by recording their IP address and the pages that they visit.

You'll first need to create 2 tables within your database: pages and statistics. You'll need 3 but I'll show you how to create two. The third one is users that you should probably already have if your users are logging in at all. Note: I'll show you how to create the ReportError class in my next post.

The pages stores the URI for each page. You don't want to store the page within the statistics table, just the id. This is for optimization and to minimize repetitiveness.


The next table is the statistics table. This table contains the id's referencing other tables and the times the page was accessed by the individual user. All non-logged-in users are grouped together. The users_id references your users table (you'll need to have a constant id for the user logged in). If the user is not logged in, he or she is assigned the value of 0. The page_id stores the id for that particular page located in the pages table. The times_accessed column stores the amount of times that particular combination occurred (i.e. the unique id and page id combination: you'll need to have both the users_id and page_id set to PRIMARY to use the ON DUPLICATE KEY UPDATE feature listed in the code below).


When the user logs in, you'll need to save their id into the session variable.

When the main() method within the StoreHistory class gets called, the following steps take place:
  • Instantiate the Database Connection and Error Reporting classes
  • Establish connection to the database
  • Initialize the $_page_id property
  • If the page was never accessed before, store the page URI and the today's date.
  • If the page was previously accessed update the last_accessed column with today's date.
  • You'll notice in the code that I also set id = LAST_INSERT_ID(id). You'll need to use this when the ON DUPLICATE KEY UPDATE is called and you want to still retrieve the last insert_id.
  • Check whether $_SESSION['users_id'] is active and not empty. If not, store the users_id otherwise store "0" as the value.
  • If this is the first time that this unique combination is being stored within the statistics table, insert the value of "1" into the times_accessed column; otherwise, update the times_accessed table by adding 1 to it.

Comments

Post a Comment

Popular posts from this blog

Beginner Java Exercise: Sentinel Values and Do-While Loops

In my previous post on while loops, we used a loop-continuation-condition to test the arguments. In this example, we'll loop at a sentinel-controlled loop. The sentinel value is a special input value that tests the condition within the while loop. To jump right to it, we'll test if an int variable is not equal to 0. The data != 0 within the while (data != 0) { ... } is the sentinel-controlled-condition. In the following example, we'll keep adding an integer to itself until the user enters 0. Once the user enters 0, the loop will break and the user will be displayed with the sum of all of the integers that he/she has entered. As you can see from the code above, the code is somewhat redundant. It asks the user to enter an integer twice: Once before the loop begins, and an x amount of times within the loop (until the user enters 0). A better approach would be through a do-while loop. In a do-while loop, you "do" something "while" the condition
13 comments
Read more

Programming Language Concepts Questions/Answers Part 3

1. What is an associative array? - An unordered collection of data elements that are indexed by keys. 2. Each element of an associative array is a pair consisting of a _______ and a _______. - key and a value 3. True or False? Java supports associative arrays? - True. As a matter of fact, Perl, Python, Ruby, C++, C# and F# do too. 4. What are associative arrays called in Perl? - hashes 5. Why are associative arrays in Perl called hashes? - Because their elements are stored and retrieved with a hash function 6. What character does a hash in Perl begin with? % 7. In Perl, each key is a _____ and each value is a _______. - string - scalar 8. In Perl, subscripting is done using _______ and _______. - braces and keys 9. In Perl, how are elements removed from hashes? - using delete 10. In Perl, the ________ operator tests whether a particular value is a key in a hash. - exists 11. What are associative arrays called in Python? - dictionaries 12. What is a dif
6 comments
Read more

Creating your own ArrayList in Java

Wanted to show that certain data structures in Java can be created by you. In this example, we'll go ahead and create an ArrayList data structure that has some of the methods that the built in ArrayList class has. We'll create 2 constructors: The default constructor that creates an ArrayList with a default size of 10. Constructor that allows an initial size to be passed to the array. We'll also create a number of methods: void add(Object x);  A method that allows you to place an Object at the end of the ArrayList. void add(int index, Object x);  A method that allows you to place a value at a given location. Object get(int index):  Allows you to retrieve a value of the arrayList array from a given location. int size();  Allows you to get the number of elements currently in the Arraylist. boolean isEmpty();  Tests to see if the Arraylist is empty. boolean isIn(Object x);  A method that sees if a particular object exist in the arrayList. int find(Object x);  
50 comments
Read more