Top Referring Site Script

Discussion in 'Programming' started by wptheme, Jul 4, 2009.

0
  1. #1
    Hi, I was wondering if there is any script that allows you to display the top 10 sites visiting your site? Thanks for any answer.
     
    wptheme, Jul 4, 2009 IP
  2. neegeris

    neegeris Banned

    Messages:
    73
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    1)insert referer

    php ->
    $ref = $_SERVER['HTTP_REFERER'];

    mysql ->
    INSERT INTO referers (referer) VALUES ("$ref")

    2)show top 10
    mysql ->
    SELECT COUNT(referer) as rfs FROM referers ORDER by rfs DESC LIMIT 10
     
    neegeris, Jul 4, 2009 IP
    wptheme likes this.
  3. jhbalaji

    jhbalaji Well-Known Member

    Messages:
    1,474
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    140
    #3
    Great thanks mate...
     
    jhbalaji, Jul 5, 2009 IP
  4. wptheme

    wptheme Well-Known Member

    Messages:
    4,051
    Likes Received:
    346
    Best Answers:
    0
    Trophy Points:
    180
    #4
    you know how to do that?
     
    wptheme, Jul 5, 2009 IP
  5. Bohra

    Bohra Prominent Member

    Messages:
    12,573
    Likes Received:
    537
    Best Answers:
    0
    Trophy Points:
    310
    #5
    As neegeris said

    You need to create a databese with those tables .. you will need some php knowledge for doing what he said as he just said the steps and didnt put the complete codes
     
    Bohra, Jul 5, 2009 IP
  6. wptheme

    wptheme Well-Known Member

    Messages:
    4,051
    Likes Received:
    346
    Best Answers:
    0
    Trophy Points:
    180
    #6
    Hi Bohra :)
    Well I have the reference to the script but I am not sure about the database. is there any guide on the net about database? Anyway thanks to everyone on this thread. Rep +
    p/s-You must spread some Reputation around before giving it to Bohra again :p
     
    wptheme, Jul 5, 2009 IP
  7. outlaw16151

    outlaw16151 Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    i would be interested in something like this for me site? ok i have the database and mysql and the way to make the tables, if ya could give me some pointers
     
    outlaw16151, Jul 17, 2012 IP