[RESOLVED] php&mysql: 3 questions

[z3d0]

1)How can I do so that a value in the database decrease a little after some minutes or hours?

2)How can I insert the cents in a script? For example, I have the table "bank" with only a cell, "balance". If I write in my php page

'.htmlspecialchars($rs["balance"]."").'

it show me a number like "1000 €", without cents. Furthermore is possible to divide the cents from the number, like "1000 € and 32 cents"?

3)How can I insert in the database the total time that the user has been on my site?

thanks 😉

[nemonoman]

3 answers:

Question 1) This question is confusing and ambiguous as you have written it.
Question 2) This question is very confusing as you have written.

For both of these questions help us by saying
what you want to happen,
your method for making it happen,
results you expected,
the unexpected results you actually got instead.

Question 3) Inserting the time spent would be simple like:
"INSERT INTO visit_tracking SET hours='1', minutes='22'"

Figuring out how long the user stayed on your sight in the first place? That, sadly, is difficult, practically impossible, and will not be accurate. You can create a javascript script based on browser "unload" events. Many browser will short circuit this event. Also, users who simply turn off their computers, or freeze up, etc., would never send an unload event even if their browsers allow it...so if you are starting a clock when the enter your site, the clock will never stop running.

[z3d0]

thanks for your answers
for the second question there are no problems, I've resolved with

$withCents = sprintf("%01.2f", $money);

The first question instead is still a problem. I'd want that a value in my db decrease after, for example, an hour, automatically. Is it possible?

[Roger_Ramjet]

Yes it's possible. On unix use cron to schedule an update script for execution, on nt use the scheduler.