Re: [PHPLIB] Atomicity From: Arno A. Karner (karner <email protected>)
Date: 02/29/00

My opinions are my own and not that of my employer even if I am self employed

On Mon, 28 Feb 2000, Kristian Koehntopp wrote:

> On Mon, Feb 28, 2000 at 12:30:07PM -0500, Shandy Brown wrote:
> > Does anyone know a good way to do an atomic transaction with PHP/MySQL?
>
> There are no ACID transactions in MySQL, because there is no rollback.
>
> For A (atomicity), check the LOCK TABLE and UNLOCK TABLES
> statements in your MySQL handbook and have a look at the
> nextid() function in DB_Sql.
>
> Kristian
>
Ive seen the lock functionsin DB_Sql, and ive ask this question b 4, and
gotton no answer. if apache, amd mod_php are pooling connections based on
host, db, username, password. how do i make sure that the connection i
currently have is unique, so that so that another connection doesnt share
my connection and insert sql statments inbetween my BEGIN/LOCK, and
COMMIT/ROLLBACK/UNLOCK
or am i worring about nothing, i just want to design my stuff right, and
understand where my problems are going to come from, instead of tring to
trouble shoot a concurent use problem on a live application

im using postgresql 6.5.3, phplib 7.2, apache 1.3.9, redhat 5.2

> -
> PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
> To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
> the body, not the subject, of your message.
>

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.