Hello all,

I have just developed a shell script to perform some networking functions involving tc ,ip and ifconfig commands. I intend to make a GUI interface for this script so that i can change some variables of the script at ease and also a mysql database connection to store these parameters . Please is this possible without using perl scripting. if possible how.

On my own I have thought of converting the shell script to an php script by installing php-cli module and enclosing the script with <?php ?> but this has not worked. php can not recognise ifconfig ,tc shell commands .Can someone provide me hints on how to convert a shell script to php script with database connection feature. Thanks.

-Ibro

The system-function is PHP calls starts programs as if you would call them at the shell... No special compile-options to php are needed to run this...

Something to note...system() exec() passthru() and shell_exec() require safe mode to be turned off to run. If you want to keep safe mode on you need to copy the binaries you want to use to the safe_mode_exec_dir which is setup in php.ini

As for php database connectivity, there are a million good tutorials out there to get you started. Do a google for 'lamp tutorial' to find a bunch...

Thanks Bulliver and nerdstat,

I found your contributions very useful . But there is another question I want to ask.
Let me start by describing what I intend to do.:

I want this script, call it myscript to be executed at boot time .In the script, connection will be made to a mysql server from which will be read some values to be used as variables in the script .

At any time , I can change the values I have in my mysql server and I want this done through web interface using php form, so that when I restart my system , the script will execute with the new values.

Now can I use the web interface while I still use the CLI SAPI ?

Thanks.

I was reading this page:

http://www.php.net/manual/en/features.commandline.php

and it appears that you can use both. The command line version needs you to put a bang line in your script like every other shell script ie:
#!/usr/bin/php

However: you may need to rebuild php and specify a make install-cli target, because although php builds both sapi's, only the cgi version is installed by default.

Hope this helps...

Thanks Bulliver,

I will try it and get in touch with the result.

Ibro

hello all,

No, I do not think it is possible to use both the cgi sapi and the cli sapi at the same time. If one uses cli sapi then one can not display php pages in a browsers(at least that is what I experienced).

So when i used the cli sapi , i found it difficult to display my php web pages at the same time using apache 1.3 as the webserver. So i have to find another way of executing my script so that it will be able to read from the mysql database as i did while using the php cli sapi (thanks to Bulliver and Nerdstat for their hints ), and then disable the cli so that i will be able to display my other php web pages:

#!/bin/php
mysql_select_db("minedb",$conn);
$irs0=mysql_query("SELECT * FROM shin WHERE dbflag=0",$conn);
$irs1=mysql_query("SELECT * FROM shin WHERE dbflag=1",$conn);
$irs2=mysql_query("SELECT * FROM shin WHERE dbflag=2",$conn);
$irs3=mysql_query("SELECT * FROM shin WHERE dbflag=3",$conn);


while ($irw0=mysql_fetch_array($irs0))
{
ifconfig {$irw0["ifdev"]};
............
.............
}


I was able to realise later that it is actually possible to execute mysql statements in a shell script,even connecting to databases like this:

#!/bin/sh
mysql --user=root --password=ibrotj -h localhost <<!!
mysql_select_db("minedb",$conn);

SELECT VERSION(), CURRENT_DATE;
USE minedb;
SELECT * FROM shin WHERE dbflag=3;
quit
!!

But i find it difficult to find an equivalent statement like the one that retrives data sequentially from mysql database as in the php script like this :

$irw0=mysql_fetch_array($irs3);

while ($irw0=mysql_fetch_array($irs0))
{
ifconfig {$irw0["ifdev"]} ;
..........................
..........................
}

If anybody has done this or has any hints on how to do this , I will be most happy.

Thanks,

Ibro