PHP File Executeable

What is it?

It’s mean PHP File can be execute as bash file and generate some action to my Linux Box.

What For?

I make php file executeable because I don’t have advantage experince to make bash file, but I know a little bit about PHP for access database and show it on web.

HowTo make it?

In this HowTo, I make example that PHP file access database (PostgreSQL), query some data from table, and save that data to another table. I run this PHP file on my Debian Server.

Install some packages

aptitude install php4 postgresql libapache2-mod-auth-pgsql
php4-pgsql php4-cli

Make PHP File

vi runphp.php

Add this line to the first line

#!/usr/bin/php4

And make you own script with PHP Syntax. You can see my example file here (rename it from .txt to .php). This file doing this following actions:

Connect to database (PostgreSQL).
Get some data from database.
Determine cost variable from that data with some function.
Insert usefull new data into another table.

Make It Execuable
Make sure this php file can be execuate by:

chmod +x runphp.php

Get Error?

First time I run this file, I get this following error:

Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: ....

Don’t worry, this error can be happen because by default PostgreSQL support for php4 in Debian is not enabled yet in the configuration for the Apache2 SAPI. So type this command:

dpkg-reconfigure php4-pgsql
/etc/init.d/apache2 restart

That error should be fixed.

Run This File

Just type this command

./runphp.php

Well done and Good Luck
–

me, sUpricak3p