I've 2 computers 192.168.1.1(php&mySql) and 192.168.1.2(php&Oracle), I want to send data from one to another, example:

Computer 1:
-----------
index.php (this page will print a result from query in Computer 2)
<?
 ...
 $fromC2 = header("location: http://192.168.1.2/query.php?action=q");
 echo $fromC2; //it won't print anything :(
?>

Computer 2:
-----------
query.php (this page will receive request from Computer 1, running query and send result back to Computer 1)

<?
 ...
 function getQ(){
    $query = "....";
    ....
    //echo $data; //this will print data
    return($data);
 }

 switch($_REQUEST['action'])){
   case 'q' : getQ();break;
   .....
 }
?>

question is:
How can I print the $data(return value from Comp 2) in Computer 1(index.php) ?

thanks

Hi,

I dont know of a way to actually return the object data to computer1, but you could echo the data in C2 in a structured format like XML, then use the normal IO functions in C1 to read this, similar to how a web service works. Something like this:

/* computer 1 */
$fp = fopen("http://192.168.1.2/query.php?action=q", "r");
$fromC2 = fread($fp, 1024); // remember filesize() doesnt work with urls
fclose($fp);

// parse XML in $fromC2 here
echo $fromC2;

/* computer 2 */
function getQ()
{
  $query = "....";
  // create XML from result set here
  echo $xmldata; // this will print data for C1 to read
}

switch($_REQUEST['action'])
{
  case 'q':
    getQ(); break;
  .....
}

Instead of text/XML you could use some binary format if you wished (just remember to put "rb" in fopen on windows).

Hope this helps
Philip Cole

thanks philip_cole,

but how about if I'm going to paging the result, because data from comp 2 is quite big, example:

....
$query = "select * from myTable";
$result = mysql_query($query);
$data = mysql_fetch_array($result); //now $data contains many
....

If I print it in comp2, offcourse no big deal I just put
while($rec = mysql_fetch_array($result)){
  echo $rec['myField'];
}

my question is, is it possible to send $data from Comp2, so I can print it in Comp1 (like I print it in Comp2) ?


thanks

Output the data as either a pdf, or text, then take that file and print it on the other computer??