CGI open database

148 views Asked by At

I require a cron job to open and export a table from my DB.

My web-host's control panel has a page for cron tasks. It requires a script to run.

I'm a .PHP & SQL guy, have never written a .CGI Script.

I would appreciate any guidance on this matter, before I waste time. Is it even possible to run SQL commands from a .CGI script?

1

There are 1 answers

0
Luc M On BEST ANSWER

Things that you have to take care:

  1. $_SERVER, $_GET, $_POST... arrays will be empty or undefined.
  2. The variables environnement will be minimalist in a cron job

There is no problem to run a CGI script.

You can also try to execute it on command line.