Results 1 to 8 of 8

Thread: Redirect script with statistics, graphs, etc

  1. #1
    yuppy emke's Avatar
    Join Date
    May 2003
    Location
    far away
    Posts
    84

    Redirect script with statistics, graphs, etc

    Maybe this is the wrong place for this topic? If it's, feel free to move it where it's more appropriate.

    Until now I've been hiding affiliate links from spiders with java script and that's fine but I would like to use a redirect script so I can track how many people click on a specific link, etc.

    I've found a great script at http://www.prolinkz.com/ but it's pretty expensive ($45) and you can only use it on one domain, I'll have several.

    I've looked on HotScripts.com but haven't been able to find a good one. Does anyone know of a good free PHP/MySQL script like the one above?

  2. #2
    Registered Mike's Avatar
    Join Date
    May 2003
    Location
    UK
    Posts
    2,755
    I think I know what you mean, but aren't 100%...

    Couldn't you make a redirection on a page, as well as starting a session. Then, make an if statement saying something like if session exists, add one to database. On a seperate page have this number requested?

    As for the graphs, I just don't know...

    Sorry if it isn't what you require.
    Last edited by Mike; 05-18-2003 at 07:40 AM.
    Don't you just love free internet games ?

  3. #3
    Administrator Chris's Avatar
    Join Date
    Feb 2003
    Location
    East Lansing, MI USA
    Posts
    7,048
    Its really very very simple.

    Make a database table with 2 fields, linkID and linkURL.

    Make your links like this:

    http://www.example.com/redirect.php?LinkID=1

    redirect.php would simply need to read the database and forward the person to the new URL.

    If you want to track clicks you'd just add on a third field, total clicks, and increment it before you redirect.
    Chris Beasley - My Guide to Building a Successful Website[size=1]
    Content Sites: ABCDFGHIJKLMNOP|Forums: ABCD EF|Ecommerce: Swords Knives

  4. #4
    Registered
    Join Date
    May 2003
    Location
    Southern California, USA
    Posts
    46
    Make your links like this:

    http://www.example.com/redirect.php?LinkID=1

    redirect.php would simply need to read the database and forward the person to the new URL.
    This is a good way to plug holes but at the expense of calling one more query to db.

  5. #5
    Administrator Chris's Avatar
    Join Date
    Feb 2003
    Location
    East Lansing, MI USA
    Posts
    7,048
    One read query shouldn't be a blip on you radar.

    You should see how many queries are necessary just to create the front page of this forum.
    Chris Beasley - My Guide to Building a Successful Website[size=1]
    Content Sites: ABCDFGHIJKLMNOP|Forums: ABCD EF|Ecommerce: Swords Knives

  6. #6
    yuppy emke's Avatar
    Join Date
    May 2003
    Location
    far away
    Posts
    84
    Thanks for the help Chris. I coded a simple redirect script in like five minutes but I was hoping there was something already available as complex like the script mentioned above as it provides a lot of great statistics, etc. Unfortunately I don't have that much time right now and must confess that I've never worked with graph creation before.

  7. #7
    Junior Registered
    Join Date
    May 2003
    Location
    UK
    Posts
    6
    JpGraph makes it easy

    Sean

  8. #8
    yuppy emke's Avatar
    Join Date
    May 2003
    Location
    far away
    Posts
    84
    Originally posted by seanf
    JpGraph makes it easy

    Sean
    thanks, I'll take a look.

Similar Threads

  1. User comments script
    By Westech in forum General Management Issues
    Replies: 18
    Last Post: 01-17-2005, 05:44 AM
  2. redirect a to website
    By ronp in forum General Management Issues
    Replies: 2
    Last Post: 04-08-2004, 11:54 PM
  3. Redirect
    By k0r54 in forum HTML, CSS, Layout, and Design
    Replies: 3
    Last Post: 03-28-2004, 03:40 PM
  4. need to exclude one page from a general .htaccess redirect
    By Apollo in forum General Management Issues
    Replies: 1
    Last Post: 01-10-2004, 01:56 PM
  5. Redirect
    By lemon in forum Search Engine Optimization
    Replies: 1
    Last Post: 09-09-2003, 12:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •