Track Visitors using Codex & jQuery
-
Hi guys,
This is what I wish to accomplish:
A visitor visits my site and views a post:
– visitor ip is obtained and stored
– a counter is added to a database with unique post idBut if the visitor views the post again within 24 hours:
– the counter must not increment
– obvisouly this will be based on the fact that the visitor ip address has just been logged in the past 24 hoursAgain:
If the visitor view another post:
– the same process should occur
– store ip address and add a counter incrementAt the moment i have the post displayed as links on the front page, so the script i have is run from the links. This will be the case on the site as well… i am no so interested in the posts being viewed, but rather on the post links clicked from the home page.
The script I have is below (not fully functional – the logic is wrong, please assist):
function updateCustomerCount() { global $wpdb; $post_id = $_POST['id']; // customer id // update ip address to reduce redundant click count $remote_ip = $_SERVER['REMOTE_ADDR']; if ($remote_ip){ $results = $wpdb->get_results("SELECT IP_Address FROM wp_logged_ip WHERE IP_Address=" . $remote_ip . "AND CustomerId = ". $post_id . "AND Date = " . date("Y-m-d h:i:s") ); if(!$results){ $wpdb->insert('wp_logged_ip', array('IP_Address' => $remote_ip, 'CustomerId' => $post_id, 'Date' => date("Y-m-d h:i:s"))); // update customer count $wpdb->insert('wp_customercount', array('customerid' => $post_id, 'date' => date("Y-m-d h:i:s"))); } } }
Shout if you need any clarification.
- The topic ‘Track Visitors using Codex & jQuery’ is closed to new replies.