You are here: Re: Two MySQL servers, one script « PHP Programming Language « IT news, forums, messages
Re: Two MySQL servers, one script

Posted by Rik on 08/17/07 15:06

On Fri, 17 Aug 2007 16:54:17 +0200, Jerim <wyount@gmail.com> wrote:
>> The fact that these 2 servers can hardly communicate is a real proble=
m.
>> You'll either have to get the output data and link it to age 'manuall=
y'
>> with PHP, or you'll have to really think about the database(server) =

>> setup.
>> Preferably all related data on one server, possibly a master/slave
>> scenario.
>
>
> We have discussed changing the setup, but are limited in what we are
> allowed to do and by how much time we could dedicate to a project.
> Which is practically none.

Then you'll have to have a PHP script running on one server, get the =

output of that on the other (using CSV or serialize() for the output com=
es =

to mind), and link the related data on that server with it with a bunch =
of =

queries.

> You mention including raw PHP. I don't know what you mean by that.

On a typical HTTP request, PHP code will be executed, and all you get is=
=

the output. If you however output the code itself (either by disabling P=
HP =

(for that directory), giving it another non-processed extention, or by =

'building PHP with PHP' (<?php echo '<?php echo "foo"; ?>' ?>)), it can =
be =

processed on the requesting server.

> Could you please describe the process vaguely, so I know what to
> search for?

It wouldn't help you, as the code doesn't get executed on the server it =
=

comes from in that case, but on the server doing the include. Think abo=
ut =

it, if I could just include from other servers by HTTP and have access t=
o =

their code, I could do something like this:

<?php
include('http://www.paypal.com');
mysql_query("UPDATE `balance` SET `amount` =3D 999999999999 WHERE `id` =3D=
=

'me'");
?>

So, clearly it doesn't work that way.
-- =

Rik Wasmus

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация