CodingForums.com - View Single Post

Old Pedant · 02-20-2013, 01:36 AM

Short answer: No.

There are ways to accomplish row locking, but they only last so long as the connection to the DB is maintained. So you couldn't maintain a connection very well from PHP. You'd have to do it from, say, a command line window where you never closed the window.

A better way to do this is probably to use a VIEW or STORED PROCEDURE. (Besides, DB purists will urge you to do *ALL* web-based work on the DB via one of those and *NEVER* make ad hoc SQL queries!)

Your VIEW or PROC simply provides a default record if no record is found.

02-20-2013, 01:36 AM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,248 Thanks: 59 Thanked 3,999 Times in 3,968 Posts	Short answer: No. There are ways to accomplish row locking, but they only last so long as the connection to the DB is maintained. So you couldn't maintain a connection very well from PHP. You'd have to do it from, say, a command line window where you never closed the window. A better way to do this is probably to use a VIEW or STORED PROCEDURE. (Besides, DB purists will urge you to do ALL web-based work on the DB via one of those and NEVER make ad hoc SQL queries!) Your VIEW or PROC simply provides a default record if no record is found. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.