Member Avatar for m-soft

Hi,

I want to make for my articles site a script for user tracks.
I want to make a table with

NAME | URL | BACKLINKURL | PAGERANK | ADDEDdate | check date| coment | HITS

and if someone comes on my site from | URL | than increase hits with 1.
On table i will insert URL from sites where I have a link to my site.

How can I do this for a fast execution from time point of view ?

Thanks !

  • 2 Contributors
  • 1 Reply
  • 98 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by zippee
Member Avatar for zippee

If you are using mysql, then use update

$url = $_SERVER['HTTP_REFERER'];
$update = "UPDATE table SET hits = hits+1 WHERE url = '$url' ";
mysql_query($update) or die('Query failed: ' . mysql_error());

This wil not take more than 5ms to execute.

P/S: Not understand your 2nd queries - Insert URL??

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.