note 102534 added to function.mysql-connect
[email protected] Sat, 19 Feb 2011 14:04:26 -0800
| Newsgroups | php.notes |
|---|---|
| Message-ID | <[email protected]> |
I hope to help someone with this solution. Recently I had many problems with updating and inserting records into mysql in more than one connection. The scenario: multiple connections to remote MySQL, and PHP CLI (php-gtk). When not initiated a transaction to update a record when another user attempted to update the same record the script crashed and no longer came up as the connection was resumed. Solution, for each change or insert start and end the transaction with mysql; BEGIN and COMMIT; ---- Server IP: 189.126.97.120 Probable Submitter: 189.63.103.31 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-connect.php Edit -- https://master.php.net/note/edit/102534 Del: integrated -- https://master.php.net/note/delete/102534/integrated Del: useless -- https://master.php.net/note/delete/102534/useless Del: bad code -- https://master.php.net/note/delete/102534/bad+code Del: spam -- https://master.php.net/note/delete/102534/spam Del: non-english -- https://master.php.net/note/delete/102534/non-english Del: in docs -- https://master.php.net/note/delete/102534/in+docs Del: other reasons-- https://master.php.net/note/delete/102534 Reject -- https://master.php.net/note/reject/102534 Search -- https://master.php.net/manage/user-notes.php