cron jobs

joeblack

hai, is it possible to do cron jobs in localhost ?
how ?😕

joeblack

i just want to make a script that run every few minute
is there a function in php ?

LordShryku

Yes, you can do cron jobs.

sleep() can have it wait, but you don't want to be running a script 24-7

joeblack

what you mean by a script 24-7 lord ?
thank's

LordShryku

24 hours a day, 7 days a week. You don't want to be constantly running a script, so using sleep() is not a good idea

joeblack

any other option lord ?, if i make a script in local and i send to
cron job on the web is it possible to work ?
thank's

LordShryku

Run the cron job local....

Why are you trying to run a cron job on your computer from another one?

joeblack

thank's
how i can get cron jobs local ????,

i do my last exam in my university i just want to run cron job
in my local comp.
thank's again lord

LordShryku

Well....first, let's establish the system. Linux or Windows?

joeblack

ok i use windows, mysql (with mycc), pws, php4 on my pc

Drakla

I remember a similar thread ages ago. They were told to use Window's Task Scheduler, maybe you can do that. Plug it into the CLI executable you get with php.

joeblack

thank's
ok the think i must do is, show the data of the student
with payment status every few minute in the
web page is that possible (the data in mysql) ?

LordShryku

Yes, you can use Windows Task Scheduler with a simple batch file.

Though, if you're just doing it in a web browser, all you need to do is build the page, and or a refresh on your interval. It should re-run the query for you, provided you build the SQL into the webpage.

joeblack

ok i still confiuos, sory
i alredy have the web page, but how we refresh it
is it use by sleep() func.

or i have to make a bacth file
and what is the batch file content? or not ?
thank's to all

LordShryku

Well, to auto-refresh, you can add this inbetween you <head> and </head>

Your inter-changable data would be

content="60
The content should be set to the number of seconds before refreshing. So the example would refresh every 60 seconds

url=page.php"
url should be set to the page you want to refresh

joeblack

ok i'll give it a try thank's lord

oh one more after head can i create the refresh query
i mean in one page

LordShryku

post your code. The query should already be on the page, and the refresh should just refresh the query and make it run again to get the new data

joeblack

page name cobadeh.php

code
<?
echo"<html>";
echo"<head>";
echo"<meta http-equiv=\"refresh\" content=\"2 url=cobadeh.php\">" ;
echo"</head>";

$link = mysql_connect("localhost", "root", "")or die(mysql_error());
mysql_select_db("md_db", $link) or die(mysql_error());

$qry1x = "SELECT * from tb_one";
$res1x = mysql_query($qry1x, $link) or die(mysql_error());

while ($row = mysql_fetch_row($res1x))
{
print"<br>";
print$row[0];
print"<br>";
}

echo"<\html>";

help please

LordShryku

Okay, so every time it refreshes, it will run your query. If any updates have happened, it should show.