Track Links Clicked On My Website Using HTML and PHP

Question

I have a website that I would like to record on links clicked on each page. As an example, below is the code for my index.html page in which I attempt to record a link:

<a href="https://mystie.html/trackIndexPageLinks.php?token=1" role="button" tabindex="0">ADA</a>

Where "trackIndexPageLinks.php" is the name of my php file and "?token=1" is the php variable and value that I would like to record in my server.

Listed below is the php code that I use to store the value and pass it to my server:

<?php

$db_hostname = '???.?.?.?';
$db_database = 'mySiteDB';
$db_username = 'something';
$db_password = '';

$db_server = mysql_connect($db_hostname, $db_username, $db_password);

if(!$db_server) die("Unable to connect to MySQL:".mysql_error());

mysql_select_db($db_database)
    or die("Unable to select database: ".mysql_error());
echo @mysql_ping() ? 'true':'false';

$token = $_GET['token'];

//Create insert statement - inserts data into the database.
$sql = "INSERT INTO clickLog (linkClicked) 
VALUES ('$token')";

//Error check to ensure SQL statement took.
if (!mysql_query($sql)) {
    die('Error: ' . mysql_error());
}

//Close connection.
mysql_close();

?>

However, I get no recorded records. Any assistance on this would be greatly appreciated.

Your code is vulnerable to SQL injection. See http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php. — Jeremiah Winsley, Jan 23 '15 at 03:49
Debug says "script '/home/ubuntu/workspace/html/trackIndexPageLinks.php' not found or unable to stat, " — pol_guy, Jan 23 '15 at 04:23
Thanks anyway guys, I figured it out. I wasn't not referencing my php root. Jeremiah Winsley, thanks for the SQL injection advice and link. — pol_guy, Jan 23 '15 at 04:31

score 1 · Accepted Answer · answered Jan 23 '15 at 04:08

1

You're much better off to sign up with google analytics and add snippets of javascript code they provide. They can give you complete detail as to who is linking to what on your page as well as what links they click as well as the order they click them in.

Go to: http://www.google.com/analytics/

All you need is a google account and if you don't have one, you can sign up for one. The whole thing is free.

answered Jan 23 '15 at 04:08

Mike, I appreciate the tip, but I'm going with my gut on this maintaining the data myself. – pol_guy Jan 23 '15 at 04:32
For anyone who may need to know, the first bit of code should have been: ADA

pol_guy

Jan 24 '15 at 02:35

Track Links Clicked On My Website Using HTML and PHP

1 Answers1