Can i write php code to connect 2 MySQL DB. like this case. ?

[Pratchaya]

Hi, All


Can i write php code to connect 2 MySQL DB. like this case. ?

My Environment :

Server < ---- > PC Client

Server =
::: Apache for Linux
::: MySQL Server ( A )

PC Client =
::: Apache for window
::: MySQL Server ( B )


I want
1.1 write php code action like this

php code on Apache for window ( on PC ) connect to MySQL Server ( A )
and get data to
MySQL Server ( B ) instantly.

Can i do like this. ?
and How to ..
Anyone have experience ?




Thank you very much
Pratchaya


PS. Caz i don't want to connect via 3306 port between server and PC ,
i believe that it 's not secure.

[Marcin Dobrucki]

Re: Can i write php code to connect 2 MySQL DB. like this case. ?

Pratchaya wrote:[color=blue]
> Can i write php code to connect 2 MySQL DB. like this case. ?[/color]

connect how? Replicate data or join data or something else?
[color=blue]
> PS. Caz i don't want to connect via 3306 port between server and PC ,
> i believe that it 's not secure.[/color]

Faith has nothing to do with it:
http://dev.mysql.com/doc/refman/5.0/...nnections.html

/Marcin