Urgent help need-Mysql-Row level locking

Discussion in 'PHP' started by attugopan, Nov 26, 2009.

  1. #1
    I am developing a site that need mysql row level locking. I am using phpmyadmin.

    How can i write php program that use mysql row level locking??

    any help will be appreciated...

    Thanking you in advance.
    Gopan
     
    attugopan, Nov 26, 2009 IP
  2. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #2
    keep table engine as InnoDB which has row level locking. Plus you can also use transactions to keep set of critical operations combined as Atom.
     
    mastermunj, Nov 27, 2009 IP
  3. attugopan

    attugopan Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks for your reply...

    My question is that how can we implement transaction & row level locking in mysql via php??
    is it possible via stored procedure??
    can you show some sample codes??

    Thank you in advance
     
    attugopan, Nov 27, 2009 IP
  4. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #4
    mastermunj, Nov 27, 2009 IP