Countdown Timer interact with php mysql

Question

I want to construct a countdown timer so the customer gets discount on price if he buys the product before countdown ends.

I've search internet and found a lot about countdown timer using Jquery, Javascript...

But how can i say in PHP that if the countdown is running then the product has 50% discount Else if countdown ends(00:00:00) delete discount, return product's price to normal.

The price is stored in the database.

Your PHP doesn't need a timer. Just check the current time against the time your countdown ends. — Joseph Silber
– Joseph Silber, Commented Jan 3, 2012 at 14:41
You should store in database an end date (datetime actually) and check if the current time is before this `end date. — JMax
– JMax, Commented Jan 3, 2012 at 14:42

score 1 · Accepted Answer · 2012-01-04 14:16:52Z

1

No need for timer. Jut store discount date time in database with product.

and if purchase time is within that time apply 50% discount else no discount. You can do this by any means either apply if/ else condition using PHP or handle if/else and datetime comperisions in mysql query.

edited Jan 4, 2012 at 14:16

answered Jan 3, 2012 at 15:18

user319198

Sign up to request clarification or add additional context in comments.

Comments

Pirozek · Accepted Answer · 2012-01-03 15:01:15Z

You just need to store in database the end time of countdown with something like this

INSERT INTO user_offers SET countdown_end = DATE_ADD(NOW(),INTERVAL 5 MINUTE), user = ...

This will insert row with current time + 5 minutes. Assuming that you have logged in user, you will insert item id and user id, otherwise you need to develop your own way to recognize user (cookie for example), so that refreshing page would not refresh countdown.

Then you will need some jQuery (I like jQuery, but you can use whatever you want) magic for countdown, like this plugin http://keith-wood.name/countdown.html

When user clicks on ORDER NOW button (or smthing like that) you just check user_offers table like this

SELECT countdown_end FROM user_offers WHERE countdown_end > NOW() AND user = ...

If it returns something than you know, that he clicked in limit :)

Collectives™ on Stack Overflow

Countdown Timer interact with php mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related