[lupekid]

How Do I Use Cronjobs??
Anyone Need Help Trying To Do This Code

<?php

include "Safe.php"; 

$sql = mysql_query("SELECT * FROM users WHERE id='" .mysql_real_escape_string($_SESSION['user_id']). "'")

or die(mysql_error());

$row = mysql_fetch_object($sql);

$name = htmlspecialchars($row->name);

$energy = htmlspecialchars($row->energy);

$rank = htmlspecialchars($row->rank);

$energy_loss = array("1","5","10","15","30");


$sql = mysql_query("UPDATE users SET energy=energy+'100' AND energy != '$energy_inc[$rank];'");

$query = mysql_query($sql) or die(mysql_error());

?>

[no2pencil]

cronjobs are part of the linux/unix hosting environment. You don't use them in php code. It's the equivalent of the Windows Task Scheduler

[lupekid]

no2pencil, on 19 March 2012 - 07:11 PM, said:

cronjobs are part of the linux/unix hosting environment. You don't use them in php code. It's the equivalent of the Windows Task Scheduler

So how do i do this then?
I Wana add like for example 100 energy to every user on sql.
how can i do that? thanks for the reply

[lupekid]

Can i do this?

*/30 * * * * /the/script/place/script.php
wont that work? or nah

[CTphpnwb]

I have no knowledge of any case where using cron jobs to run PHP scripts is not bad design. As far as I know it is always possible to achieve the same goals without resorting to a cron job.

[no2pencil]

lupekid, on 19 March 2012 - 10:24 PM, said:

Can i do this?

*/30 * * * * /the/script/place/script.php
wont that work? or nah

Erm, without knowing what you want to do... I mean we're really taking some assumptions here.

1.) that your hosting has granted you access to the shell to install crontabs
2.) that the shell can execute php scripts
3.) that the reference php script performs an action that will be useful on a repeated basis.

If the page doesn't work, then running it every half hour doesn't really accomplish anything.

Also cronjobs have nothing to do with php coding, so I am moving this topic to web servers & hosting where this discussion is actually ontopic.