hi frenids
i have 2 var in database names
oil ,money
i want Increased them every second by these calculation:-
$oil=$oil+1;
and display them by id in html page that the visitor can view the vars Increase in the page like as timer
please how can i do these php code ??

...Ok then!

You want an auto-incrementing variable to show up on the page? Except the database values are updating every second? Seems like an awful system to me; incredibly heavyweight on the server.

To make it easier on your poor server, grab the value from the database with PHP, and use that in a JS loop that increments 1/sec. No need to make an AJAX call every single second while the DB updates, it's redundant.

I assume you know how to get data from a database? If not, this is all you need to know. To do what I said in Javascript, load the variable with PHP into a JS variable. From then on, use setInterval() to update the value in a box every second (1000 ms).

I hope I could help, if you need anything else, please ask

Side note: You can just use $oil++; instead of $oil=$oil+1;

EDIT: Heck with it, I'll write something

Not tested, but SHOULD work. <<-- emphasis on the 'Not tested'!

<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or die("Could not connect: " . mysql_error());
mysql_select_db("mydb");
$result = mysql_query("SELECT oil,money FROM mytable");
$result=mysql_fetch_array($result);
list($oil,$money)=$result;
?>
<script type="text/javascript">
var oil = <?php echo $oil;?>;
var money = <?php echo $money;?>;
function addone(){
	document.getElementById("money").innerHTML = parseInt(document.getElementById("money"))++;
	document.getElementById("oil").innerHTML = parseInt(document.getElementById("oil"))++;
}
setInterval("addone()",1000);
</script>
<div id="money"><?php echo $money;?></div>
<div id="oil"><?php echo $oil;?></div>

Just swap out the PHP values for your MySQL information / table name / database name and you should be good. I'm not 100% on that parseInt part, as I've never used parseInt. (Is it math.parseInt?)

Just to note that it couldn't be done with PHP anyway, as PHP runs ONCE, when the page is requested.
When the page is served to the user agent PHP execution is over and done with.

thank you so much Mr.Physicsguy

you only the one give me the answer after one month searching about the best way to make it !
i test your code in fact not work but you helped me to edit the code and finally work !!
these it the new code

PHP Code:

<?php
//these vars for example but in real code i will take it from mysql database
$oil=1000;
$money=2000;
?>
<script type="text/javascript">
var oil = <?php echo $oil;?>;
var money = <?php echo $money;?>;
function addone(){
    document.getElementById("money").innerHTML = money++;
    document.getElementById("oil").innerHTML = oil++;
}
setInterval("addone()",1000);
</script>
<div id="money"><?php echo $money;?></div>
<div id="oil"><?php echo $oil;?></div>

these vars for example but in real code i will take it from mysql database
i know how to get data from a database

i am sorry but i will ask you Several questions about php because i am currently I try to develop game for internet browser like travian.com
if you do not mind please answer me


Mr.Physicsguy my second question that how to save values in db after updating every second?
So as not to lose the visitor his data after the update in the case of exit from the site without logging off or close
what the best way to make it?

Instead of doing it by PHP code, add a "last_update" field ond the db, so it's like this:

primary_id, oil, money, last_update
1,0,100,1334355

last_update contains the unix time of the last update, to update all use this query:

PHP Code:

<?php
$units_per_second = 1
mysql_query("UPDATE `table` SET `last_update` = ".time().", `oil` = (".time()." -`last_update`) * ".$units_per_second);

Matt

I am new to this field but from what I have learned so far it can be done through JavaScript and not PHP.

I hope my post was helpful.

Regards
Arifeen