Google Analytics - PHP

[ndev2k]

Not sure how you can get this to work as you cannot run anything with an output before the redirect. The only possible solution would be to use output buffering but there is no guarantee that this would run the complete javascript for the analytics code before redirecting.

[MJ10]

Hmm, I guess I'll just have to leave it. Was just hoping I could do some more in depth analysis of what links worked best.

Thanks anyway for trying!

[ndev2k]

The best bet would be to include a counter on the links. Might be something to ask Charlie about

[cono1717]

I assume your trying to find out if ?id=freeipod is clicked more than ?id=freeipad ?

You could just have one redirect page and use the ?id=XXXXX tags so like

<?php
$site = $_GET['id'];
$sql = mysql_query("SELECT * FROM `clicks` WHERE `site` = '$site'");
$row = mysql_fetch_array($sql);

$old = $row['clicks'];
$new = $old +1;
mysql_query("INSERT INTO `clicks` (`id`, `amount`) VALUES ('$site', '$new')");


REDIRECT CODE

Haven't tested that but that's my general idea.

[ndev2k]

Could you not simply expand on that and still use the same redirect code from the _GET statement after the counter had been added to? The parameter will still be the same even after the click has been added to the database

Or am I missing something again.

p.s. You will also have to put in the SQL connect parameters. I am going to have a play around with this later as I want to incorporate the redirect on my site and would like it to count clicks.

Will let you know how I get on.

[chigley]

Originally Posted by cono1717

I assume your trying to find out if ?id=freeipod is clicked more than ?id=freeipad ?

You could just have one redirect page and use the ?id=XXXXX tags so like

<?php
$site = $_GET['id'];
$sql = mysql_query("SELECT * FROM `clicks` WHERE `site` = '$site'");
$row = mysql_fetch_array($sql);

$old = $row['clicks'];
$new = $old +1;
mysql_query("INSERT INTO `clicks` (`id`, `amount`) VALUES ('$site', '$new')");


REDIRECT CODE

Haven't tested that but that's my general idea.

mysql_real_escape_string() is your friend It escapes user input to stop them doing nasty SQL injections.

For example, if I went to yourfile.php?id='; DROP TABLE `clicks`;--, assuming I haven't made any mistakes, I could delete your table

[cono1717]

I have a script set up on my pc that everytime I use $_GET it rewrites it to the escape, was using my macbook for that and so didn't set textexpander up for it.

But yes, use charlie's so it would be

$site = mysql_real_escape_string($_GET['id']);