Re: How to connect to remote database server through PHP?

"Manisha" <manisha@aurica.com> wrote in message news:4.2.2.20010621135100.00a21c30@192.168.1.116... > Hi, > > We are developing web application. The client wants it to get connected to > their central database server in USA. Web server is in Singapore. > > Web server configuration - Situated in Singapore, unix / php / mysql - > this database is only for some special cases where application does not > require central database. > > Main central database server - Situated in USA, HP UX / sybase > > On web site we will be providing product listing and order form. After the > order is confirmed and payment is made, client wants to update some fields > on central database. > > Can anybody give me the details, how to do it? If I am using php, how to > connect to remote server's database? What are the components require on > both servers? How will be the network configuration? Any information > source? Any mailing list for network connections ? Connecting to Sybase: http://www.php.net/manual/en/function.sybase-connect.php or http://www.php.net/manual/en/function.sybase-pconnect.php for persistent connections. There is a valuable user comment on the bottom of this page. Complete overview of PHP Sybase functions at http://www.php.net/manual/en/ref.sybase.php Connecting to MySQL: http://www.php.net/manual/en/function.mysql-connect.php or http://www.php.net/manual/en/function.mysql-pconnect.php for persistent connections. Complete overview of PHP MySQL functions can be found at http://www.php.net/manual/en/ref.mysql.php. hth Meint