[PHP-DB] apache/php/mysql - guarenteed DB transaction

2004-02-04 Thread whynotpizza
Hi all. Question on running in a config with Apache2,PHP 4.3.4,MySQL 4.0.17 running on Linux Redhat 9.0. Basically I want to make sure that a DB insert or update is guarenteed to complete. So if a user hits submit on a webpage, the transaction under the hood completes, no matter if the user

Re: [PHP-DB] apache/php/mysql - guarenteed DB transaction

2004-02-04 Thread Matt Matijevich
snip So if a user hits submit on a webpage, the transaction under the hood completes, no matter if the user hits cancel or his browser dies or whatever. (Not sure how to even test this condition, but I know it will happen) /snip Once php has the request, hitting cancel on the browser or a browser

Re: [PHP-DB] apache/php/mysql - guarenteed DB transaction

2004-02-04 Thread Jason Wong
On Wednesday 04 February 2004 23:46, Matt Matijevich wrote: Once php has the request, hitting cancel on the browser or a browser dying will not stop the php script from executing all the way through. Actually whether the script runs through to completion depends on the 'ignore_user_abort'

Re: [PHP-DB] apache/php/mysql - guarenteed DB transaction

2004-02-04 Thread Matt Matijevich
snip Actually whether the script runs through to completion depends on the 'ignore_user_abort' setting. /snip wow, guess you learn something everyday. wish I would have known about that when I wrote a php script with some terrible (lots of joins, just poorly designed) queries that took down my

RE: [PHP-DB] apache/php/mysql - guarenteed DB transaction

2004-02-04 Thread whynotpizza
] apache/php/mysql - guarenteed DB transaction snip Actually whether the script runs through to completion depends on the 'ignore_user_abort' setting. /snip wow, guess you learn something everyday. wish I would have known about that when I wrote a php script with some terrible (lots of joins, just

RE: [PHP-DB] apache/php/mysql - guarenteed DB transaction

2004-02-04 Thread Matt Matijevich
snip Suppose I have several DB transactions that I want to treat as 1 logical transaction that I need to complete guarenteed. For instance, an INSERT to one table, and a DELETE to another, and an UPDATE to a third. All need to complete once a user selects submit. What's the best approach to this

Res: [PHP-DB] apache/php/mysql - guarenteed DB transaction

2004-02-04 Thread Ricardo Oliveira
Hi, I had a similar problem andI solved it using transations, but I had to use InnoDB table types... Regards, Ricardo ---Mensagem original--- De: whynotpizza Data: 02/04/04 15:33:37 Para: [EMAIL PROTECTED] Assunto: [PHP-DB] apache/php/mysql - guarenteed DB transaction Hi all

Res: RE: [PHP-DB] apache/php/mysql - guarenteed DB transaction

2004-02-04 Thread Ricardo Oliveira
: whynotpizza Data: 02/04/04 20:39:13 Para: 'Matt Matijevich'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: RE: [PHP-DB] apache/php/mysql - guarenteed DB transaction Thanks guys, this is great info. One last thought, Suppose I have several DB transactions that I want to treat as 1 logical transaction

[PHP-DB] Apache+PHP+MySQL installation at once - HOW?

2001-05-04 Thread Vojtech Dvorak
Hi, I want to install this great trio Apache+PHP+MySQL and don't want it install step by step, program by program. I remember, that I saw somewhere some prepared package for very fast and comfortable installation of these three at once. Don't you now where I can find it? Thanks Vojtech -- PHP

Re: [PHP-DB] Apache+PHP+MySQL installation at once - HOW?

2001-05-04 Thread Russ Michell
I remember, that I saw somewhere some prepared package for very fast and comfortable installation of these three at once. Don't you now where I can find it? Thanks I think you wanna be going to: http://www.phpgeek.com/phptriad.php Good luck! Russ. On Fri, 4 May 2001 09:45:41 +0200 Vojtech

Re: [PHP-DB] Apache+PHP+MySQL installation at once - HOW?

2001-05-04 Thread Roel Mulder
Another option is http://www.firepages.com.au/devindex.htm Look for phpdev3: Apache, PHP, MySQL and phpMyAdmin in one zip, for windows platforms. all yours, Roel Mulder At 10:31 04-05-2001 -0500, you wrote: At 9:45 AM +0200 5/4/01, Vojtech Dvorak wrote: Hi, I want to install this great trio

[PHP-DB] Apache, PHP, MySQL

2001-04-27 Thread Robert Staph
I'm having a spot of trouble getting the php-mysql-4.0.1pl2-9.i386.rpm package to install. Its a Redhat 7.0 installation with MySQL 3.23.36-1 installed. I'm currently using MySQL with ICRADIUS0.17b so I know that MySQL is installed and working yet I get: rpm -i php-mysql-4.0.1pl2-9.i386.rpm