触发PHP处理

Question

I ask a similar question yesterday but it all got confusing and I thought I would start again and try and explain it a bit better..

I am about to design an auction site, much the same as ebay... items start from 24,12,7,3,1 days and count down until they are finished..

Now its easy for the page that shows the item to know its finished via ajax/jquery BUT, i presume i would need to run some sort of scheduled script that checks when auctions have finished.

This script will need to convert the auction in the database to finished so that in the sellers profile they can see its finished and the buyer can pay.

The trouble is if a script runs every 5 minutes, it means it could take up to 5 minutes for the auction to appear as finished in the sellers profile area, which is naff.

Also the Buyer wouldn't be able to pay until its converted over...

However if I were to run a script every 30-60 seconds surely this will be too much load on the server as the script may run multiple times if it has many auctions to convert and it takes more than 30-60 seconds to run ??

Answer 1

I don't think that a scheduled script is the solution you are looking for. You could set the auction status when you display it to a user - being that on auctioner's profile, or in auctions list or anywhere else . This way, you are guaranteed that who sees the auction, is seeing it with the status from when the page was loaded. Anyway, having a scheduled script to update the status is recommended only when you have heavy business logic to be done when an auction expired