[SOLVED] finding out localhost

[jakebur01]

is their any way to find out "localhost" of mysql to get the actual address? If not, is their any way to pull the content of a table off of localhost and connect to mysql on another server and insert the data into a table there?

[php_tom]

is their any way to find out "localhost" of mysql to get the actual address?

 

I don't entirely understand your question but this may help:

 

$_SESSION['SERVER_NAME'] contains the name of the server the script is running on. So this could be 'localhost' or 'myDomain.com' or whatever.

[jakebur01]

like this?

<?php
session_start();

$test= $_SESSION['SERVER_NAME'];

echo $test;

?>

[php_tom]

$_SESSION['SERVER_NAME']

AAAACCCKKKKK!!! I just wasn't thinking...

 

What I meant was:

$_SERVER['SERVER_NAME'] 

 

So yeah you can do something like:

<?php
$test= $_SERVER['SERVER_NAME'];
if($test=="myDomain.com") {
  // Link to one SQL server here
} elseif($test=="localhost") {
  // Link to localhost SQL server
} else {
  // Link to some other SQL server...
}
?>