Tracking unique visitors only?

by

The simplest method would be cookie checking.

A better way would be to create an SQL database and assign the IP address as the primary key. Then whenever a user visits, you would insert that IP into the database.

  1. Create a function included on all pages that checks for $_SESSION['logged'] which you can assign whatever ‘flag’ you want.
  2. If $_SESSION['logged'] returns ‘false’ then insert their IP address into the MySQL database.
  3. Set $_SESSION['logged'] to ‘true’ so you don’t waste resources logging the IP multiple times.

Note: When creating the MySQL table, assign the IP address’ field as the key.

<?php 
  session_start();
  if (!$_SESSION['status']) {
    $connection = mysql_connect("localhost", "user", "password");
    mysql_select_db("ip_log", $connection);

    $ip = $_SERVER['REMOTE_ADDR'];
    mysql_query("INSERT INTO `database`.`table` (IP) VALUES ('$ip')");

    mysql_close($connection);
    $_SESSION['status'] = true;
  }
?>

More Related Contents:

  1. when i refresh will delete all records
  2. how to send birthday mail from website without opening website [closed]
  3. how to fetch data from a database?
  4. How do I send a POST request with PHP?
  5. How to read if a checkbox is checked in PHP?
  6. Print numeric values to two decimal places
  7. Convert dot syntax like “this.that.other” to multi-dimensional array in PHP
  8. HTML Element Array, name=”something[]” or name=”something”?
  9. Remove index.php From URL – Codeigniter 2
  10. Convert array into csv
  11. HTML – Change\Update page contents without refreshing\reloading the page
  12. How to set upload_max_filesize in .htaccess?
  13. How to get the client IP address in PHP
  14. Add columns to admin orders list in WooCommerce
  15. Send PHP HTML mail with attachments
  16. Create an order programmatically with line items in Woocommerce 3+
  17. Codeigniter multiple file upload messes file extension
  18. getting multiple checkboxes names/id’s with php
  19. How to increase memory limit for PHP over 2GB?
  20. RegEx BackReference to Match Different Values
  21. What is a good parser generator for php?
  22. laravel collection to array
  23. How to include file outside document root?
  24. Regex to match text between commas
  25. Is using prepared statements necessary? [duplicate]
  26. Reverse the order of space-separated words in a string
  27. How to run multiple insert query in SQL using PHP in one go?
  28. Can I detect animated gifs using php and gd?
  29. How to enable SSL in Wamp Server?
  30. php prevent & creating codes in a string [duplicate]

Leave a Comment