On 8/1/07, Thijs Lensselink <[EMAIL PROTECTED]> wrote:
> On Wed, 1 Aug 2007 08:49:34 -0400, Jason Pruim <[EMAIL PROTECTED]> wrote:
> > Hi All :)
> >
> > I have a php script that I am attempting to run from the CLI to
> > connect to a MySQL database and update a field. but when I run it
> > with this command: php cronjob.php it prints out the script on screen
> > but doesn't process it...
> >
> > Running: php-r"phpinfo();" prints out the standard phpinfo screen..
> > and I don't think I should have to write it differently to make it
> > run from the command line right?
> >
> > HELP! I'm desperate... I would offer to name my first born after
> > you... But he's already been born :)
> >
> >
> > --
> >
> > Jason Pruim
> > Raoset Inc.
> > Technology Manager
> > MQC Specialist
> > 3251 132nd ave
> > Holland, MI, 49424
> > www.raoset.com
> > [EMAIL PROTECTED]
> >
> >
> >
> >
>
> Maybe you can show use some code?
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Since it's being run as a cron, that indicates that it's a
*nix-like machine, so .bat files are out of the question, but you're
on the right track, Bastien.
Jason, try creating a file like this, chmod'ing it to 0755, and
running it with the full path as follows:
[EMAIL PROTECTED] dir]$ pwd
/path/to/dir
[EMAIL PROTECTED] dir]$ /path/to/dir/file
Provided the file is named `file` and is in the same directory as
the PHP script you want to run as a cron, it should run just fine with
this code:
#!/bin/bash
phppath=`which php`
# pwd can be changed to a hard-coded directory if
# the PHP file isn't in the same directory as this script.
# However, make sure not to use the tickmarks (below
#the tilde (~), but instead use single quotes.
pwd=`pwd`
# Change phpfile.php to whatever the actual name of the PHP file is.
$phppath $pwd/phpfile.php >> /dev/null 2>&1
If that doesn't work, post the code from your PHP file and we can
all take a look.
--
Daniel P. Brown
[office] (570-) 587-7080 Ext. 272
[mobile] (570-) 766-8107
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
