[Resolved] popular pages

[rayzun]

Im new to scripting and need some help

Is it possible to use data from the url, record it into MySQL or text data file
so as to display the popular pages from a site.

Any PHP+MySQL ideas or links are needed?

---

I had the idea started with no luck...

the url is basic structure like:
domain.com/tmplate.php/1038/BMW

list($first, $last) = explode('/', substr($PATH_INFO,1));
$entry_line = "$first/$last\n";

$fp = fopen("/public/count.txt", "a");
fputs($fp, $entry_line);
fclose($fp);

the explode grabs the 1038/BMW
from the url and records into a text file.

[Drakla]

It's also a terrible idea! You'd end up with a massive file that you'd then have to reparse anyway.

Your idea of grabbing the url each time and then updating a value in the database is much better. If the url is really long ( > 32 chars) md5 it and use that as the database key.