Tracking script, one small problem???

[Aliz__]

first here is my very small script that tracks how many hits certain links have. . .

<?
$connection = mysql_connect("localhost","username","password") or die("Couldn't connect to server.");  

mysql_select_db("dbname");
mysql_query("UPDATE ".$_COOKIE['username']." SET count=count+1 WHERE id=1");
Header("Location: $url");
?>

Is how it works is lets say you want to track a link, instead of putting http://www.domain.com you would put http://www.mysite.com/track.php?url=http://www.domain.com
and that is how it is tracked.

Now my problem is, sometimes it works and other times it won't.
I did a test linking to my site (http://www.google.com) so my link was http://www.mysite/track.php?url=http://www.google.com and everything worked great. it updated my database and forwareded you to http://www.google.com

Now I have another link which is

http://www.mysite/track.php?url=http://www.specificsite.com/rd/Clk.jsp?s=wf&k=keyword&lnk2=rhhE%3F..iy29%27wBAyekxpr%27fsCqvrkh%27pDB.osC.fsCqvrkh%27qAA%3EpAsplhrxDigr%29t%3DH8441%29w%3DIPpl5VF6ugxg147aHWwZOBsM%3A1NJVlf2u9ZM%3FBLUzAb1kJ%3A0F97Gy8DYgLUh%3AbDNf0f%3Ah9j1YCNlJJ2fpTUVhXxhmgRyuV8oFd941s7j5LrmZJ9hW872h0jtOJUXjA%3ASHUZZRU8%3FhU2QRWBfgV10KB74z1dW7Asl59BuFV1VFZJZZ%7C2%2729&p=17373&sid=747113&ex=1100835534913

but it won't work. it forwards me to http://www.specificsite.com/rd/index.jsp
but if I just copy and paste the actual link into the browser without the tracking part then it works fine.

Does anybody know why it might be doing this. . .
If you have any questions or need me to explain anything better please ask and I would be happy to help.

Thanks!

[jesus_hairdo]

Hi there, i suspect that what you need to do is to URLENCODE the link you are trying to visit as all of the parameters you are passing in the url are going to your script and not the URL you want to visit.

So to form your tracking link do this:

<?php
$url = urlencode('http://www.specificsite.com/rd/Clk.jsp?s=wf&k=keyword&lnk2=rhhE%3F..iy29%27wBAyekxpr%27fsCqvrkh%27pDB.osC.fsCqvrkh%27qAA%3EpAsplhrxDigr%29t%3DH8441%29w%3DIPpl5VF6ugxg147aHWwZOBsM%3A1NJVlf2u9ZM%3FBLUzAb1kJ%3A0F97Gy8DYgLUh%3AbDNf0f%3Ah9j1YCNlJJ2fpTUVhXxhmgRyuV8oFd941s7j5LrmZJ9hW872h0jtOJUXjA%3ASHUZZRU8%3FhU2QRWBfgV10KB74z1dW7Asl59BuFV1VFZJZZ%7C2%2729&p=17373&sid=747113&ex=1100835534913');
?>
http://www.mysite/track.php?url=<?php print $url;?>

Then in your counting script you need to decode the url:

<?php 
$connection = mysql_connect('localhost', 'username', 'password') or die('Could not connect to server');
mysql_select_db('dbname');
mysql_query('UPDATE '. $_COOKIE['username'].' SET count=count+1 WHERE id = 1');
header('Location: '. urldecode($url));
?>

Hope this helps.

Jamie

[Aliz__]

I have this line of code, where would I put the urlencode part in this. . .

<a target='_blank' href='http://www.domain.com/track.php?url=" + sUri + "'>

[Aliz__]

Anybody???

[Aliz__]

anybody. . .please. I have tried almost everything, except for the correct way hehe.

where would I put the urlencode on this line

<a target='_blank' href='http://www.domain.com/track.php?url=" + sUri + "'>

the " + sUri + " is used by javascript and is where the url is entered in.

Hope that helps.

Thanks

[tsinka]

Please post the complete code including the part of the HTML code where sUri comes from. You might need to do this completely with javascript (escape, onClick and window.open).

Thomas

[Aliz__]

Originally posted by tsinka
Please post the complete code including the part of the HTML code where sUri comes from. You might need to do this completely with javascript (escape, onClick and window.open).

Thomas

here is the code from the rest of my page that deals with the uri
all of this script is javascript. . .

<script>
 var listings = new Array ();
 var RelatedSearches = new Array();
 var TopSearches = new Array();
 var Searchfeed = new Object();

 var params = new Array();
 function escapeStr(str){
   var s = escape(str);
   s = s.replace( /\//g,"%2F" );
   s = s.replace( "#", "%23" );
   return s;
 }
 function unescapeStr(str){
   var s = unescape(str);
   s = s.replace( /\+/g," " );
   return s;
 }

 function parseParams(s) {
   var v = 1;
   q = s.indexOf('?');
   if (q != -1) {
     t = s.slice(q+1);
     t = t.replace(/%26/gi, "&");
     z = t.split('&');
     for (i=0;i<z.length;i++) {
       if (z[i] != "") {
         v = z[i].split('=');
         params[v[0]] = v[1];
       }
     }
   }
 }
 parseParams(document.location.href);
 function getParam(s) {
   return params[s];
 }

 var keyword = getParam("q");
 if (keyword == null || keyword == "undefined") {
   keyword = "";
 }

 var page = getParam("page");

 if (page == null || page == "undefined") {
   page = 1;
 }
 page = parseInt(page);
 if (isNaN(page)) {
   page = 1;
 }
 if (page < 0) {
   page = 1;
 }
 var numRes = 5;
 var partnerId = 17373;
 var rndStr = Math.random()*100000;
 document.write("<scr" + "ipt src='http://www.domain.com/rd/feed/JavaScriptFeedRel.jsp?rnd=" + rndStr + "&cat=" + keyword + "&trackID=K25330&pID=" + partnerId + "&nl=" + numRes + "&p=" + page + "'>" + "</scr" + "ipt>");
</script>


<script>
    if (listings != null && listings.length > 0) {
    document.write("<table border='0' cellpadding='2' cellspacing='0'>");
      for (i = 0; i < listings.length; i++) {
        var sTitle = listings[i].title;
        var sDesc = listings[i].description;
        var sUrl = listings[i].url;
        var sUri = listings[i].uri;
        var fBid= Math.round(100*listings[i].bid)/100;
        var sBid = '';
        if (fBid > 0) {
          sBid = "(Bid Amount: <a target='_blank' href='http://www.domain.com/rd/AdvertiserInfo.jsp?pID=17373'>" + fBid + "</a>)";
        }

    document.write("<tr>");
    document.write(" <td align='right' valign='top'><b>" + ((numRes*(page-1)) + i+1) + ".</b></td>");
    document.write(" <td valign='top'><a target='_blank' href='http://www.mysite.com/track.php?url=" + sUri + "'><b>" + sTitle + "</b></a>");
    document.write("<br>" + sDesc );
    document.write("<br><b>URL:</b> " + sUrl + "");
    document.write("<br><br>");
    document.write(" </td>");
    document.write("</tr>");
  }
   document.write("</table>");
   } else if ( q != "") {
     document.write("<font><br><br><br></font>");
   }
            </script>

[tsinka]

Ok,
at the line where you write the link to the track script replace

....url=" + sUri + "'><b>............
with
url=" + escape(sUri) + "'><b>

Thomas

[Aliz__]

Originally posted by tsinka
Ok,
at the line where you write the link to the track script replace

....url=" + sUri + "'><b>............
with
url=" + escape(sUri) + "'><b>

Thomas

Thanks I will try that. what is the difference between sUri and escape(sUri). Just so I understand what im doing.

Thanks

[tsinka]

The problem is that you need to urlencode the url you want to submit because it contains GET parameters. Without urlencoding the PHP script will get only parts of the url. So characters like ? and & will be converted to their 2 digit (or 4 digit) equivalent with escape and the track.php script will get the complete url.

Thomas

[Aliz__]

Thank you so much, it works perfect now.

Its amazing what one word can do.
The big problems are always the smallest things.
Thanks again!