[SOLVED] Undefined variable with require_once

[isaac_cm]

Hello,

I get the following notice whenever I try to call a function from my file :

Notice: Undefined variable: database_mainsqldb in F:\mysite\Site Template\includes\myfunc.php on line 7

 

this variable "$database_mainsqldb" is defined in this file "../Connections/mainsqldb.php" and I include this file like that:

<?php require_once('../Connections/mainsqldb.php'); ?>

 

I tried to use the same function in the same calling page and it work fine without the previous notice!! the error appear only when I try to call it from myfunc.php

 

here is the script of myfunc.php

function delete_attr($aid){

  mysql_select_db($database_mainsqldb, $mainsqldb);

  $deleteSQL = "DELETE FROM table1 WHERE at_id=" . $aid;

  $Result1 = mysql_query($deleteSQL, $mainsqldb) or die(mysql_error());

 

}

 

plz advice

thanks

[GingerRobot]

I suggest you loop up variable scope and functions. To start with, try reading through this section from a free online php book:

http://hudzilla.org/phpwiki/index.php?title=Variable_scope_in_functions

 

Basically, variables declared outside of a function aren't available inside a function unless you pass them into it as a parameter, or use the global keyword.

[isaac_cm]

I see now, but what you suggest, I dont want to make global variables for security reasons

 

I do not want also to place those functions in mainsqldb.php.

 

any other solutions ?

 

thanks

[isaac_cm]

never mind I will pass the variables as an arguments