Link Indexing Help?

[Crypt24]

Can someone help me regarding how or what is the name of such a script that you enter links with date / time , Hits , Title , Author shown automatically .

Example:

--------------------------------------------------
Date ¦ Title ¦ Author ¦ Hits
--------------------------------------------------
17.03.06 Link Name 1 John 345
05.03.06 Link Name 2 Albert 453
01.02.06 Link Name 3 Jack 54
--------------------------------------------------

I want a php script that does that , anyone can point me to the right direction? Thank you

[coopster]

Welcome to WebmasterWorld, Crypt24.

Have you considered using the Apache logs?

[Crypt24]

Thanks Coopster . No i mean i want to add links on my website as in on my index.html . Can i add an example url of a site so you can understand better?

[eelixduppy]

So you want to be able to add links to your homepage, then next to that you want to echo the record of who submitted that link as well as how many times it has been clicked?

[Crypt24]

yes eelixduppy , thats exactly what im looking for . Do you know how to go about it? Please do let me know . Thanks

[eelixduppy]

Since time doesn't allow for me at this moment, I'll guide you but I cannot give you a detailed description. You can find information about the Basics of extracting data from MySQL [webmasterworld.com] in our Library [webmasterworld.com]. This should get you off to a good start learning the different aspects that will be involved in your task. But this is generally how it should work:

1. Have the user login [webmasterworld.com]
   
2. Have a members-only form that allow link submission
   
3. Validate the information they enter and strip unwanted content(Regular Expressions? [webmasterworld.com])
   
4. Add the link, the user(sessions [us3.php.net]), the date/time(date [us3.php.net]) to a db table; have another column for clicks
   
5. Loop through all links in the db--echo them to the homepage
   
6. When a link is clicked, have it go to a page where it checks [webmasterworld.com] to see if the link exists in the db, if it does then add 1 to the click column then redirect, if not, redirect to the url anway. It should be like this: http://www.example.com/count.php?url=http://example2.com
   

Ummm...yea...something like that.

Anyway, I hope I've helped. You may also be able to find some pre-made scripts online. I would search HotScripts [hotscripts.com], SourceForge [sourceforge.net], etc... [google.com]

Good luck!

P.S. If my explanation doesn't make any sense, it's because I was typing quickly ;)

[Crypt24]

Thank you eelixduppy , i need to do alot of research to understand what your trying to say , as im very new to this . I'll look for a pre-made script for now , Can you tell me what's the name of the script called? I tried looking under Link Indexing in hotscript but couldnt find any related to what im looking for . Maybe you can recommend me a few scripts or just tell me what do people call this kinda script , i know your busy . I really appreaciate your help