Includes and Dbs...Any way to do ?

jangoux

Hello everyone,

I wrote some php scripts to gather some data from a Db, which resides on another server. The problem is that the Db only accepts connections from 'localhost', and cannot accept anything from where my php script resides, creating the need to store the scripts inside the same host as the Db, which doesn't work for me.

Anyway...I thought of using Include() to add the code store on the Db host, to include it on the host i need it to be. Will it work ? When include is ran, it is executed on the host it is stored or on the host the Include() function resides ?

If it doesn't work, do you think there is any workaround for this ?

Cheers,
Ivan

LordShryku

Even if you include it, it will be executed from the current server. It only includes the code, not the enviroment. If you need to execute the code from a different server, you should setup the DB to accept connections from the remote server.

mmilano

what kind of data is it? if it is something simple, like a list of names, you can make a php script to output the names on the remote server ( assuming it has php ), then read it from your local application.

for example, the remote php script would look something like this:

<?
$result=mysql_query("select user from users");
$num=mysql_numrows($result);

for($i=0;$i<$num;$i++)
{
  echo mysql_result($result,$i,"user") . "\n";
}
?>

this will generate a text file with a username on each line.

on your local app, or wherever the script is that you want to read it, use the file() function. file() takes each line into an array.

<?
$array = file("http://remoteserver.com/script.php");

foreach($array as $each)
{
  echo "$each <br>\n";
}
?>

if you have more complicated data, it will be more difficult without a direct connection to the db.