PHP Unlock-Lock Technique using mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
jakeneuman
Forum Newbie
Posts: 10
Joined: Mon Mar 01, 2010 3:12 am

PHP Unlock-Lock Technique using mysql

Post by jakeneuman »

hey guys can you help me with these?

lock data when someone using an update and unlock after or canceling an update.

thanks
AlanG
Forum Contributor
Posts: 136
Joined: Wed Jun 10, 2009 1:03 am

Re: PHP Unlock-Lock Technique using mysql

Post by AlanG »

MySQL handles table-level and row-level locking automatically. If you want table-level locking, use a MYISAM storage engine, for row-level locking use a INNODB storage engine.

It sounds like row-level locking is what you are looking for.
jakeneuman
Forum Newbie
Posts: 10
Joined: Mon Mar 01, 2010 3:12 am

Re: PHP Unlock-Lock Technique using mysql

Post by jakeneuman »

yup its row-level locking that i am looking for. btw, what is the use of INNODB?
Post Reply