mysql Transaction support

Discussion in 'PHP' started by r_honey, Jun 19, 2007.

0
  1. #1
    I could not find any functions in PHP that provide transaction support for mySQL. So, are there any such functions available??

    Moreover, are there any classes available that provide OO interface to mysql interaction via PHP???
     
    r_honey, Jun 19, 2007 IP
  2. e39m5

    e39m5 Peon

    Messages:
    44
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    To run a query you use the mysql_query() function. There are probably many classes to handle queries, I personally have used adodb

    http://adodb.sourceforge.net/

    e39m5
     
    e39m5, Jun 19, 2007 IP
  3. UnrealEd

    UnrealEd Peon

    Messages:
    148
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #3
    you can use the PEAR DB package: this includes interfaces for most common database.
    I can't post the url yet (don't have enough posts :s): but just remove the whitespace from the one below:
    pear. php.net/package/DB
     
    UnrealEd, Jun 19, 2007 IP
  4. r_honey

    r_honey Peon

    Messages:
    30
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    After some frantic searching, I found about the following PHP libraries & PEAR packages:
    mysqli, PDO, ADODB, PEAR DB & PEAR MDB2.

    Well, I am not necessarily looking at DB portability. I am looking at a library that provides some efficiency, makes more programming sense & structure than that provided by raw PHP mysql functions & is easy to maintain.

    Going by that criteria, I have zeroed on to ADODB & PDO. So, can anyone tell me which of these (from all the 5 listed above) will be more suitable for my criteria?

    Also, does any of them has specific mysql Engine requirements???
     
    r_honey, Jun 19, 2007 IP
  5. krt

    krt Well-Known Member

    Messages:
    829
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    120
    #5
    Unless you are using a DAL (see below), transactions are managed through SQL queries.

    There is an OO interface in PHP5, see mysqli (note the "i"), or you can use a database abstraction layer (DAL) such as adoDB and PDO. I would stay away from Pear::DB though.
     
    krt, Jun 19, 2007 IP
  6. UnrealEd

    UnrealEd Peon

    Messages:
    148
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Why, did you have any problems with it? I've been using it for a couple of years now, it never let me down. I think it's a great alternative if you don't have the PDO dal installed
     
    UnrealEd, Jun 20, 2007 IP
  7. krt

    krt Well-Known Member

    Messages:
    829
    Likes Received:
    38
    Best Answers:
    0
    Trophy Points:
    120
    #7
    It seemed that it tried to be a god class, was not structured properly into classes and derivations for connections, queries, query results and transactions etc. Also, I remember just include()'ing the file was enough of a performance hit.
     
    krt, Jun 20, 2007 IP
  8. r_honey

    r_honey Peon

    Messages:
    30
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Going by the advices above & my own searching, I am narrowing down to just PDO. I again stress that I am not lookking for DB portability. I am looking for some efficiency, & more importantly, a well-structured class hierarchy so that it can be used & maintained easily in PHP code...

    Any suggestions???
     
    r_honey, Jun 20, 2007 IP
  9. tamilsoft

    tamilsoft Banned

    Messages:
    1,155
    Likes Received:
    78
    Best Answers:
    0
    Trophy Points:
    0
    #9
    You can directly pass transaction queries like 'BEGIN','COMMINT','ROLLBACK' via mysql_query() function.
     
    tamilsoft, Jun 20, 2007 IP