BeginTrans in ASP

[Anon]

Hi,
Could you please give me a hand?
Is there anybody who can tell me that the same function in PHP as BeginTrans in ASP?
I will appreciate for your help.
I have read the PHP manual, but I can't find it.

[Anon]

BeginTrans starts a database transaction. PHP does not offer a built-in database abstraction layer, so you would need to use the database-specific function for doing this. What dbms are you using?

[Anon]

Hi,
thanks for your reply.
BTW, I use Postgre SQL, what can I do to resolve the question.

[Anon]

You're in luck; PostgreSQL makes it very easy--just issue the queries 'begin', 'commit', and/or 'rollback'. For example, assuming $conn is your database connection handle:

pg_exec($conn, 'begin');
if (pg_exec($conn,'delete from detail where id = $id')
  && pg_exec( $conn, 'delete from master where id = $id'))
    pg_exec($conn, 'commit');
  
else
  pg_exec($conn,'rollback');