[SOLVED] Hit counter that resets weekly?

[nfx]

I'm trying to make a hit counter that resets back to 0 every 7 days, to show which page is the hottest that week. How do I go about making a timer like that?

[Maq]

Could you be a little more explanatory?  Like what you're counting?

[nfx]

Each of my pages counts a hit when the page is loaded. So I have a counter that totals everything. What I'd like is to make it count a hit twice when a page is loaded, one for the original counter and one that resets back to zero every 7 days. The only part I don't know how to do is to get it to reset.

 

I mean right now the total hit counter isn't very useful. Pages that have been on there for a couple years are going to be leaps and bounds higher than recently added pages. I just want a more relative counter.

[premiso]

CRON job on UNIX or Scheduled task on Windows. Create a script that runs once a week and have it wipe the hit counter clean.

 

If you want more help post some code....something cause right now your question is way too vague.

[The Little Guy]

create a "cron job" that runs once every seven days.

 

then just create a query such as:

UPDATE `table_name` SET counter = '0'

[nfx]

create a "cron job" that runs once every seven days.

 

then just create a query such as:

UPDATE `table_name` SET counter = '0'

 

Ah, thank you. I've never used CRON so this helps a lot. Should be everything I need, thanks.

[Maq]

Cron is relatively easy to use, just specify time and script you want to execute.  The hardest part is the time-format.

[The Little Guy]

When you create your cron job, make sure you place the php file that will run out side of the root directory, or you could have some major issues.

[nfx]

So I just create a php file with nothing but the code to connect to the database and to set each counter to 0? And the cron command is the url to the php file? Sorry, I know I already checked this off as solved, just want to make sure before I ruin something.

[Maq]

You need to go to your crontab and edit it. At the CLI type (i think):

 

crontab -i

 

to edit your cron and add in the time parameters and the path to the script you want executed.

[The Little Guy]

are you using "cPanel"?

[nfx]

Yes I'm using cPanel.

 

If I wanted it to run every Sunday at 2am, would my crontab be?

 

* 02 * * sun /somefolder/script.php

 

Or would the path have to be /home/<user>/public_html/somefolder/script.php?

[premiso]

Yes I'm using cPanel.

 

If I wanted it to run every Sunday at 2am, would my crontab be?

 

* 02 * * sun /somefolder/script.php

 

Or is it not that simple?

 

You would need to use the PHP CLI command for UNIX to accomplish that. Google PHP CLI CRON for examples.

 

EDIT:

For your script it would look like

* 2 * * 0 /usr/bin/php -f /home/phpscripts/yourscript.php

 

Given that php is installed to /usr/bin/

 

[Maq]

Or is it not that simple?

 

Yes it is as simple as that.  Although I'm not sure if your time is correct.

[nfx]

So...

 

* 2 * * 0 /usr/bin/php -q /home/<user>/public_html/somefolder/script.php

 

Should do every Sunday a 2am. Hopefully that's right?

[premiso]

So...

 

* 2 * * 0 /usr/bin/php -q /home/<user>/public_html/somefolder/script.php

 

Should do every Sunday a 2am. Hopefully that's right?

 

Yep that should do it.

[The Little Guy]

cPanel has a built in cron editor, that may make it easier to write the cron (if your not using that)