Show most visited links

[berraf]

I have a webpage with links which I wish to make a top ten-list of so I need a script that will do the job for me

If anyone have a tip how to do this it would be of great help. Thanks

[alexgeek]

i think that this would require you to add to a mysql record every time i page is loaded.

[alexgeek]

do you know how to create mysql tables?

[berraf]

Thanks for reply!
I have a database but I don't know how to make a table in it.
I only have permission to one database.

I found a script called GoLinks but I get stuck when it comes to create a table in my database.
GoLinks seems good but I don't need all of the stuff that comes with it

[Blake121]

Do you know if your server has phpMyAdmin installed?

That is the easiest way to work with MySQL databases. It does all the work for you

otherwise your going to have to learn some SQL, you can learn through some of these sites.

http://www.w3schools.com/sql/default.asp
http://sqlcourse.com
http://www.sql-tutorial.net

[alexgeek]

make a database called web (or something) and I can make a quick code for you

[berraf]

Originally Posted by alexgeek

make a database called web (or something) and I can make a quick code for you

Okey, I've made the database and would really appreciate the code from you

[alexgeek]

alright then,
5 mins.

[alexgeek]

save this as createtable.php then run it, if you get errors tell me.

PHP: Select all

<?php
mysql_connect ('localhost', 'put_username_here', 'put_password_here') ;
mysql_select_db ('web');

$sql = "create table users (pagename varchar (255), hits int (20) default '0');";
mysql_query($sql) or die(mysql_error());
echo "table made";
?>

[berraf]

The script works like a clock! Thanks!

How can I go on from here?

[alexgeek]

Okay, I've been up all night.
not slept
I'm off to bed, and I'll do the rest for you in a few hours

[Blake121]

Well I won't actually write the script for you. We encourage learning by yourself here

I can however give you some pointers though

I'd have a table with these fields: id|url|hits

Then the link on the page would be something like this "outgoing.php?id=1"

Then the outgoing.php script would extract the url from the database with the matching id as the one in ?id=x

If a match is found you then update hits to add one on.

If all go well you then redirect to the url (using header() function) which you have just pulled out of the database.

This may not be the best way of doing it but it will work.

Hope this will help ya out,

Blake

[alexgeek]

Originally Posted by Blake121

Well I won't actually write the script for you. We encourage learning by yourself here

I can however give you some pointers though

I'd have a table with these fields: id|url|hits

Then the link on the page would be something like this "outgoing.php?id=1"

Then the outgoing.php script would extract the url from the database with the matching id as the one in ?id=x

If a match is found you then update hits to add one on.

If all go well you then redirect to the url (using header() function) which you have just pulled out of the database.

This may not be the best way of doing it but it will work.

Hope this will help ya out,

Blake

or instead of headers and stuff.
you could just include a script on every page you want ranked,
and that script would add one to the table.
a lot easier

[Blake121]

Yeah but what's the script gonna do? hows it gonna know what link you clicked and which one to add a hit onto?

Unless you used AJAX. But that's probably more bother than it's worth lol

[alexgeek]

you don't have to know which link you clicked

[Blake121]

Why not? There's a big list of them on the page.

You'll need to know which url it is in question

Did you look at the link they posted lol

[alexgeek]

but if you put the script on every page, it will put itself in the database,
using $_SERVER['REQUEST_URI']

[berraf]

Well I'm a total newbie so it would take me to much time to learn to do this script so it would be great if I could get that help

[alexgeek]

okay.
These links, are they links to other pages on your website or links to other websites?

[berraf]

Alex, It's links to other websites...