On 11/12/2012 12:38 PM, Johan Vermeulen wrote:
> Dear All,
>
> we have some Nubuilder databases on a Centos6.3 server:
>
> [root@caw-server2 db]# ls /var/www/html/nubuilder/db
> reg_begeleidingsteam reg_jww_archief reg_personeel reg_straathoekwerk
> reg_bib reg_jww_dossiers reg_resident reg_vrijwilligers
> reg_drughulp reg_jww_dvd reg_signaleren
> reg_jac_activiteit reg_onthaal reg_sollicitatie
>
> in each database I have placed a executable file cron.php
>
> -------------------------------------------------------------------------------------------------------------------
>
> <?php
>
> include "./config.php"; //nuBuilder config file
> $conn = mysql_connect($DBHost, $DBUser, $DBPassword);
> mysql_select_db($DBName,$conn);
>
> /**************************************************************
> emptying zzsys_trap and zzsys_variable tables
> **************************************************************/
> $sql = "TRUNCATE TABLE zzsys_trap";
> mysql_query($sql);
> $sql = "TRUNCATE TABLE zzsys_variable";
> mysql_query($sql);
>
> /**************************************************************
> Deleting temp tables
> **************************************************************/
> $result=mysql_query("SHOW TABLES FROM $DBName ") or die(mysql_error());
> if(mysql_num_rows($result)>0)
> {
> while($row=mysql_fetch_row($result))
> {
> if(substr($row[0], 0, 3) === '___' && strrev(substr($row[0], 0,
> 3) === '___'))
> {
> $sql = "DROP TABLE $row[0]";
> mysql_query($sql);
> }
> }
> }
> ?>
>
> ------------------------------------------------------------------------------------------------------------------------------
>
> for each file I can easily execute the file cron.php :
>
> [root@caw-server2 reg_bib]# php cron.php
>
> with the desired effect.
>
> *However *when I try to execute the cron.php files from a script :
>
> ----------------------------------------------------------------------------------------------------------------------------
>
> #!/bin/bash
> for i in `ls /var/www/html/nubuilder/db`
> do
> php /var/www/html/nubuilder/db/$i/cron.php
> done
> exit 0
>
> ------------------------------------------------------------------------------------------------------------------------------
>
> or just try to execute the script from an absolute path:
> [root@caw-server2 jvermeulen]# php
> /var/www/html/nubuilder/db/reg_bib/cron.php
> PHP Warning: include(./config.php): failed to open stream: No such file
> or directory in /var/www/html/nubuilder/db/reg_bib/cron.php on line 3
> PHP Warning: include(): Failed opening './config.php' for inclusion
> (include_path='.:/usr/share/pear:/usr/share/php') in
> /var/www/html/nubuilder/db/reg_bib/cron.php on line 3
> PHP Notice: Undefined variable: DBHost in
> /var/www/html/nubuilder/db/reg_bib/cron.php on line 4
> PHP Notice: Undefined variable: DBUser in
> /var/www/html/nubuilder/db/reg_bib/cron.php on line 4
> PHP Notice: Undefined variable: DBPassword in
> /var/www/html/nubuilder/db/reg_bib/cron.php on line 4
>
> I get a shipload of EM.
>
> I don't understand why this works but not from an absolute path.
>
> Any help would be greatly appreciated.
>
> greetings, J.
>
include "./config.php"; <==that is only working from within the correct directory
Attachment:
signature.asc
Description: OpenPGP digital signature
_______________________________________________ CentOS mailing list CentOS@xxxxxxxxxx http://lists.centos.org/mailman/listinfo/centos
