Shell scripting?

Anon

Hi there,

I'm developing a statistics viewer. I have a table with raw data. I get like 10.000 - 30.000 visitor per day, so that table is very big 🙂

My problem is that calculating all data everytime takes so long that my browser times out. Then, I though of shell scripting that could execute a PHP script that calculates data each night, so I have static pages I can view each day.

I read the column by Darrell Brogdon in the Column section of PHPBuilder. I'm using the PHP module on a Apache webserver. I don't know much about Linux, but is there absolutely NO other way to do shell scripting if you don't have a CGI-compiled PHP version? TIA.

Greetz,

Vincent Driessen
Venlo, The Netherlands

Anon

Can't you just write a c application that calculates the data.. I think that would be the easiest way...

Andreas Bernhardsen

Anon

Try this:

#!/usr/bin/bash
lynx http://localhost/path/to/your/script.php

as a cron-job
I don't know, whether lynx has a timeout, but mostly the problem is the max_execution_time value in the php3.ini, so set it high enough.

The directory shoud be secured with
Order allow,deny
deny from all
allow from localhost

But it is also no problem to have installed a CGI- and a module-version of PHP simultanously, for the cgi-version use:
./configure --prefix=/usr/local --enable-discard-path .....[other directives, no apache-directives]
your php-shell-scripts should start with
#!/usr/local/bin/php -q
<?php
...

Anon

Hi
Could anyone help me?
I've written a php4 shell script which polls our network devices with snmpget requests and writes the responses to a file.
As you would expect, when there is no response from a device, a warning message pops up on the screen "<b> Warning </b> No response from ...."
I'm using a the shell call
"#!/usr/local/bin/php -q", but I still get these warning messages, is there any way to disable them in this script?
Thanks in advance
Scott