foreach loop to connect to multiple databases

ejwf

I have a code that inserts records into a database
The thing is I want to apply this code to numerous different databases.
In my master database I have stored a field containg the path to the file that holds the mysql_connect information for each of the databases.
I want query the master database to list all of these paths, then create a loop that goes through each of the databases and runs the code.
This is what I have at the moment

//connect to master database
require_once('/home/aaa/bbb/htdocs/ccc/ddd/mysql_connect.php');

// get all of the paths
$query = "SELECT Path FROM tblCo";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$Path = $row["Path"];

foreach ($Path as $value)
{
// connect to the database
require('$value');

//run the code to insert data.......

}     //  foreach
} //close if

This gives the error message
Invalid argument supplied for foreach()

Any ideas what I am doing wrong - thanks

justsomeone

foreach requires an array to work with, you're only passing in a single field.

have you tried just doing:

require("$Path");

I'm not sure how that will work out though, as you will be including multiple files all (re)assigning different values to the same variable(s).

ejwf

Thanks - I have changed

$query = "SELECT Path FROM tblCo"; 
$result = mysql_query($query); 
$row = mysql_fetch_array($result); 
$Path = $row["Path"];

to the following to force an array output

$query = "SELECT Path FROM tblCo"; 
$result = mysql_query($query); 
while($row = mysql_fetch_array($result))
$Path[] = $row["Path"];

now I have more than one variable for the foreach ....

however now moved on to a databse connection issue.

after making this change I got the following error message Warning: main($value): failed to open stream: No such file or directory in /home/aaa/bbb/htdocs/ccc/ddd/code.php on line 24 so it is looking for the new database mysql_connect file in the exisiting location - this is never going to happen
so I have added an exit(); as the first line in the foreach clause, to exit the current master database before looking for the new connection information.

Now I get nothing happening - no error message - and the code doesn't input the information as required...........

The code I have now is

 //connect to master database 
require_once('/home/aaa/bbb/htdocs/ccc/ddd/mysql_connect.php'); 

// get all of the paths 
$query = "SELECT Path FROM tblCo"; 
$result = mysql_query($query); 
while ($row = mysql_fetch_array($result))
$Path[] = $row["Path"]; 

foreach ($Path as $value) 
{ 
exit();

// connect to the new database 
require('$value'); 

//run the code to insert data....... 

}     //  foreach 
} //close if

any ideas anyone? - thanks

thorpe

exit will exit the script. do you have files in place for each of these connetions? what do these files contain?

ejwf

thanks for this - so how do I close the connection to the master database wihtout existed the code?

What I want to do is close this connection so that I can open a new connection to each of the subsequent databases via the Paths called in from the array........

The files exist already, I have tested the paths and they work OK as a stand alone code i.e. connect to this database and then run the code..........
Each of the files contains the mysql_connect information e.g database name / password etc.

thanks

Roger_Ramjet

It is not neccessary to close existing connections before opening new ones, simply give each a unique name.

That said, you just need to use the correct close function for the exisitng connection: ie mysql_close() for mysql databases, odbc_close() for an ODBC connection, etc

ejwf

thanks but mysql_close(); isn't doing it..........
I get the error message Warning: main($value): failed to open stream: No such file or directory in /home/aaa/bbb/htdocs/ccc/ddd/code.php on line 24 again.......

am I going about this the wrong way? IS there a better way of doing this other than creating a new file to run the code for each instance of the database?

thanks