RE: [PHP-WIN] querying more than one db from a php page?
You might run into the classical update problem if you allows update in different databases and then wants to syncronize the databases with each other. To prevent update anomalies like this you need a lock mechanism between the databases. Check your RDBMD documentation on this. However if you only do updates on the main site and then propagate the update to the "sub" sites, you might like the RDBMS to handle this by it self, if so you should check if replication between databases can solve your problem. If you do updates from the main site only and propagate them to the sub sites then I do think that you should not run into any particular problem since the aporach is straight forward. -Original Message- From: George Pitcher To: [EMAIL PROTECTED] Sent: 2003-12-12 17:19 Subject: [PHP-WIN] querying more than one db from a php page? Hi, I am developing my main site to run on php/mysql (currently lasso/filemaker). I am also developing some individual sites to be hosted on the same server as my main one and I'd like to be able to update those smaller site databases when activity happens on the main site. I'm still a couple of months away from tackling that part but can anyone predict trouble ahead, and if so, any remedies? MTIA George in Oxford/Edinburgh -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-WIN] querying more than one db from a php page?
Another thought - came to me just after I posted below: If you decides to execute the same update at several databases from a php page, make sure that you actually did update all databases! Because you might like to rollback the update on all database if you fail with one for them, especially if you was not able to update the main site. However it is up to the design process to decide how much inconsistency that might be allowed betwen the databases. -Original Message- From: Svensson, B.A.T. (HKG) To: 'George Pitcher '; '[EMAIL PROTECTED] ' Sent: 2003-12-13 09:47 Subject: RE: [PHP-WIN] querying more than one db from a php page? You might run into the classical update problem if you allows update in different databases and then wants to syncronize the databases with each other. To prevent update anomalies like this you need a lock mechanism between the databases. Check your RDBMD documentation on this. However if you only do updates on the main site and then propagate the update to the "sub" sites, you might like the RDBMS to handle this by it self, if so you should check if replication between databases can solve your problem. If you do updates from the main site only and propagate them to the sub sites then I do think that you should not run into any particular problem since the aporach is straight forward. -Original Message- From: George Pitcher To: [EMAIL PROTECTED] Sent: 2003-12-12 17:19 Subject: [PHP-WIN] querying more than one db from a php page? Hi, I am developing my main site to run on php/mysql (currently lasso/filemaker). I am also developing some individual sites to be hosted on the same server as my main one and I'd like to be able to update those smaller site databases when activity happens on the main site. I'm still a couple of months away from tackling that part but can anyone predict trouble ahead, and if so, any remedies? MTIA George in Oxford/Edinburgh -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-WIN] What should I learn
I agree with toby just start working away... To learn PHP I dl code examples and projects from the web, there are a number of tutorials and examples out there on the web. The only way your going to learn to use the language is to "use the language" ... tashfoo "Toby z" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > well get or make ur self a project . include as many modules > as u can think of > > start codin in php > > go for javascript or vbscript checks on froms > > file uploads n downloads > > full db manipulation > > the works . > > i didnt know anything but c/c++ n html n veeery basics of a few other > languages . when i started off with php > > so my dear theres no pre-requisite for learnin php > > all u have ot do is do it code it > > :) > > n ull learn php > > good luck > > toby > > --- GaguWD <[EMAIL PROTECTED]> wrote: > If you already know > HTML then you're ready. You can also learn the > > basics of > > JavaScript and know the difference between Server-Side and > > Client-Side > > languages. At least, that worked in my case. > > > > Bye! > > MG29 > > > > -Mensaje original- > > De: Rocco CAstoro [mailto:[EMAIL PROTECTED] > > Enviado el: Domingo, 09 de Noviembre de 2003 02:30 p.m. > > Para: [EMAIL PROTECTED] > > Asunto: [PHP-WIN] What should I learn > > > > > > What should I learn first, before I learn PHP to make it possible > > to > > actually become skillfull at PHP.. I Already know HTML and have > > worked with > > QBasic DOS Language. > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > Want to chat instantly with your online friends? Get the FREE Yahoo! > Messenger http://mail.messenger.yahoo.co.uk -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
php-windows Digest 13 Dec 2003 19:43:38 -0000 Issue 2040
php-windows Digest 13 Dec 2003 19:43:38 - Issue 2040 Topics (messages 22380 through 22382): Re: querying more than one db from a php page? 22380 by: Svensson, B.A.T. (HKG) 22381 by: Svensson, B.A.T. (HKG) Re: What should I learn 22382 by: Terry Administrivia: To subscribe to the digest, e-mail: [EMAIL PROTECTED] To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] -- --- Begin Message --- You might run into the classical update problem if you allows update in different databases and then wants to syncronize the databases with each other. To prevent update anomalies like this you need a lock mechanism between the databases. Check your RDBMD documentation on this. However if you only do updates on the main site and then propagate the update to the "sub" sites, you might like the RDBMS to handle this by it self, if so you should check if replication between databases can solve your problem. If you do updates from the main site only and propagate them to the sub sites then I do think that you should not run into any particular problem since the aporach is straight forward. -Original Message- From: George Pitcher To: [EMAIL PROTECTED] Sent: 2003-12-12 17:19 Subject: [PHP-WIN] querying more than one db from a php page? Hi, I am developing my main site to run on php/mysql (currently lasso/filemaker). I am also developing some individual sites to be hosted on the same server as my main one and I'd like to be able to update those smaller site databases when activity happens on the main site. I'm still a couple of months away from tackling that part but can anyone predict trouble ahead, and if so, any remedies? MTIA George in Oxford/Edinburgh -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- End Message --- --- Begin Message --- Another thought - came to me just after I posted below: If you decides to execute the same update at several databases from a php page, make sure that you actually did update all databases! Because you might like to rollback the update on all database if you fail with one for them, especially if you was not able to update the main site. However it is up to the design process to decide how much inconsistency that might be allowed betwen the databases. -Original Message- From: Svensson, B.A.T. (HKG) To: 'George Pitcher '; '[EMAIL PROTECTED] ' Sent: 2003-12-13 09:47 Subject: RE: [PHP-WIN] querying more than one db from a php page? You might run into the classical update problem if you allows update in different databases and then wants to syncronize the databases with each other. To prevent update anomalies like this you need a lock mechanism between the databases. Check your RDBMD documentation on this. However if you only do updates on the main site and then propagate the update to the "sub" sites, you might like the RDBMS to handle this by it self, if so you should check if replication between databases can solve your problem. If you do updates from the main site only and propagate them to the sub sites then I do think that you should not run into any particular problem since the aporach is straight forward. -Original Message- From: George Pitcher To: [EMAIL PROTECTED] Sent: 2003-12-12 17:19 Subject: [PHP-WIN] querying more than one db from a php page? Hi, I am developing my main site to run on php/mysql (currently lasso/filemaker). I am also developing some individual sites to be hosted on the same server as my main one and I'd like to be able to update those smaller site databases when activity happens on the main site. I'm still a couple of months away from tackling that part but can anyone predict trouble ahead, and if so, any remedies? MTIA George in Oxford/Edinburgh -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- End Message --- --- Begin Message --- I agree with toby just start working away... To learn PHP I dl code examples and projects from the web, there are a number of tutorials and examples out there on the web. The only way your going to learn to use the language is to "use the language" ... tashfoo "Toby z" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > well get or make ur self a project . include as many modules > as u can think of > > start codin in php > > go for javascript or vbscript checks on froms > > file uploads n downloads > > full db manipulation > > the works . > > i didnt know anything but c/c++ n html n veeery basics of a few other > languages . when i started off with php > > so my dear theres no pre-requisite for learnin php > > all u have ot do is do it code it .
