RE: [PHP-DB] Remote DB Connection: Pros and Cons?

> Have any of you tried running a PHP website using a remote database > connection? Yes. If you mean the web server is on 1 box and the database server is on a 2nd box. > We currently have an in-house PHP website driven by a PostgreSQL database > that is HEAVILY administered within the office

RE: [PHP-DB] Remote DB Connection: Pros and Cons?

What about setting up replication between the servers? Make the the web a slave of the office one and make it read only so avoid messing up the data. bastien> Date: Thu, 11 Oct 2007 18:08:29 -0600> From: [EMAIL PROTECTED]> To: php-db@lists.php.net> Subject: Re: [PHP-DB] Remote DB Connection: P

Re: [PHP-DB] Remote DB Connection: Pros and Cons?

Tony Grimes wrote: Splitting the tables probably wouldn't work. Most of the tables are used by both sites and the ones that aren't are tied to the rest by foreign keys. Most of the updates are done from the admin site, so we're toying with the idea of creating a read-only data warehouse for the

Re: [PHP-DB] Remote DB Connection: Pros and Cons?

Hi You would be better off with the database server and php on the same server - both sites. You will find there is significant lag if there is a poor connection between the web and database server, but if you are just accessing web pages and updating data, even with large pages there is not much

Re: [PHP-DB] Remote DB Connection: Pros and Cons?

Splitting the tables probably wouldn't work. Most of the tables are used by both sites and the ones that aren't are tied to the rest by foreign keys. Most of the updates are done from the admin site, so we're toying with the idea of creating a read-only data warehouse for the website. The sync wou

Re: [PHP-DB] Remote DB Connection: Pros and Cons?

Tony Grimes wrote: Have any of you tried running a PHP website using a remote database connection? We currently have an in-house PHP website driven by a PostgreSQL database that is HEAVILY administered within the office with an administration sister site (also PHP). Problem: the office connec

[PHP-DB] Remote DB Connection: Pros and Cons?

Have any of you tried running a PHP website using a remote database connection? We currently have an in-house PHP website driven by a PostgreSQL database that is HEAVILY administered within the office with an administration sister site (also PHP). Problem: the office connection is having trouble

Re: [PHP-DB] Is displaying image in php tough?

Chris Carter wrote: I am trying to fetch the image from the database image field. Fetching it from $image=mysql_result($result,$i,"image"); And displaying it with: ../stores-images/ I know it requires some if else or array to display. This is new for me. The second result in google was

Re: [PHP-DB] Is displaying image in php tough?

I'm assuming that you have the image uploaded into a directory on the server. All you need to do is have the html tags: print "" - Original Message - From: "Chris Carter" <[EMAIL PROTECTED]> To: Sent: Thursday, October 11, 2007 10:16 AM Subject: [PHP-DB] Is displaying image in php t

[PHP-DB] Is displaying image in php tough?

I am trying to fetch the image from the database image field. Fetching it from $image=mysql_result($result,$i,"image"); And displaying it with: ../stores-images/ I know it requires some if else or array to display. This is new for me. Please help! Chris -- View this message in context: