Schedule question

[Anon]

Hey there,

Does anyone here know how to create a scheduler application that works with cron (or similar application) in PHP?

My goal is to have scheduler application that runs in the background and then triggers certain events at pre-defined times.

Any ideas would be appreciated.

-- John G.

[kailien]

cgi or standalone PHP and cron would do the trick

Kai

[Anon]

i have create the form with different box,but when i send my form to SQL,the sever report me that there is a error of connection.

pheraps is the string - $db _connect();

what i can do for connectme to the mySQL???
i must use the ODBC under control pannel of
windows and if it so how ican configure it? or there is an other utility to set connection Sql (php)?.

Thank

[Anon]

Thanks ...

Assuming I didn't want to rely on Cron for every scheduled process, but instead wanted to run a php script in the background that checked every so often if there was a script to run and ran it...? Is this be possible with php?

[Anon]

Have a meta tag embedded in the HTML that refreshes the screen every so often

<meta name="refresh" attrib="some interval">

you'll have to consult the actual syntax, that's just some idea

jan-mike ^_

[Anon]

If I understood your question correctly, you are connecting a client script onto a mysql database.

Use the built-in PHP mysql functions

$dbhost = 'localhost';
$dbuser = 'someuser';
$dbpass = 'somepassword';
$dbase = 'database_to_use';

$cnx = mysql_connect($dbhost, $dbuser, $dbpass) or die ("Cannot connect to Database Host: $dbhost with Username: $dbuser and Password: $dbpass");

mysql_select_db($dbase) or die ("Cannot use the database: $dbase");

If you use Windows ODBC to connect:

try the following, assuming that your odbc has been properly set up

$dbuser = 'someuser';
$dbpass = 'somepassword';
$dbase = 'database_to_use';

$cnx = odbc_connect($dbase, $dbuser, $dbpass) or die ("Cannot connect to ODBC database: $dbase with Username: $dbuser and Password: $dbpass");

Make sure to grant permission to the internet user or create a special application role or user for $dbuser

in query analyzer (in microsoft sql 7)
grant all on $dbase to $dbuser;

or in mysql;

bin/mysql -u root -pPassword -e mysql 'GRANT ALL ON databasename.* TO username IDENTIFIED BY 'password'";

if that doesn't work then you'll have to log in and do that command.

hope that helps.

jm
use mysql;

$cnx = odbc_connect

[Anon]

But this would require a client browser to be running, isn't it?

Is it possible to schedule an event to be run afeter a period of time (I mean server-side, like a Cron, but under windows).

Thanks!